Skip to content

Export Data from PowerApps Gallery to Excel

April 15, 2022
  1. First Create a excel template with column headers in SharePoint library/Shared drive.

For my requirement, following are the Column Headers:

Id, Log Types, Date Entered, Date of Effort, Effort Hours, Comments.

2. Create a Flow in Power automate as shown below:

3. In power apps application, add a button, then write below functions for OnClick property.

//Set a Header variable
Set(HeaderVar,”Id,Log Types,Date Entered,Date of Effort,Effort Hours,Comments”);
//Clear the collection


//Collect the data for all records within the gallery

//Create a variable to store Header variable and collection data


//Run the flow and then get the link and save it to variable

//Use Launch to open the file in browser

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: