Export CSV from Power Apps

The blog walks you through how you can export items from a gallery into a CSV using Power Automate with a OneDrive for Business connection.
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logitech C922x Po Stream Webcam - amzn.to/3aZlqrt

[@dylanlang5088]

This was very helpful and was exactly what I needed! Thank you so much for the tutorial!

[@DanielChristian19]

Thanks for the compliment Dylan!

[@AdiCristea]

Thank you, Christian, for a great video. Regarding the "you need to have a CSV there, do not delete it!" I would suggest retrieving the link to the file in Power Automate from the Create CSV file action, then pass that to Power Apps, this way we can even have a naming convention (and a different name every single time).

[@kittydoes7600]

This is also a great one. How do you retrieve the link?

[@tesnim89]

Hello how do u do that plz

[@FernandodeGuzmanII]

Whew.. At last! A very informative video on exporting. Thanks Sir Daniel!

[@DanielChristian19]

Hey Jun, Thanks for the compliment and you are welcome!

[@ArohShukla]

Daniel...found this is your one the best videos on Power Apps ...thoroughly enjoyed the video...

[@DanielChristian19]

Hey Aroh! Thanks for the compliment

[@JorisPluy]

A video of more then 2 years, and still helpfull. Thanks for this. 👌👍

[@DanielChristian19]

Glad it helped!

[@cntrlengr]

Great tutorial! A lot more code in the background than I originally thought...but you did a good job of clearing that up and making this fairly easy to follow. Thanks!

[@DanielChristian19]

Glad it helped and thanks very much for the great compliment. Don't forget to subscribe and share my FREE playlist with others.

[@AltaiR123166]

Thank you so much for this simple and useful video. It helps me to understand the basics concepts of using PowerApps+Flow and I was able to create Export to Excel function!

[@DanielChristian19]

Thanks for the compliment and you are most welcome! Don't forget to like my video and subscribe to my KZbin channel. It's a win-win situation.

[@oysterhoys]

Great video, returning the filepath from the Flow improves it even more.

[@DanielChristian19]

Great to hear!

[@petereriksson6859]

I am following all the video demos u are doing and this is one of the very best videos its a A++++ Super Thank you so much for all the time u spending doing this .

[@DanielChristian19]

Thanks for the compliment Peter and you are most welcome. Let me know if there is any Power Apps related topic you'd like me to blog on.

[@MrEk5150]

This works beautifully, thanks Daniel!

[@DanielChristian19]

You're welcome, Eric!

[@kireetiyakkali]

Brilliant! Much needed video. Keep sharing your wisdom.. Thanks a lot

[@DanielChristian19]

Glad it was helpful!

[@issiewizzie]

can you believe I binge watched your uploads .....

[@DanielChristian19]

*Awww shucks* Thanks for the compliment Issie

[@pennaiahnagarajappa5639]

Great video.. helped me a lot. Thank you for taking time and explaining in detail.

[@DanielChristian19]

Your welcome Pennaiah.

[@OnEBlackPower]

Thanks a lot Daniel, it's a very useful and easy to understand guide.

[@DanielChristian19]

Thanks for the compliment, Sword

[@bhainsley]

Really, really helpful tutorial! Thank you for this!

[@DanielChristian19]

You're very welcome!

[@brightonalbert3237]

thank you so much it has been very help full am now ready to show off my skills to my team members thank you once again

[@DanielChristian19]

You are most welcome Brighton. Keep Power Apping!

[@BaoNguyen-ul3fn]

Your videos help me a lot, thank you

[@DanielChristian19]

Glad to hear that!

[@favoredlearns4789]

Thanks a lot @Daniel Christian. This was super easy to follow. two questions please: 1. How can i export the column headers? 2. My data exported on just one row. so instead of having several rows, i had just one row with several columns. Appreciate some insight into these. Many thanks.

[@DanielChristian19]

Hi Favored, Glad you enjoyed the video. Read through the comments above because I have answered the column header question before. To resolve the one row issue, take a look at either the HTML code or the text you are adding. Something is causing this issue.

[@indahpermana4645]

This is amazing. Thank you very much!

[@DanielChristian19]

You're very welcome!

[@petereriksson6859]

Thanks this is so good to learn :)

[@DanielChristian19]

Glad it was helpful!

[@user-wn1fu5ej5e]

Thank so much for knowledge

[@JoseMaria-lx4mr]

Thanks Daniel, This is awsome!

[@DanielChristian19]

Glad you like it!

[@shaiksamad1562]

Excellent Demo

[@DanielChristian19]

Thanks for the compliment shaik

[@vozdesilencio]

Thanks you. I had to change coma by semicolon, but It works.

[@fibonacci9445]

Hi, how about if there are big spaces on the data? it's forcefully going to the next line and messes up the fields. Need help please if someone encounters the same issue

[@ramakavitha]

Thanks you very much, very helpful.

[@DanielChristian19]

Glad it was helpful!

[@aakashjaiswal2003]

Superb video! Learned so many extra things! Daniel, can you suggest how to create an empty onenote notebook?

[@DanielChristian19]

Hi Aakash, Glad you liked the video. I haven't worked with creating OneNote netbooks before. Based on several discussions I have had with fellow Business Solutions MVPs, when it comes to OneNote, Power Automate does a better job. Hope this helps!

[@Lethe515]

Thank you, this is a great job! you safe my night XD

[@DanielChristian19]

Hi Emmanuel, Glad I could help!

[@fabioalfieri4979]

Thank you Daniel, very helpful! Would you mind to explain how we can add the header in each column in the file? Thank you.

[@DanielChristian19]

Hey Fabio, The easiest approach is just to add a piece of text at the beginning, before the concat function, with the column names, something like this: "ColumnA, ColumnB, ColumnC,ColumnD"&Char(10)&Concat(...

[@anandasuresh1]

This video is incredible. It helps me a lot. One question, when I share the app with others they can't download the same data what they are seeing in the app.

[@DanielChristian19]

Thanks for the compliment. Sharing the app by default doesn't give them permission to the data source so have to take care of that. Also the CSV conversion happens in their OneDrive. Hopefully this all answers your question.

[@soloposmenu]

Guao, thanks for the full demonstration. I did see that the Flow process keeps appending (first from California then from Arizona). It might be that ExportCSVCol is not cleared or the Flow process understand that I want to append instead of overwrite when the file is the same name. I will check on my side. Thanks again for sharing your knowledge with us.

[@DanielChristian19]

Your welcome Solo!

[@oysterhoys]

Great video by the way !

[@DanielChristian19]

Thanks pal. Don't forget to Like my video(s) and Subscribe to my channel.

[@oysterhoys]

@@DanielChristian19 Just did!

[@aarinwalker5858]

Thank you for posting this video. I built my flow accordingly, but am running into issues with the CSV file format. I have one column that has multiline records. When I open the csv file created with this flow, excel starts a new row for each line in that column's records. Is there a way to set up the columns in the collection variable (minute mark 16:04) that will allow multiline records?

[@supawadeeseeband7283]

Thank you very much for this video.

[@DanielChristian19]

You are very welcome

[@innovate3382]

The best video 😍

[@DanielChristian19]

Thanks Arliso and YES! IMHO it is the best video 😄

[@RahulKumar-xj4zo]

Thankyou Daniel this was very helpful. Just one help I needed is that how can we add headers to that csv file?

[@DanielChristian19]

You are welcome. I have answered this a few times in the comments. Take a look

[@lavanyagurrapu704]

Hi, The video is very helpful. For me, all the data stored in row wise. I need it in column wise. can you help.

[@BobSmith-it9lb]

Hi Daniel, thanks for posting this video is has been incredible useful and your comments eg working out how to put column headings in. In regards to horizontal galleries, is there an easy way to transpose the data? If I use the method above, the csv file changes the format to what you would expect from a vertical gallery. Thanks

[@DanielChristian19]

Hi Bob, You'll need to come up with some creative ideas to make the horizontal gallery look like the vertical. Some ideas I can think of are using the wrap count property and also max the data card height. Hope this helps and keep power apping!

[@Ali-ds5iy]

new subscriber you got Daniel.

[@DanielChristian19]

Awesome thank you!

[@shefalichaudhary8722]

This was helpful for me. Great explanation Daniel.Additionally, I need to include Column names as well in the CSV, Could you suggest the solution for it?

[@DanielChristian19]

HI Shefali, The easiest approach is just to add a piece of text at the beginning, before the concat function, with the column names, something like this: "ColumnA, ColumnB, ColumnC,ColumnD"&Char(10)&Concat(...

[@sahayasathish6211]

Thanks a lot for your video

[@DanielChristian19]

You are most welcome

[@RahulKumar-xj4zo]

But the file link which is pasted in launch function will be a manual task. Can we define in flow that whenever the csv file is created than automatically link will be generated for the specific user and file gets downloaded.

[@p_borjinmotion]

very helpful!

[@DanielChristian19]

Glad it was helpful!

[@subrataranjanpal6518]

Excellent !!!

[@DanielChristian19]

Thanks Subrata!

[@ZagzookGames]

Awesome work around I was even able to get the headers I have to deal with commas in my description but that my issue the question I have is that my collection is not starting new every time it just adds to the end how can I clear my Collection??

[@ZagzookGames]

I found the fix it is using the Clear function not the ClearCollect function. Now just need to fix the existing commas in my data that are not part of the column separation. If you all have any ideas I will take them thanks

[@rickysydney4208]

Hi Dan..was wondering if you can save the file to a Sharepoint library or an FTP location ? and would it be possible to create a folder and save the file? Example the folder will be a name appending with a data in the even you run a request once a month.

[@adwinjha3173]

Thanks for such a great video. One ques I have in my case I am only getting first row of data and it's repeating.

[@DanielChristian19]

Thanks for the compliment, Adwin. Review the formula with the ForAll and Collect functions. Sometimes changing their syntax can do this. Also make sure you are using the Collect and ClearCollect in the right places.

[@luis_ffernando]

Hello @Daniel Christian! This video was very helpful to me, but now I have a little trouble about it. On my computer and my user, it works perfectly, but to other user it doesn't work. Sometime just export one line of the gallery... or does export a different data that of the filtered... since your experience, do you know what could be happening? thanks!

[@DanielChristian19]

Fernando, Save the final CSV to a folder of a SharePoint site. That will take care of the access. In Power apps, check the formula to confirm you haven't done a clearcollect anywhere. That is usually the case to miss information.

[@feltreter1032]

This is very helpful. Daniel, do you have any video which show how to export the filtered results to Word file? Thanks.

[@DanielChristian19]

I don't.

[@paceenterpreneur88]

Awesome video Daniel, Please how can I send the CSV file to the user logged in on the app, instead of downloading it directly. Thanks

[@kanishkaroychowdhury4050]

i am new to powerapp, kindly let me know the field types of your 2 tables like text col or choice col, etc

[@michaelhoangnguyen4077]

Hi Daniel, great video, I wonder if we can add column names for each of the column in the CSV file

[@DanielChristian19]

Hey Michael, Yup you can. I have answered that question in the comments above.

[@jett27]

Thank you for this. I have a question. How do I add the headers before the data itself?

[@DanielChristian19]

Hi Jethro, Read the comments below. Twits asked a similar question and I provided the answer.

[@marcep1455]

Man... It worked like a charm. Amazing, thanks a lot. I'm having only one little trouble, I'dont know why my collection duplicates the first record on the list and obviously also in the csv. Only the first record of the gallery appears twice in the collection (not in the gallery, the gallery shows everything ok). If you know what could be that I'm doing wrong would be awesome.

[@DanielChristian19]

Awesome! Few things I can think of is missing the ClearCollect() or accidentally adding the same formula twice in a OnSelect.

[@marcep1455]

@@DanielChristian19 Thank you so much. Finally I got it! IDK why clearcollect wasn't working but just clear function made it! I'm pretty new at powerapps but watching what you can do like your video really motivate me. Greetings from Argentina!

[@archiedreyes]

Hello and thank you for this elegant solution! I do have a question about sharing the PowerApp/Flow with other users. The export csv is working perfectly for me but anyone I share the PowerApp/Flow with is seeing my data whenever they export a csv. Any ideas? Thank you!

[@DanielChristian19]

Hey Archie, Thanks for the compliment. If you are sharing the connector with your own credentials then it will show your CSV with them. You can either enhance the flow to save the CSV to their OneDrive or you can configure the flow to use their own connector.

[@HypaspistOrange]

This is really fantastic. If I'm doing this for my coworkers to go in and download reports from an app I created, do I just need to give them access to the csv file? I tried editing the Flow folder to access a Teams folder but it kept failing, even though I have access through our company's network

[@DanielChristian19]

Thanks for the compliment. You will have to give them access to the OneDrive where the CSV file is being generated. The users do not need to manually go there to get it since it is downloading. You could add actions to the flow to save the CSV file somewhere else you desire.

[@ChamaCR23]

Nice tutorial, thanks! The only things I didn't like were: 1. Hardcoded link to the file 2.CSV gets constructed without Headers

[@DanielChristian19]

Thanks for the compliment. Take a look at the comments above and I have answered how to add headers.

[@ChamaCR23]

@@DanielChristian19 yeah thanks! Keep it up!

[@fabien67]

Thanks very much, great tutorial ! Just a question . i have an issue , on my collection (ExportCSVCol) i can see all the rows but on the variable ExportCSVWar before run the flow i don't see all of them .What could it be ? I dont have a lot of data like in your example.

[@DanielChristian19]

Hey Fab, You are most welcome and thanks for the compliment. Go through your formulas and check and confirm you haven't done a ClearCollect() some where.

[@richardclowes6166]

Between you and Shane I think my competence in PA has jumped dramatically. Thank you. I went slightly different route and sent the json formatted version of the collection as opposed to you choosing the specific columns. But my question surrounds your comments on at 25.20 of the video where you talk about the .completed. I didn't have that originally and exactly what you said happened. I'm totally perplexed as to why that happens and why doing your workaround solved it. Maybe I should just let it go but is there an explanation for this. 2nd question: since Nov 2019, is this still the best method of allowing the app users to export to Excel?

[@DanielChristian19]

Thanks for the compliment, Richard. Not much has changed since Nov 2019 as far as the over all process goes. If you need to share this PDF with others then you can consider using a SharePoint document library instead. You'll still need OneDrive to make all the transition.

[@mta432]

Thanks for making this video @Daniel Christian and kudos to everyone that had contributed so far. Although, this video was over a year old, but still very relevant and helpful, as I still used the steps to successfully download CSV file on an ongoing project this January 2021. While for some strange reasons, I noticed as at end of February yesterday and today 1st of March, I am no longer able to download both from the older app and the new project I am working on, using the steps given. My troubleshooting shows that the flow ran perfectly and file was created in OneDrive for business, but I discover the that the last 6 characters of the file link now keeps changing, which is making it impossible for PowerApps to Launch the File with the link hardcoded in it. Please, advice on how I am to resolve this. Your guide would be highly appreciated.

[@DanielChristian19]

Hey Adejuyigbe, No idea why it stopped working. Sometimes opening the app, making a slight change like a text change and then publishing it again can help.

[@mta432]

@@DanielChristian19 thanks for your response bro, highly appreciated. Why it stopped working is the fact that , I noticed the file link now generated in the OneDrive for business has its last 6 characters keep changing every time the flow ran successfully to generate the file. So, at PowerApps side, the Launch function wouldn't be able to locate the file to be downloaded, since the hardcoded link in it is now different from that of the newly generated csv file link in the OneDrive. But , as at January, the link on the csv file in OneDrive wasn't changing, but its now having its last 6 characters changing everytime Flow generates the file. Please, can this be reviewed perhaps Flow has updated the way csv file and it's link are generated or could it be OneDrive that has been updated to now be changing the last 6 characters of file link at every File update with same File name?

[@FumbDucker]

Great blog and video Daniel! Question though, how would you deal with commas in a multi-line field? When I attempt to use this method I noticed that if there is a comma in any of text entries it breaks the format because it sees the comma as a new column. Am I missing something or doing something wrong?

[@DanielChristian19]

Hey Jeremy, I've answered similar questions in the comments above including how to add header columns. Take a look

[@FumbDucker]

@@DanielChristian19 Thank you for your quick response back. If I may rephrase my question though; In your solution, what would you do if you wanted to change the default delimiter from "," to ";". In my app I have multi line text fields and our end users use commas, so I need to bring those commas over, but they create new columns and break my formatting.

[@yixie7557]

Great shared video and was very helpful for my current project, I tested working fine for English language , but failed when showed Chinese language , how to solve it ? thanks you so much for this tutorial!

[@DanielChristian19]

Glad it helped

[@jaimetreadwell9228]

Daniel, thanks a lot, I also added the Set(SuccessVar ,"") just below Set(ExportCSVVar,"") to clean also that var,,,,, it was duplicating the values at that var. just a problem,,, if I export a bit more than a word (for example phrases with commas in the middle) they are separating the comments in other square (at Excel)

[@DanielChristian19]

Try the suggestion I gave you above. You might need to ask this question in the Power User Community as well.

[@jaimetreadwell9228]

@@DanielChristian19 Thanks, I found the error, it was playing with Selected and SelectedText

[@Arbbym9er]

Great video! Quick Question, I'm doing this for a gallery that acts as the "line items" (repeating table) for a purchase order app, and want the multiple entries to appear on top of each other in separate rows. Any ideas on how to achieve this? Currently all the line item info will appear in the same row when exported. Any help is much appreciated :)

[@DanielChristian19]

Hey Arbbym9er, I'll have to look into your app to give you more detailed information. My immediate advice is to use the Split function to take the data that comes in and break it down into different items in the gallery.

[@favoredlearns4789]

Hi. thank you so much @ Daniel Christian. This is so easy to follow and works absolutely well. i have a question similar to Arbbym9er but I cant see your response. My questions are: 1. My data exported into the same row. so i had a very ling row of data rather than having several columns. 2. How can i export the column headers too?

[@reginabolanosp.6971]

Hi Daniel! Thank you for the video, it was very helpful. I'm very new to PowerApps and i was wondering if there is a way to add a column name to the data exported. Could you help me with this?. Thanks a lot!

[@DanielChristian19]

Hey Regina, You are welcome! Yes you can, read through the comments above, I have answered that question a few times. Keep Power Apping!

[@kanishkaroychowdhury4050]

as usual... excellent video... how can we get the column heading in that csv file plz?

[@DanielChristian19]

Thanks Kanishka, I've answered this question in the below comments. Take a look there.

[@raulcabezasestrada1877]

Hi Daniel! Thanks for the video! It's really helpful. Please could you say us if it is any way of including headers to the csv file?

[@DanielChristian19]

Your welcome Raul. Read through the comments above. I have answered this question a few times.

[@raulcabezasestrada1877]

@@DanielChristian19 thanks Daniel!! I love your videos

[@solarpunk_]

This is a great video. A quick question: I'm not entirely sure why we need this .CSV file that has to be referenced every time in the code? Can you elaborate? Thanks for your help!

[@DanielChristian19]

Exporting data from a filtered gallery has been a highly requested feature which is not available out-of-box. Power App doesn't have function, however, Power Automate can and hence I collect all the data in the app and send it to the flow. Does that answer your question?

[@kumarmarlapati4912]

Hi Daniel, I am a follower of your videos and subscriber of your channel.Loved this video and the issue i am facing is only with downloading.Able to create csv in one drive with filtered gallery and file is not downloading, could you help what wrong it might be?

[@jennyt8716]

Thank you for the very insightful video! It was just as what i needed. Just a quick question. Could i check at 23:53, you named the file "CSVFile", but when you opened it in OneDrive, it was labelled as "CSVFile.CSV", is this automatically done by power automate, because when i replicated the code, my file was without ".csv"

[@hyweldavies161]

Hi Jenny. when Christian was adding the steps in Flow he added '.csv' as a hardcoded suffix to the Filename. I missed that myself and added '.csv' in PowerApps. Ended up with files ending ...csv.csv :)

[@cedricjacquemin8435]

Hi Daniel, Thanks a lot for this great video. If i can ask, I'm trying to go a step further, creating several tabs in the Excel workbook. I have a form with several tabs. each of them is linked to a different SP list and i need to export the content of each list into a different Excel sheet. Would you have any idea how this can be achieved ? Thanks a lot

[@DanielChristian19]

You are welcome Cedric! You should be able to achieve this. You can connect each Excel sheet to Power Apps as a separate connection.

[@cedricjacquemin8435]

@@DanielChristian19 Hi Daniel, thanks for your reply. hmm...not sure i understand what you mean but i guess this is what i've done. problem is it creates different workbooks and do not combine them as separate worksheets into 1 single workbook. i did this ... Set(varExportCSV,"");Set(varExportCSV2,""); ClearCollect(DeptCol,ShowColumns(Filter(Dept_1,Dept=DataCardValue27.Text && Process=DataCardValue28.Text),"Dept","Process")); ClearCollect(ActivityCol,ShowColumns(Filter(Activity,DeptTXT=DataCardValue27.Text && ProcTXT=DataCardValue28.Text),"DeptTXT","ProcTXT","Act")); Set(varExportCSV,"Deptartment,Process"&Char(10)&Concat(DeptCol,Dept&","&Process&Char(10))); Set(varExportCSV2,"Deptartment,Process,Activity"&Char(10)&Concat(ActivityCol,DeptTXT&","&ProcTXT&","&Act&Char(10))); Set(varSuccess,'PowerApps-BIAv2-ExporttoCSV'.Run("Department",varExportCSV).completed); Set(varSuccess2,'PowerApps-BIAv2-ExporttoCSV'.Run("Activity",varExportCSV2).completed); If(varSuccess="true" && varSuccess2="true",Launch("XXXXXXXXXXX&Download=1")); that gives me a Department excel file and an Activity excel file. Any idea how i could merge them into 1 single file , these becoming worksheets ? Thanks

[@luis_ffernando]

Thanks Daniel!!! It is very usefull!! and I've one question: Is it possible to exprtor a DataTable instead a Gallery? How can I do it?

[@DanielChristian19]

Hi Fernando, Yes you can! The formulas should be the same since we are using a collection. You will have to replace the collection control with a gallery.

[@luis_ffernando]

​@@DanielChristian19 It is working!!! Thanks again!!! I Have the last question (I promiss you!!!). When I export the CSV, the flow "add" the new datas below the oldest datas... is possible to clean the old datas before add the new ones? Thanks!

[@AvinashKauls]

Super Helpful and well explained. Daniel, do you know any workaround for how to export items from datatable control. Thanks in advance :-)

[@DanielChristian19]

Hi Avinash, I haven't done this with a datatable control before. I personally stay clear of data tables and use only galleries. I can even make a gallery look exactly like a data table.

[@AvinashKauls]

@@DanielChristian19 Thanks for your reply Daniel. I admit your point.

[@hoyongkang9418]

This is very useful. I have a question on the last part of exporting the csv, Set(ExportCSVVar,""). I have set it to become blank but whenever I click export, the data extract will also include the previous data that I pull. May I know how should I solve this issue? It should be pulling and displaying the fresh data.

[@DanielChristian19]

Looks like you are missing the ClearCollect at the beginning.

[@MrAmitav2000]

Thanks for the video. I was able to export data to CSV. A quick help on this will be really helpful. Is there a way in Power Automate to format output of List Record with close to 10 K records to a CSV. Thanks in Advance.

[@DanielChristian19]

Hi Amitav, Use the Variable action and append values to it.

[@Ram92026z]

Hi @Daniel, I am just curious. Most of the PowerApps videos that you have covered in terms of data, usually covers "Exporting" of data. Not many people/businesses seem to have implemented the "import" of data from say, a Word Template on One Drive. Is it that Microsoft has not provided easy Flow steps" to import data yet or is that it is too easy that it doesn't warrant a video. Of course tomorrow, I plan on trying to work backwards from the video and see if I can read file contents of an MS Word Template. But any pointers Dan will be of great help with regards to Import of data from Word/Excel etc, especially word templates. Thanks.

[@DanielChristian19]

Hey Ram, Exporting was in high demand at that time. Importing is being asked alot right now especially with Dataverse and it is doable using Power Automate flows and Power Automate forms. Excel is the easiest and works well to important into Dataverse tables in bulk. You can also use flow to bulk import.

[@Ram92026z]

@@DanielChristian19 , appreciate your response! I shall try it out and thanks again!

[@hyweldavies161]

Thanks Daniel. Exactly what I needed. I have one question. The SharePoint list I'm working from has 251 rows but the ExportCSVVar (steal with pride :-) )variable and the output CSV file have only 100. Is there a limit to how many records can be read into the variable

[@DanielChristian19]

Hey Hywel, Your welcome! The limit of 100 comes from the gallery since that is max you can see one at a time. To see the next 100 you simply scroll bottom. You might want to use a collection instead. I have had over 100K rows and still works great.

[@hyweldavies161]

@@DanielChristian19 It worked !! :) It also drastically cut down the amount of code required as I was able to read in the contents of the List directly rather than having to create and manipulate a Gallery. Thanks a lot !!

[@user-gm5fr1xf3o]

Thank you very much. It is very helpful. just a quick question, I am Korean and I created an excel csv file in KR, EN and numbers. When I export from Powerapps, EN and numbers are the same as Powerapps showing, but KR is broken language. do you have any solution for that?

[@DanielChristian19]

I haven't worked much on the languages side hence I recommend you post this question in the Power Apps Community --> powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

[@jeff5858]

Hi, thanks for sharing. Is this possible to do with huge data sources? In my case my filtering wouldn't need to pull over 500 items and store them as my temp var to export but essentially the datasource itself is over 40k items. Thanks!

[@DanielChristian19]

Hi Jeff, Yes with data sources such as SharePoint or Dataverse or SQL. You can get upto 2000 rows of data at a time and save them in a collection. The collection can save over a million rows. Take a look at this video of mine for more ideas kzbin.info/www/bejne/f6e3mnSXo6dmedU

[@gangab5978]

Thank you, Christian, for clear explanation. I have a problem while exporting data which is in hindi language, while exporting hindi text it is encoded, is there any way to add Unicode while exporting.

[@DanielChristian19]

Hi Ganga, I have not worked on any language based apps. I recommend posting this question in the Power Users Community. Don't forget to Subscribe to my KZbin channel and keep Power Apping!

[@gangab5978]

@@DanielChristian19 Thank you Daniel for giving your valuable response, I will do that.

[@gangab5978]

@@DanielChristian19 one more query from my end, instead of single file, can we dynamically create a new file on every user click. Your suggestion will help me.

[@RahulKumar-xj4zo]

In one column I have multiple data separated by comma, like this: data science,data gov,integration. So when I concat this column it is taking values after comma(data gov,integration )into other columns. I need that mutiple value data in sinlge column . How do i do it?

[@DanielChristian19]

Hey Rahul, I have answered a similar question before. If you ready through the comments you'll find the answer.

[@ShaunSee]

Excellent Video! Thanks.... Is it possible to pass the link back from Flow to PA similar to the way you passed Complete? I.e. Not having to grab the link and hard code it in PA would be awesome.

[@desktopdatacrunching4032]

It is! I actually just replicated what you're suggesting. I had to add an action to the flow called create share link from the OneDrive for Business Connector. I then added a second output to send back to Power Apps with the Share Link. I had to use ?Download=1 instead of &Download=1

[@christopheriansantos9669]

@@desktopdatacrunching4032 details please on how to do this. Like where should I create the create sharelink step, what to indicate in the file, what type of output to choose in creating the second output?

[@mauriciorestrepo4462]

Hello and thank you for this tutorial. Do you know how to export the file but as a .cmd and how can I download it to a folder that I choose automatically?

[@DanielChristian19]

Hey Mauricio, The Power Platform PowerShell module are primarily for administrative reasons. For what you are trying to do, look into triggering your PowerShell module using Power Automate. You can also consider Logic Apps.

[@kmuralikrishna1582]

Thanks you very Daniel, Do you have idea on 1. instead of loading from data source, how to select input file using browse option(if attachment is your choice) then 1.how to pass Attachment (selected file in powerapps) as an input file in to MS flow, 2.Then Flow has to read the selected input file and return to powerapps success or not means just validation will add later. Reply with idea or references will be great appreciated.

[@DanielChristian19]

Hi Kmurali, Your process sounds alot like either Robotic Process Automation or AI. Here's a few links that can help you get started. Power Apps A.I. builder: powerapps.microsoft.com/en-us/blog/introducing-ai-builder-for-powerplatform/ Power Automate RPA flow.microsoft.com/en-us/ui-flows/

[@hasaninew]

Hi Daniel, thanks for the instructions. I managed to export the csv, but any idea why the records repeating 6 times. I have 300 records but it exported 1800 records (each record repeating 6 times!)

[@DanielChristian19]

Hey Hasani, This has happened to me before and the cause of the issue was me not using ClearCollect at the right places. Also watch out for the ForAll(). That can cause duplicates to arrive. Do some troubleshooting using small data and before you send it to Power Automate to create the CSV, send the data to the collection first, then in a blank screen view the data. Hope this helps and keep Power Apping!

[@brightonalbert3237]

hey Daniel how do i make it clear data in the csv file before adding in new data in the csv. becouse every time i click export data the old data in the csv is in thank you for the tutorial

[@DanielChristian19]

Hi Brighton, You can either add Clear(CollectionName) at the very last action of the app or a ClearCollect(CollectionName) at the very beginning.

[@deviprasad.r.shetty]

Hi Daniel, Thanks for this tutorial, I am saving exported Csv in SharePoint document library within folder named as report. And I am creating new file on each click of export button, is there way we can get newly created file path for downloading in PowerApps or Flow. Thanks once again, Deviprasad Shetty

[@DanielChristian19]

Hey Deviprasad, I'm sure there is a way but I can't think of anything right now. My guess is do this on the Power Automate side.

[@RaniSingh-om8dp]

Hi Daniel, I have a multiple line of text ..so if there is a next line in the text box then the next line is added in the another row...is it possible to have it in the single row?

[@DanielChristian19]

Hi Rani, There is a way and I think I have answered this question before so read through the comments below.

[@kaarthikrubans8037]

This was really very helpful! Thank you! I am having one problem, the file is not downloading even after I add "&Download=1" in the path(URL) of csv file shared from onedrive, file is opening in the browser. Kindy help me to resolve this.

[@DanielChristian19]

Thanks Kaarthikruba. Which browser are you using? I know this works in the Google Chrome.

[@adialaluf6667]

Hi Kaarthikruba, For me, too, it does not download the file. If you were able to solve the problem can you explain to me how you did it?

[@Jadhav_jeet]

Hi Daniel, Thank you for the video, this was helpful. I am facing an issue. All other users using the "Export to Excel" functionality have reported that they are not seeing the latest data exported. I have granted exact permissions you mentioned however file is not getting created for other users. I have verified the OneDrive permissions, any suggestions?

[@DanielChristian19]

Hey Abhijeet, The files show up in the default location of their personal OneDrive folder. Have them take a look there.

[@luillyvasgas2624]

Quick question, what about if two user run the process at the same time, is going to override one of the two?

[@DanielChristian19]

Ummmm... that is an excellent question Luilly. Based on the logic I demonstrated in video it will be overwritten. To overcome that issue you could simply update the flow to use the end user's personal OneDrive. That way they only see and work with their Excel spreadsheet. Again, great question!

[@hermawanyudhi]

Hi Daniel, thanks for your post, i have question how to export all data in Gallery, in your case, only active data (show in gallery) will export, if i have 100 data only about 20 data export to csv not for 80 others data. how if i want to export all data

[@DanielChristian19]

Hi Yudhi, Your welcome! You should see all 100 of the because by default a collection can get atleast 500 items. Take a look to see if you don't have any clearcollect function somewhere. Hope this helps and don't forget to Like and Subscribe!

[@Feltronc]

Hi Daniel! You are a great educator. Everything was really clear and easy to follow. My question is, you have hard-coded the URL for the Launch action to call your own OneDrive location for the file. Even if this saves to each user's root in their own OneDrive, the OnSelect action will still attempt to download the file created in your OneDrive, not theirs, right? I'm trying to think how to make that Launch URL a value that calls the OneDrive for the user using the PowerApp. Maybe using the SharePoint connector in Power Automate instead of OneDrive and appending the user ID to the file name and then referencing that back to the OnSelect? That would create multiple files for each user, but that at least solves that. Otherwise, find the unique identifier in the OneDrive URL and use that as a manual value in the URL for the Launch action, that way it knows to go to the user's OneDrive and not yours. Thanks again for this awesome tutorial!

[@DanielChristian19]

Felipe, The file is saved in the user's OneDrive and not yours. Using a SharePoint Connector and a document library is another way to do this.

[@Feltronc]

Daniel Christian I ended up replacing the part of the URL string that identifies the user on the OnSelect action to the Office 365 “UserPrincipalName” function, with a left/find function to only pull the ID before the “@“. Works great! Thank you for taking the time to respond; Greatly appreciated!

[@adialaluf6667]

@@Feltronc Hi Felipe, I have a problem, I want each user to be able to export the file to his personal folder. I think that's the problem you had too. I tried to search for the function you used but could not find it. Can you explain to me how you did it?

[@GopiNath-jk8jq]

Sir, may I know how much rows available in “Statecitycounty” table ??

[@DanielChristian19]

Hi Gopi, I have approximately 29,980 rows

[@josemelendez5234]

Hi Daniel, How can i add columns headers to the csv file exported?

[@DanielChristian19]

Hey Jose, I have answered that question a few times in the comments above. Take a look

[@radhikas8214]

Thanks Christan, that helped a lot. I faced an issue with this solution. Everything worked well for me in edit mode of the App, However it doesn't work in play mode, When I click on the button to export data, it just goes un-responsive. If i remove the flow it works. any idea what could be an issue.

[@DanielChristian19]

Glad it helped!

[@beraypham6154]

CSV data was combined with previous ones when i submit and export CSV for new selected Items. May i have the only data that i picked?Thanks!

[@DanielChristian19]

Hey Beray, Go over your formulas. You've probably missed a ClearCollect somewhere.

[@namratamahale8652]

how we can download the formatted CSV, because i am downloading a form, so i need labels as well as text formatting and arrangement.

[@DanielChristian19]

Take a look at the comments. I've answered this question before.

[@liamtargett2381]

Found that this works perfectly for me and updates the file successfuly, however doesn't work for other users who have edit access to the file, any suggestions? I can see the flow has tried to create the CSV as the output is successful but onedrive does not update the file (for anyone but me)?

[@DanielChristian19]

Hey Liam, It should have worked because the CSV file should be saved in their own OneDrive. If that doesn't work then save the final CSV file to a SharePoint Online Document library,

[@HeyIFoundACamera]

But what if you can't load the file from a publicly visible OneDrive folder? I just want Power Automate to send the binary file data, and then have PowerApps save it.

[@kanishkaroychowdhury4050]

it is a great video indeed, lots to learn... but can u let us know how to display the headers in the csv file plz

[@DanielChristian19]

Hi Kanishka, I have answered that question in the comments above. Take a look.

[@kanishkaroychowdhury4050]

@@DanielChristian19 yes... got that... thank u very much... really appreciate it :)