Showing results for 
Search instead for 
Did you mean: 
Level 8

Export Gallery List to CSV

I would like some help in exporting my filtered data to a csv using Flow.

Basically all i want is to export the exact view of a gallery list , which contains a bunch of filters and lookups.  I was looking at this post here, but i was unable to replicate it.


My Gallery data is obtained through a couple of lookup functions: 

Any help please? 



Community Support Team
Community Support Team

Re: Export Gallery List to CSV

Hi @Pripri804,


You should be able to add the data together with the Concat function:

Concat( Table, Formula )

  • Table - Required. Table to operate on.
  • Formula - Required. Formula to apply across the records of the table.

Read more for how the function works in the article below:

Concat and Concatenate functions in PowerApps




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level 8

Re: Export Gallery List to CSV

 My issue is that i have multiple datasources, with lookup fields to return a specific value. how shall i go about that ?

Level: Powered On

Re: Export Gallery List to CSV

I'm new to this but have an issue which might be easily resolved...


I have created a basic app with 2 data fields per record (StockType,Serial) for basic asset tracking. For our needs I have then created an Input box and associated a flow to enable us to enter a new filename in the Input box and save the Collection data as a new file (if I write .csv at the end it works fine).  The Problem is that my CSV file is coming out without columns. Here is my syntax::


SaveToOneDrive.Run(TextInput3,Mid(Concat(Collection1, "," & StockType & "," & Serial), 2, 1000))


Output that is ghenerated from Powerapps, saved to csv in OneDrive:




But here is my desired output including column formatting:


Stock Type,Serial


Any suggestions on how I can get this formatting included in the process?

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 400 members 2,880 guests
Please welcome our newest community members: