Export filtered gallery records to CSV file from PowerApps | Export to CSV | Power Automate FLOW

In this video we will look at the best approach to export gallery records to a CSV file from PowerApps. In this approach we will overcome some of the limitations as well.
Composing the query
----------------------
concat(if(not(equals(variables('Project'),'All')),concat('Project eq ''', variables('Project') ,''' and '),''),
if(not(equals(variables('Contract'),'All')),concat('Contract eq ''', variables('Contract') ,''' and '),''),
if(not(equals(variables('Status'),'All')),concat('ApprovalStatus eq ''', variables('Status') ,''''),''))
Clearing last extra and
---------------------------
if(endsWith(outputs('Compose'),' And '), substring(outputs('Compose'),sub(length(outputs('Compose')),5), length(outputs('Compose'))), outputs('Compose'))
Check out more videos here
• Manage SharePoint Perm...
Check out more articles on Power Platform from here
www.c-sharpcorner.com/members...
#ExportToExcel#ExportToCSV#PowerApps

[@aducaale328]

Thank you very much.At least I have ia concept how to resolve my filtered data from powerapp to flow with choice columns. Thank you for explaining as much as you. Will hope to work my filtered data, which includes StarDate and EnDate.

[@MrDionmar]

Excelent!!!! Tks a lot!

[@caroltasseff1827]

Thanks for the helpful video! Would you mind sharing how I might write a query for a gallery filtered by only one parameter, that being in a textinput box? My users will enter a reservation number into a text box to filter the gallery. I would appreciate the help very much!!!

[@adelinebondjali8116]

Thank you so much for this tutorial. That's helped me a lot. I have one question : how did you manage to get the 'All' option in your dropdown in Power Apps?

[@rajkumarkrishnan7817]

This is a great video, very informative and exactly what I was looking for, thank you! One question - how we can export filtered gallery items to a formatted MS Word template?

[@AnanyaSri-yg6is]

Hi sir, Great video but thing is if u elaborate each and everything it will be use full. If we had a search function there we are filtering the seach results and displaying in grid view if we click on export to Excel it will download the display results in csv file all this should come from SharePoint list. Can i get this video if possible. Thanks Sandhya Ch

[@tallmuscleguyqc]

Thank you for the video, Do you know how to do the same with Dataverse Table instead of sharepoint list in PowerApps

[@jamiethompson9419]

Super helpful video! I followed precisely, changing only my filter names and my flow is failing at the Query Value with error: The length of substring can't be longer than '58' which is the length of the source string. Any idea on how to fix this?

[@ABHEEE1]

Thank you, but this flow is not working or showing array data if we have multiselect fileds in sharepoint. I am not getting the error but output file is having fieldname\":[{\"Value\":\"xyz\"}] instead of just getting the value.

[@filipemarques7425]

Hi! First of all, thank you for this amazing video! I'm with a little dificult with the step "Query Value", after the compose. Can you explain it to me and help me to do it?? Thank you in advance.

[@darshantani898]

Hi Sarvesh, How can we display All records in filter using gallery? I want to display all 7000 items when user clicks All in gallery

[@atikahtuah3892]

Atikah Tuah do you know how to export pdf attachments/viewer to excel?

[@ThreeWhiteSoldiers-jr2sy]

i am using SQL as backend, please guide sir

[@dijanatodorovic5099]

Hi Sarvesh, thank you for this video, its very usefull. I followed it quite literally, the part with export to csv that i needed mostly, so my flow looks the same, however, the file does not open by itself. Initially, i had it opening from One drive in a new tab, but now not even that. When i open the link created in a flow, the csv file is there in Sharepoint, and only then starts download, but obviously, the user of the app needs the excel file opening when click on a button in app and not copying the link from the flow. Do you have any advise, what is missing on my side?

[@SarveshShinde]

Hi Dijana, Do check the pop up block setting in browser. Browser blocks the launch function in powerapps to open the link in new tab. Try different browser if u are not able to find pop up block setting. Also make sure flow is returning the url back - for test purpose use that link and show a html text control on ur app. Hope this helps.

[@dijanatodorovic5099]

@@SarveshShinde thank you, it works now :)

[@sajinshaji6024]

How can we do this with date value

[@arpanbala6984]

This video is helpful. I have a question. I want to restrict only 7 records. How can i do that? I developed in the way you did. Then i want to export the data in a frequency of 7. Suppose i have a record of 14 data. now i want to export first 7 data and then again 7 data. How can i do that?

[@MrDionmar]

Did you tried to use First function ?

[@aducaale328]

Try to see at 20:18 you can choose the columns that you want to be included in CSV file.

[@charlesdawnbeltran9603]

Great Video! Do you have a query samples that values are date?

[@vladimirivanlaroco2491]

Same question. Did you find a solution to this?

[@sanprasa1]

The good content however the presentation is the worst, you should have to do it from scratch.

[@narenranganathan7779]

very poor explanation - sorry to say this

[@DonCurrier]

Good video, but I would have liked you to go through each flow step in order and not jump back to compose and Query Value. Also, I have a Search box using sortbycolumns and Filter, with the StartsWith command. Then i have two drop downs to filter Status and part ID. Not sure if this will work on my Buttons OnSelect property. Concurrent( Notify("Exporting your data", NotificationType.Information), Set(varCSVFileURL, ExportTasks.Run(txtSearch.Text,drpStatus.Selected.Value,drpPartID.Selected.Value).fileurl)); Launch(CSVFileURL);