OnSelect: Export multiple CSV from a filtered list

(0) Share

Report

Posted on by SanchezITM

153

Hi guys,

I have one list with 200 devices asigned to 200 users from 5 companies.

I want access to an App, see the list and with one click export 5 .csv to OneDrive , one for each company with the user and devices asigned.

How can I do this? maybe I need flow or something?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-xida-msft on at

Like (1)

Report

Hi @SanchezCSG,

Do you want to export 5 CSV files to a OneDrive folder within an app?

Could you please share a bit more about your scenario?

If you want to export 5 CSV files to a OneDrive folder within an app, I afraid that there is no way to achieve your needs in PowerApps currently.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Kris

Was this reply helpful? Yes No
jaytavare18 6 on at

Like (0)

Report

hi, @SanchezCSG facing the same issue, if you have found any solution please share with me.

Was this reply helpful? Yes No
SanchezITM 153 on at

Like (0)

Report

Maybe this works for you. Create 1 power automate that you can start from a button un powerapps like in the image. If you have 5 companies, create 5 parallel branches in this power automate.

flow.png

Was this reply helpful? Yes No
jaytavare18 6 on at

Like (0)

Report

Appreciate the quick response @SanchezCSG , thanks but the condition is
for ex:- SharePoint lists is having data of one year (12 months ) and when we filter gallery from start date:- jan 2022 to End date:- april 2022 and export to csv it should create 4 .csv files for each months, facing issue with creating more than 1 .csv file. start and end date can be changed by user to export.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @jaytavare18 ,

You just need four exports with

Filter( GalleryName.AllItems, DateField >= YourStartDate && DateField <= YourEndDate )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No