Before I say anything, you click on this link to understand what will happen in this article. This blog will explain how to export custom list view of SharePoint using Canvas APP. Basically this blog is continuation of my previous blog “Get Custom Lists & respective Views using PowerApps Canvas App“.
Let’s go and straight away jump into the solution part of Export Custom List View of SharePoint. Below is the screen of my updated app.
In the above app, I have added four extra labels and an export view button. Each set of labels will store list name & ID and view name & ID respectively.
I have also modified the flow a bit. Basically updated flow screen shot is provide below.
- PowerApps Get Lists Flow
- We have added “;Name” in the value parameter
- By doing above step we are collecting string like “Listname;ListID” in drop down
4. Update Get Views Flow.
5. In this flow also we are storing string like “ViewName;ViewID” in drop down.
Updated code for apps are given below.
1. List Name Label -> First(Split(Dropdown1.Selected.Result,”;”)).Result
2. List ID Label -> Last(Split(Dropdown1.Selected.Result,”;”)).Result
3. Fetch View Button -> Set(viewdetails,GetViews.Run(TextInput1.Text,Label4))
4. View Name Label -> First(Split(Dropdown1_1.Selected.Result,”;”)).Result
5. View ID Label -> Last(Split(Dropdown1_1.Selected.Result,”;”)).Result
6. Export View Button -> Launch(TextInput1.Text&”/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=”&Label5&”&View=”&Label6_1&”&CacheControl=1″)
You can refer this link for more details on Split functionality of powerapps.
By incorporating the above changes your App will be capable of exporting a custom list view. Please refer below demo video for more clarity on the App.
Hope you all will like this article. Please share this post and also subscribe our site for more power platform related articles. Also let us know in comment section if you are facing any issue in Power platform related projects.