How to Export Custom List View of SharePoint using Canvas App

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.

Export Custom List View of SharePoint
Figure 1.

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.

  1. PowerApps Get Lists Flow
  2. We have added “;Name” in the value parameter
  3. By doing above step we are collecting string like “Listname;ListID” in drop down
Get Lists Flow
Figure 2

4. Update Get Views Flow.
5. In this flow also we are storing string like “ViewName;ViewID” in drop down.

Get Views
Figure 3

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.
Thanks.

Sharing is Caring

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top