How to Export a PowerApps Gallery to CSV File using Power Automate | 2023 Tutorial

Hi Everyone,
In this video I demonstrate how to export a filtered PowerApps gallery to a CSV File using Power Automate. This does involve sending a collection over to Power Automate and then returning the URL Link.
If you enjoy my video feel free to like, comment, and subscribe.
#powerautomate #powerapps #microsoftflow

[@werachaisrisupinanont3353]

Cool , Thanks a lot

[@moeking5601]

works like a charm 👍👍

[@alexmoller5657]

Thanks so much, this was so helpful - I have been stressing about this for a few days - you solved it in 20 minutes 😁

[@c.mdsalih]

Excellent video with clear explanation. Exactly what I was looking for and it worked. Thanks a ton 👍

[@emmanuelnamanja5646]

This perfect!!!! youre the man

[@michaelalex2322]

Haha thanks, glad to help!

[@bujjibabukj9616]

Hi, Perfect..... Working fine Thank You

[@michaelalex2322]

Welcome 👍

[@DiyEverythingAlways]

Great video!

[@michaelalex2322]

Glad you enjoyed it!

[@chihab7673]

thanks you so much

[@JenMayB]

Thank you! I definitely need help w how to get clean output for people picker and choice boxes.

[@rajarajacholan4110]

Thanks, this video is more helpful to learn powerapps

[@michaelalex2322]

Glad it helped

[@aimeeoneil7029]

Thank you... helped me out once again

[@michaelalex2322]

Glad to hear it!

[@keimomomon]

This is very helpful! Thank you for sharing 🤩

[@michaelalex2322]

Glad it was helpful!

[@mateohidalgo2728]

De todos los tutoriales que he buscado, este es el único que me ha funcionado, gracias un nuevo suscriptor :)

[@michaelalex2322]

¡Gracias por las amables palabras!

[@gihanwijesinghe3466]

Thanks

[@michaelalex2322]

No problem!

[@vasilikievangelou9518]

Hello thanks for you video, I managed to implement it, however the exported file gives only the first 100 rows. Any idea of how I could resolve it?

[@TheMayank1000]

Thanks for this video Michael. Can you pls guide how to get exact data from choice fields

[@gracesantos9868]

hello, did u manage to make the app for data with choice fields?

[@TheMayank1000]

@@gracesantos9868 yes

[@daeracosta2484]

Hi Michael, I like your video, it helped me a lot. I have a question, what license or add-on do your users use to download Excel files from that app? In my work i have an Office 365 license but not all my users have it, so can I request only the pugin to download the Excel report?

[@michaelalex2322]

I think they need a Power Automate Basic License. I assume they'll need this to run the Flow creating the CSV File

[@samoabano]

I understand json doesn't handle lookup values, is there some kind of work around?

[@user-xs7km2mk3u]

Such a good Tutorial, thank you. When I repeat your steps all the data is stored in one column. Does anybody have a solution for this problem. Also my Data looks exacly like yours in the Test Flow Steps. Thanks for the help in advance.

[@michaelalex2322]

Make sure you include the JSON formula in your PowerApp and in Power Automate

[@KristofferFortuna]

great video man..how do you remove the "Value: " prefix in multiple selection sharepoint column in Select expression?

[@michaelalex2322]

item()?['ColumnName']?['Value']

[@marco-ys1oi]

I have tried to replicate it step by step but now PowerApp has been replaced with PowerApp V2 and I can't find the "Compose" action as shown at min.3:00 of your video. Any idea ? thanks!

[@lauramay35]

Unfortunately, I can't help you, but I have the same problem :/

[@ivioe17]

How to do a complex columns same as your example? I have a columns that has a person &group type and i want to grab the display name into my csv file.

[@user-qh3fo8cf5b]

Thanks working great but I'm having trouble with getting attachment link being downloaded, how to fix it

[@yedumkaimal8051]

Thanks for this great video. However when I click the download, it shows Sharepoint link got expired.

[@mickyslim1000]

Hi, thanks, this video has really helped me get further in 20 minutes than I have in days. I do still have an issue with some choice fields throwing an error that the value doesn't exist. I get a longer message, but the error is 'Action 'Select' failed' Any advice on this please??

[@mickyslim1000]

I should add, the flow works if i dont add the ['Value'] on the choice fields

[@mickyslim1000]

All sorted, rebuilt it again and is working fine… for now 👍🏻

[@michaelalex2322]

Haha, glad you were able to solve it!

[@KristofferFortuna]

@mickyslim1000 how did you solved it?

[@tomasborghi4566]

Great video! Is there any way to handle special characters. Example, the á is being showed as á

[@michaelalex2322]

Haven't dealt with special characters yet. I would reach out to the Power Apps forums.

[@jl1399]

what if the results need to be greater than what is currently shown in the gallery?

[@Sabilainaa]

Hi my function not working even though I tried all instructions, it comes message the function Json has some invalid arguments. Idk what's the mistakes 😢

[@yedumkaimal8051]

Same here

[@breadandcheese1880]

Great video, question - Is there anything different to do if my data source is dataverse?

[@breadandcheese1880]

Nevermind i found the answer - However another question - Any way i can rename the headers prior to downloading the file?

[@michaelalex2322]

I would rename them in the Select statement in Power Automate

[@user-wl7ze2ct1l]

how to fix select outputs body was "Requestor Email" : null ?

[@deepaksartape9502]

Thank you so much. This is amazing video. Can we set the column width before export the data into excel/csv?

[@user-ls9cf4mf5r]

Hey Michael - I only have PowerApps V2 as an option, which says it has no dynamic content. Which means no "Ask in PowerApps." So I'm basically stuck at a very early step. Do you have any advice?

[@Ponyboy-dj7dj]

Same problem here

[@michaelalex2322]

Looks like they removed the action. I'll have to figure it out

[@ericw.3250]

Choose "Text" in the PowerApps (V2) part (and maybe rename it) and in the compose (data) as input chose the name you gave it (not the body)

[@lauramay35]

I have the same problem and I can't fix it

[@raymundjunio580]

Power Apps 2 - Upon creating the flow next in compose not show the ask in power apps and Data_inputs? 3:33

[@narendracanvas]

what is the formula to do for choice field in select data operation

[@michaelalex2322]

You will need to replace your variables. My Full OnSelect: Patch( 'Employee Data', LookUp( 'Employee Data', Title = ThisItem.Title ), { 'Favorite Fruit': { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: 1, Value: cmb_fav_fruit.Selected.Value } } )

[@adobestock7048]

Thanks, your video is very useful, but for choice column and lookup column didn't work with me, i user Dataverse, can you help me.

[@michaelalex2322]

Not familiar with Dataverse, so I can't help much

[@petrusottie7411]

@AlexMichael....Hi ...I have a sharepoint list that has a boolean column where by if the value is TRUE it will put a right sign otherwise no value if it is FALSE. To my surprise when I export the records from canvas powerapps the exported CSV file does show any value in that boolean column. Please help

[@michaelalex2322]

I assume if nothing was ever entered in the boolean column it would return null. You'll have to account for that in your PowerApp, if null then set to false

[@petrusottie7411]

@@michaelalex2322...I see that could be the reason...thank you so much.

[@user-lq7zc7um7e]

Hi, mine is opening the online excel file instead of donwloading it directly.

[@caroltasseff1827]

I’m stuck at the Select step. For my items()? expressions I am using things like items()?[‘PARENTID_x003a__x0020_RESERVE’][‘Value’]. When I try to save the flow, I get an error that says “The template validation failed….The template language function ,items, must have at least one parameter.” Can you offer any suggestions as to what I am doing wrong? Thanks!

[@michaelalex2322]

You can try adding a question mark between [‘PARENTID_x003a__x0020_RESERVE’] and [‘Value’] (items()?[‘PARENTID_x003a__x0020_RESERVE’]?[‘Value’]). That would make the Value optional if there is no value there. Could be why you're getting that issue

[@powerplatformninjas]

Any update for PowerApps v2?

[@michaelalex2322]

kzbin.info/www/bejne/f4mQfKmjlMdskLM

[@damnbeliefs]

How do i do it with powerapps v2? is not showing me ask in power apps

[@michaelalex2322]

kzbin.info/www/bejne/f4mQfKmjlMdskLM

[@eyll1234]

Thanks so much for the video, it was really helpful. But when I export the grid data and test the flow, it shows "{""Value"":""Apple""},{""Value"":""Orange""}" in one of the fields in the csv file. How can I replace the "{""Value"":"" and just simply shows "Apple, Orange"? Thanks a lot again.

[@rookybeats]

Hey! Try " item()?['colname']?['Value'] "

[@eyll1234]

too bad it failed ...it said "Array elements can only be selected using an integer index."

[@michaelalex2322]

Basically, you have to concatenate all the array elements into a string. You have to use Compose action with the Join function on whatever variable is holding the data

[@eyll1234]

sorry I tried that too .... but the "create CSV table" action expects array .... I have trouble converting the string back to the array for creating CSV file. @@michaelalex2322

[@mhochups2]

How can I do this with image files?

[@michaelalex2322]

I haven't done this with image files and don't know if it's possible. I'm sending the data over as JSON and I don't know how JSON and image work together.

[@lsh_52]

thank you so much, this video helped me a lot to build my own project

[@michaelalex2322]

You are welcome!