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).
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!
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(...
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!
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 .
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.
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.
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!
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!
@@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?
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?
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(...
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.
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.
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.
@@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!
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??
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
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.
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
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!
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!
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.
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!
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.
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!
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.
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?
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.
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!
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.
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.
@@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?
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 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.
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
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.
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.
Hello Daniel, thanks for this video, it was really helpful in creating an app I am currently working on. However I am stuck at one point - I am able to filter the data and download the csv file on my system, however when the users are using my app and they try to download, the csv file that they get is not updated, i.e., the flow runs successfully but the csv does not get updated for the users. Do you have any suggestion please, on what really could be the issue here?
@@DanielChristian19 I have used it, but the issue is that the file is in my One drive, and I have given the access rights to the users. When any user(other than me) uses the app the csv file in my One Drive does not get updated and so when they download it's actually not the latest file, even though the flow runs. However a copy of the updated data gets created into their personal One Drive. Is there any way to get the users to download from their personal One Drive when they click on export to get the updated version?
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!
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?
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
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.
@@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 !!
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 :)
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.
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?
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 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!
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?
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.
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 TH-cam channel and keep Power Apping!
@@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.
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)
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 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
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.
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
@@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?
Hello Daniel, great video. How can I not append the data to the CSV file, meaning every time I do an export I want a new fresh data within the CSV file? Thank you
Hey Khaldoun, You'll need to clear the collection at the correct step. Usually this is at the beginning or end of the app use. The formula is ClearCollect(). In this vblog you'll see I have done the same at specific locations. Take a look.
@@DanielChristian19 Hello Daniel, Thank you for your quick response, you were right I forgot to clear the collection. I noticed when I do the export only 19 entries are good the rest do not pull the data correctly, it takes the last entry and puts it in the 2nd column. The Gallery shows all items, but when I view the "ExportCSVVar" that's where I see the wrong entries. I will watch your video again, maybe I missed something. Thank you again this was a very helpful presentation.
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.
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.
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?
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"
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 :)
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.
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.
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!
Hi Daniel. I'm having an issue with the downloaded file if other user uses the app. The downloaded file content is not updated but if they will go directly to their onedrive and download the file manually, there no issue. Please help. Thank you.
I edit also the flow instead of create file in onedrive, I use Create file in sharepoint. Is it right? But, there's an error in powerapps in export to excel
Thank you for this video, just made the sane concept but saving the csv with different filenames in one drive, since I’m the owner everything is working fine except that when I share it with different users, the portion of flow status is successfull but when I checked the csv files in one drive it does not exist. I’ve already shared the apps and also the one drive, will you able to help figure out the problem? TIA.
Daniel Christian, only selected user can do it, not that big numbers. I tried sharing my one drive to the users, but it’s not saving the CSV, though the flow is successful. Is there anything I need to configure?
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.
Hi Daniel. I followed same steps throughout but I am getting an error whenever I click on Export button. It says please select data to be exported. Could you please suggest? Thanks
Hi Biepashaa, My educated guess is that your collection has been reset. Take a look at the formula and confirm you haven't added an extra reset somewhere.
I am a newbie to PowerApps...Found this video very useful. Thanks for it ! Can I check, if a similar process could be done to export into a .pdf file instead of .csv file ?
Yes, absolutely. In the OneDrive action in Power Automate, you have the option to convert to PDF. Do a search on that topic and you'll find a few videos on that topic.
I tried doing a small demo at my end...It worked perfectly. The only issue I am facing is, the data in the .csv file is not getting refreshed, rather it is getting appended. I am just wondering, if the portion 'Set(ExportCSVVar,"") is not functioning properly.
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
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.
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/
This is very helpful solution , I use it in my powerapps ,thank you very much. But I have one question ........when export to csv , the chinese will Garbled , could you help me this ???
Hi Jack, Glad you found this helpful. I don't have much experience with language translation. This would be a great question to post in the Power Users community. Hope this helps and keep power apping!
Nice video Daniel, I built a similar app using Sharepoint as datasource and the export to excel is working fine I have one issue, I have Comments Field in my SP List so whenever I enter comma (,) in comments fields anything entered after comma will be shifted to next Field any idea how can I fix this ??
Hi Rakshith, Try using the Char(34) on both sides. The formula will look something like this: Set( VarExportCSV, Concat( TempCol, Char(34) & Author & Char(34) & "," & Char(34) & Title & Char(34) & Char(10) ) )
tahnks was very helpful but what should i do when i have a spécifique "forgin " character like "é,è,..." in the value of column it show me a strange words
Hi Tesnim, You can wrap those characters inside Char(34). Hence your formula would look something like this. Set( VarExportCSV, Concat( TempCol, Char(34) & Author & Char(34) & "," & Char(34) & Char(10)));
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?
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
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!)
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!
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?
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.
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.
Wow that was nice. You are fast and smart. Thanks Daniel. I have a requirement to convert sharepoint content from three lists which are connected by ID (Foreign key concept) to pdf. I was able to convert it pdf but the content is huge and it does not fit in pdf. It has lot of rich text boxes. I tried landscape view but still table gets cropped. Can we have horizontal scroll bar in pdf? I am converting html to pdf. My html shows scroll bars but it gets lost in pdf. Another issue is, the images in rich text boxes are getting lost in pdf but shows in html. Any work around for this would be very helpful. Thanks again.
Thanks for the compliments Sniper. I've struggled with PDF files cutting edges and so far reducing font size has been the only fix. For the images, take a look at Shane Young's video. He added the image on OneDrive first -> th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
@@DanielChristian19 Thanks for the reply Daniel. Yes, i have already referred to Shane's video. He is using one drive only for the logo not for the images in the rich text boxes which users add from internet or any other source. Seems like its an issue of absolute url. I will check more on this. Thanks for your amazing videos. Keep going.
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
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.
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?
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?
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.
Hi, this was exactly what I needed! I am just having an issue here: ;Set(SuccessVar,SharepointExport.Run("CSV",ExportCSVVar).completed); powerapps is giving an error message "Invalid number of arguments: received 2, expected 1". I cant see any difference between my formula and yours (apart from the name of the file) Can you see where Im going wrong?
@@DanielChristian19 hi, thanks for getting back to me. I found the issue, in my flow I hadn't assigned the correct file content dynamic content, it works great now. Thank you!
Hi Daniel. Is there any way to create a flow to convert the range created inside that CSV file into Excel table. I've tried create table action in PowerAutomate but that action doesn't support CSV file.
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.
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.
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.
This is really great. Thank you. Is there anyway where we will be able to wipe out the details already in newly created excel automatically and have the new selection created while we press submit. The rows keep getting added and it still has all the data from previously downloaded file ? Thanks in advance.
Murali, The default location is always the user's OneDrive hence make sure you have your connection setup correctly. The flow can also work successfully in the user's own OneDrive as well.
@@DanielChristian19 Hi Christian. Thank you for the reply. Whenever I clicked the submit button from my user ID, it created a new file in my onedrive. But when done from others user ID, it failed to create a file in my one drive. I tried by giving them full access to that particular folder in onedrive to other users. still the same problem existed. Finally, I changed the location to sharepoint from onedrive. Problem resolved then.
Hi Mr Daniel, your video made my work easy, But I am have an issues, I am getting not all the values from the gallery in the CSV, I filtered from SP (8000 rows) , when export some of the columns are empty, I approximately 1000 Rows in the gallery, but only export some values shows on gallery. if i want export all of them i have to scroll to the lower and do this for the user it´s not correct (last position) ... Any help to resolve this issue. Please??? My Code is: Clear(ExportCSVColProveedor);Set(ExportCVSProveedor," ");ForAll(Gallery2.AllItems,Collect(ExportCSVColProveedor,{ProveedorP:Title_Prov_ProvFilter.Text,DescripcionP:Subtitle_Desc_ProvFilter.Text,PartNumberP:PartNProv.Text,PrecioProv:PrecioProv.Text,VigenciaPro:FechaVigenteProv.Text,ContratoP:ContratoProv.Text,CondicionP:CondicionProv.Text,TiempoEP:TiempoEProv.Text}));Set(ExportCVSProveedor,Concat(ExportCSVColProveedor,ProveedorP&"?"&DescripcionP&"?"&PartNumberP&"?"&PrecioProv&"?"&VigenciaPro&"?"&ContratoP&"?"&CondicionP&"?"&TiempoEP&Char(10)));Set(SuccessVar,ExportCSV.Run("CSVFileFilterProveedor",ExportCVSProveedor).completed)&Notify("Se descargó con éxito archivo CSV")
Hi Raul, Increase your advanced setting from 500 to 2000. That should take care of the 1000 rows. Galleries by default only show 100 items at a time for viewing purposes, however, that's not the case with collections.
@@DanielChristian19 thanks for your response, i setting to 2000 but when export continue the same problem. for example filtered by Vendor (vendor have 1300 products) when exported to csv only export 20 rows. and not found any problem on my code.
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
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?
Hello :) When I add in date fields to be exported it only exports 6 lines of records, is there something different that we should be adding in the code if we are trying to pull dates?
Prateeksha, I'll have to take a look at your app to give you better insight. Take a look to see if any condition is causing that date filtering to provide only 6 lines of records.
@@DanielChristian19 Hi Daniel, I did check that as well - this is all I have in my code: Set(ExportCSV,""); ClearCollect(Convenience,List1,List2,List3,List4); ForAll(BrowseGallery1.AllItems,Collect(ExportCSVCol, {PromoName:PromoGAL.Text, CDT:CDTGAL.Text, Banner: BannerGAL.Text, Category: CategoryGAL.Text, ProductBundle: ProductBundleGAL.Text, PromoType: PromoTypeGAL.Text, Price: PriceGAL.Text, StartDate: StartDateGAL.Text})); Set(ExportCSV,"Promo Name,CDT,Banner,Category,Product Bundle, Promo Type, Price,Start Date"&Char(10)&Concat(ExportCSVCol,PromoName&","&CDT&","&Banner&","&Category&","&ProductBundle&","&PromoType&","&Price&","&StartDate&Char(10))); Set(SuccessVar,EXPORTCSVTEST.Run("CSVFile",ExportCSV).completed); If(SuccessVar="true", Launch("nestle-my.sharepoint.com/:x:/p/prateeksha_ravi_ca/EbqOacOLn2RAuHmQgezGb3IBhTd3sfSsGsmnWdaJc0BcRw?e=BoC7Oe&Download=1"))
![[DRIP] ‘CLIK CLAK’ PREVIEW](http://i.ytimg.com/vi/bcxkcOSbpac/mqdefault.jpg)
This was very helpful and was exactly what I needed! Thank you so much for the tutorial!
Thanks for the compliment Dylan!
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).
This is also a great one. How do you retrieve the link?
Hello how do u do that plz
A video of more then 2 years, and still helpfull. Thanks for this. 👌👍
Glad it helped!
Daniel...found this is your one the best videos on Power Apps ...thoroughly enjoyed the video...
Hey Aroh!
Thanks for the compliment
can you believe I binge watched your uploads .....
*Awww shucks* Thanks for the compliment Issie
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!
Thanks for the compliment and you are most welcome!
Don't forget to like my video and subscribe to my TH-cam channel. It's a win-win situation.
Thank you Daniel, very helpful! Would you mind to explain how we can add the header in each column in the file? Thank you.
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(...
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!
Glad it helped and thanks very much for the great compliment. Don't forget to subscribe and share my FREE playlist with others.
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 .
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.
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.
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.
Whew.. At last! A very informative video on exporting. Thanks Sir Daniel!
Hey Jun,
Thanks for the compliment and you are welcome!
Great video, returning the filepath from the Flow improves it even more.
Great to hear!
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!
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.
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!
@@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?
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?
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(...
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.
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.
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
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?
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.
@@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!
Thankyou Daniel this was very helpful. Just one help I needed is that how can we add headers to that csv file?
You are welcome. I have answered this a few times in the comments. Take a look
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??
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
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.
Your welcome Solo!
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
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!
Thanks a lot Daniel, it's a very useful and easy to understand guide.
Thanks for the compliment, Sword
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!
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.
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!
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.
Superb video! Learned so many extra things! Daniel, can you suggest how to create an empty onenote notebook?
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!
Hi Daniel, great video, I wonder if we can add column names for each of the column in the CSV file
Hey Michael,
Yup you can. I have answered that question in the comments above.
Super Helpful and well explained. Daniel, do you know any workaround for how to export items from datatable control. Thanks in advance :-)
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.
@@DanielChristian19 Thanks for your reply Daniel. I admit your point.
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?
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.
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!
Glad it helped
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.
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.
@@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?
This is very helpful. Daniel, do you have any video which show how to export the filtered results to Word file? Thanks.
I don't.
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?
Hey Jeremy,
I've answered similar questions in the comments above including how to add header columns. Take a look
@@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.
Brilliant! Much needed video. Keep sharing your wisdom.. Thanks a lot
Glad it was helpful!
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
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.
This works beautifully, thanks Daniel!
You're welcome, Eric!
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.
Hello Daniel, thanks for this video, it was really helpful in creating an app I am currently working on. However I am stuck at one point - I am able to filter the data and download the csv file on my system, however when the users are using my app and they try to download, the csv file that they get is not updated, i.e., the flow runs successfully but the csv does not get updated for the users. Do you have any suggestion please, on what really could be the issue here?
Hey Kasturi,
I've seen this before. This usually happens when ClearCollect() is not used. Look into that.
@@DanielChristian19 I have used it, but the issue is that the file is in my One drive, and I have given the access rights to the users. When any user(other than me) uses the app the csv file in my One Drive does not get updated and so when they download it's actually not the latest file, even though the flow runs. However a copy of the updated data gets created into their personal One Drive. Is there any way to get the users to download from their personal One Drive when they click on export to get the updated version?
@@KasturiBurman have you fix this issue, i m also having the same isuue.
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!
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?
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?
Your welcome Raul.
Read through the comments above. I have answered this question a few times.
@@DanielChristian19 thanks Daniel!! I love your videos
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
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.
@@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 !!
Hi,
The video is very helpful. For me, all the data stored in row wise. I need it in column wise. can you help.
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 :)
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.
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?
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.
Awesome!
Few things I can think of is missing the ClearCollect() or accidentally adding the same formula twice in a OnSelect.
@@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!
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?
as usual... excellent video... how can we get the column heading in that csv file plz?
Thanks Kanishka,
I've answered this question in the below comments. Take a look there.
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.
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 TH-cam channel and keep Power Apping!
@@DanielChristian19 Thank you Daniel for giving your valuable response, I will do that.
@@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.
This is amazing. Thank you very much!
You're very welcome!
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)
Try the suggestion I gave you above. You might need to ask this question in the Power User Community as well.
@@DanielChristian19 Thanks, I found the error, it was playing with Selected and SelectedText
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
You are most welcome Brighton. Keep Power Apping!
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
You are welcome Cedric!
You should be able to achieve this. You can connect each Excel sheet to Power Apps as a separate connection.
@@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
Nice tutorial, thanks! The only things I didn't like were: 1. Hardcoded link to the file 2.CSV gets constructed without Headers
Thanks for the compliment.
Take a look at the comments above and I have answered how to add headers.
@@DanielChristian19 yeah thanks! Keep it up!
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.
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
@@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?
Thanks this is so good to learn :)
Glad it was helpful!
Hello Daniel, great video. How can I not append the data to the CSV file, meaning every time I do an export I want a new fresh data within the CSV file? Thank you
Hey Khaldoun,
You'll need to clear the collection at the correct step. Usually this is at the beginning or end of the app use. The formula is ClearCollect(). In this vblog you'll see I have done the same at specific locations. Take a look.
@@DanielChristian19 Hello Daniel,
Thank you for your quick response, you were right I forgot to clear the collection.
I noticed when I do the export only 19 entries are good the rest do not pull the data correctly, it takes the last entry and puts it in the 2nd column.
The Gallery shows all items, but when I view the "ExportCSVVar" that's where I see the wrong entries.
I will watch your video again, maybe I missed something.
Thank you again this was a very helpful presentation.
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.
Hi Amitav,
Use the Variable action and append values to it.
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.
Thanks Kaarthikruba.
Which browser are you using? I know this works in the Google Chrome.
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?
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?
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"
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 :)
Thank you for this. I have a question. How do I add the headers before the data itself?
Hi Jethro,
Read the comments below. Twits asked a similar question and I provided the answer.
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.
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.
@@DanielChristian19 , appreciate your response! I shall try it out and thanks again!
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!
Hey Regina,
You are welcome!
Yes you can, read through the comments above, I have answered that question a few times. Keep Power Apping!
Hi Daniel. I'm having an issue with the downloaded file if other user uses the app. The downloaded file content is not updated but if they will go directly to their onedrive and download the file manually, there no issue. Please help. Thank you.
Ryan,
Instead of OneDrive, save it to a SharePoint site's document library. As long as your users have access to this site, this should work.
@@DanielChristian19 I will try this. Thanks so much.
I edit also the flow instead of create file in onedrive, I use Create file in sharepoint. Is it right? But, there's an error in powerapps in export to excel
Thank you for this video, just made the sane concept but saving the csv with different filenames in one drive, since I’m the owner everything is working fine except that when I share it with different users, the portion of flow status is successfull but when I checked the csv files in one drive it does not exist. I’ve already shared the apps and also the one drive, will you able to help figure out the problem? TIA.
Hi Nelson,
You'll find it on each user's own OneDrive.
Daniel Christian thanks, but is it possible to a shared one drive folder not to individual user one drive?
It is but remember you'll have to do it for all the app users.
Daniel Christian, only selected user can do it, not that big numbers. I tried sharing my one drive to the users, but it’s not saving the CSV, though the flow is successful. Is there anything I need to configure?
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.
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.
Hi Daniel. I followed same steps throughout but I am getting an error whenever I click on Export button. It says please select data to be exported. Could you please suggest? Thanks
Hi Biepashaa,
My educated guess is that your collection has been reset. Take a look at the formula and confirm you haven't added an extra reset somewhere.
I am a newbie to PowerApps...Found this video very useful. Thanks for it ! Can I check, if a similar process could be done to export into a .pdf file instead of .csv file ?
Yes, absolutely. In the OneDrive action in Power Automate, you have the option to convert to PDF. Do a search on that topic and you'll find a few videos on that topic.
@@DanielChristian19 Thank you, for the immediate response !
I tried doing a small demo at my end...It worked perfectly. The only issue I am facing is, the data in the .csv file is not getting refreshed, rather it is getting appended. I am just wondering, if the portion 'Set(ExportCSVVar,"") is not functioning properly.
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
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.
Great video.. helped me a lot. Thank you for taking time and explaining in detail.
Your welcome Pennaiah.
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.
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/
This is very helpful solution , I use it in my powerapps ,thank you very much.
But I have one question ........when export to csv , the chinese will Garbled , could you help me this ???
Hi Jack,
Glad you found this helpful.
I don't have much experience with language translation. This would be a great question to post in the Power Users community.
Hope this helps and keep power apping!
Nice video Daniel,
I built a similar app using Sharepoint as datasource and the export to excel is working fine
I have one issue, I have Comments Field in my SP List so whenever I enter comma (,) in comments fields anything entered after comma will be shifted to next Field
any idea how can I fix this ??
Hi Rakshith,
Try using the Char(34) on both sides. The formula will look something like this:
Set(
VarExportCSV,
Concat( TempCol,
Char(34) & Author & Char(34) & "," & Char(34) & Title & Char(34) & Char(10)
)
)
@@DanielChristian19 Thanks Daniel,
It solved my issue
Your videos help me a lot, thank you
Glad to hear that!
tahnks was very helpful but what should i do when i have a spécifique "forgin " character like "é,è,..." in the value of column it show me a strange words
Hi Tesnim,
You can wrap those characters inside Char(34). Hence your formula would look something like this.
Set(
VarExportCSV,
Concat(
TempCol, Char(34) & Author & Char(34) & "," & Char(34) & Char(10)));
@@DanielChristian19 thanks for ur quick answer but unfortunately I add char (34) like u did in ur message but always cant have the right character exep I have name : frèdric = fr©dric. in my csv file
Set(cvsexport1;"Nom;Prenom;Nom complet;Poste;Societe;Email;Adresse;Ville;CodeZip;Pays;Tel prof;Tel portable;Tel perso"&Char(10)&Concat(Conttest;Char(34)&Title&Char(34)&";"&Char(34)&FirstName&Char(34)&";"&Char(34)&FullName&Char(34)&";"&Char(34)&JobTitle&Char(34)&";"&Char(34)&Company&Char(34)&";"&Char(34)&Email&Char(34)&";"&WorkAddress&";"&WorkCity&";"&WorkZip&";"&WorkCountry&";"&HomePhone&";"&CellPhone&";"&WorkPhone&Char(10)));; Set(varCompleted;CSVCSV.Run("EXCELEXPORT";cvsexport1).
Hi Daniel, How can i add columns headers to the csv file exported?
Hey Jose,
I have answered that question a few times in the comments above. Take a look
Really, really helpful tutorial! Thank you for this!
You're very welcome!
i am new to powerapp, kindly let me know the field types of your 2 tables like text col or choice col, etc
Please go to Windows settings and mark you mouse cursor with color so we can follow what you Click..
Thanks for the tip!
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?
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
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!)
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!
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?
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.
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.
Wow that was nice. You are fast and smart. Thanks Daniel. I have a requirement to convert sharepoint content from three lists which are connected by ID (Foreign key concept) to pdf. I was able to convert it pdf but the content is huge and it does not fit in pdf. It has lot of rich text boxes. I tried landscape view but still table gets cropped. Can we have horizontal scroll bar in pdf? I am converting html to pdf. My html shows scroll bars but it gets lost in pdf.
Another issue is, the images in rich text boxes are getting lost in pdf but shows in html. Any work around for this would be very helpful. Thanks again.
Thanks for the compliments Sniper.
I've struggled with PDF files cutting edges and so far reducing font size has been the only fix.
For the images, take a look at Shane Young's video. He added the image on OneDrive first -> th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
@@DanielChristian19 Thanks for the reply Daniel. Yes, i have already referred to Shane's video. He is using one drive only for the logo not for the images in the rich text boxes which users add from internet or any other source. Seems like its an issue of absolute url. I will check more on this. Thanks for your amazing videos. Keep going.
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
Hi Brighton,
You can either add Clear(CollectionName) at the very last action of the app or a ClearCollect(CollectionName) at the very beginning.
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.
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?
Hey Rahul,
I have answered a similar question before. If you ready through the comments you'll find the answer.
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?
Hi Rani,
There is a way and I think I have answered this question before so read through the comments below.
new subscriber you got Daniel.
Awesome thank you!
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.
Looks like you are missing the ClearCollect at the beginning.
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!
Hey Beray,
Go over your formulas. You've probably missed a ClearCollect somewhere.
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
Hi Kanishka,
I have answered that question in the comments above. Take a look.
@@DanielChristian19 yes... got that... thank u very much... really appreciate it :)
Hi, this was exactly what I needed! I am just having an issue here:
;Set(SuccessVar,SharepointExport.Run("CSV",ExportCSVVar).completed);
powerapps is giving an error message "Invalid number of arguments: received 2, expected 1". I cant see any difference between my formula and yours (apart from the name of the file)
Can you see where Im going wrong?
Matthew,
Remove the .completed and try again. The formula will look like this
Set(SuccessVar,SharepointExport.Run("CSV",ExportCSVVar));
@@DanielChristian19 hi, thanks for getting back to me. I found the issue, in my flow I hadn't assigned the correct file content dynamic content, it works great now. Thank you!
Hi Daniel. Is there any way to create a flow to convert the range created inside that CSV file into Excel table. I've tried create table action in PowerAutomate but that action doesn't support CSV file.
Hi Michael,
Yes, you can use Power Automate flow for that. There is an action to do the conversion.
@@DanielChristian19 I note that the action supports xlsx but csv. Is there a way to convert CSV to Excel automatically?
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.
Glad it helped!
Sir, may I know how much rows available in “Statecitycounty” table ??
Hi Gopi,
I have approximately 29,980 rows
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.
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.
This is really great. Thank you.
Is there anyway where we will be able to wipe out the details already in newly created excel automatically and have the new selection created while we press submit. The rows keep getting added and it still has all the data from previously downloaded file ?
Thanks in advance.
actually I have one more query. If the app is used by some other person, the file in my onedrive is not getting updated.
Murali,
The default location is always the user's OneDrive hence make sure you have your connection setup correctly. The flow can also work successfully in the user's own OneDrive as well.
@@DanielChristian19 Hi Christian. Thank you for the reply. Whenever I clicked the submit button from my user ID, it created a new file in my onedrive. But when done from others user ID, it failed to create a file in my one drive. I tried by giving them full access to that particular folder in onedrive to other users. still the same problem existed. Finally, I changed the location to sharepoint from onedrive. Problem resolved then.
Hi Mr Daniel, your video made my work easy, But I am have an issues, I am getting not all the values from the gallery in the CSV, I filtered from SP (8000 rows) , when export some of the columns are empty, I approximately 1000 Rows in the gallery, but only export some values shows on gallery. if i want export all of them i have to scroll to the lower and do this for the user it´s not correct (last position) ... Any help to resolve this issue. Please???
My Code is:
Clear(ExportCSVColProveedor);Set(ExportCVSProveedor," ");ForAll(Gallery2.AllItems,Collect(ExportCSVColProveedor,{ProveedorP:Title_Prov_ProvFilter.Text,DescripcionP:Subtitle_Desc_ProvFilter.Text,PartNumberP:PartNProv.Text,PrecioProv:PrecioProv.Text,VigenciaPro:FechaVigenteProv.Text,ContratoP:ContratoProv.Text,CondicionP:CondicionProv.Text,TiempoEP:TiempoEProv.Text}));Set(ExportCVSProveedor,Concat(ExportCSVColProveedor,ProveedorP&"?"&DescripcionP&"?"&PartNumberP&"?"&PrecioProv&"?"&VigenciaPro&"?"&ContratoP&"?"&CondicionP&"?"&TiempoEP&Char(10)));Set(SuccessVar,ExportCSV.Run("CSVFileFilterProveedor",ExportCVSProveedor).completed)&Notify("Se descargó con éxito archivo CSV")
Hi Raul,
Increase your advanced setting from 500 to 2000. That should take care of the 1000 rows. Galleries by default only show 100 items at a time for viewing purposes, however, that's not the case with collections.
@@DanielChristian19 thanks for your response, i setting to 2000 but when export continue the same problem. for example filtered by Vendor (vendor have 1300 products) when exported to csv only export 20 rows. and not found any problem on my code.
Thanks you. I had to change coma by semicolon, but It works.
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
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?
Hey Abhijeet,
The files show up in the default location of their personal OneDrive folder. Have them take a look there.
Hello :)
When I add in date fields to be exported it only exports 6 lines of records, is there something different that we should be adding in the code if we are trying to pull dates?
Prateeksha,
I'll have to take a look at your app to give you better insight. Take a look to see if any condition is causing that date filtering to provide only 6 lines of records.
@@DanielChristian19 Hi Daniel,
I did check that as well - this is all I have in my code:
Set(ExportCSV,"");
ClearCollect(Convenience,List1,List2,List3,List4);
ForAll(BrowseGallery1.AllItems,Collect(ExportCSVCol, {PromoName:PromoGAL.Text, CDT:CDTGAL.Text, Banner: BannerGAL.Text, Category: CategoryGAL.Text, ProductBundle: ProductBundleGAL.Text, PromoType: PromoTypeGAL.Text, Price: PriceGAL.Text, StartDate: StartDateGAL.Text}));
Set(ExportCSV,"Promo Name,CDT,Banner,Category,Product Bundle, Promo Type, Price,Start Date"&Char(10)&Concat(ExportCSVCol,PromoName&","&CDT&","&Banner&","&Category&","&ProductBundle&","&PromoType&","&Price&","&StartDate&Char(10)));
Set(SuccessVar,EXPORTCSVTEST.Run("CSVFile",ExportCSV).completed);
If(SuccessVar="true",
Launch("nestle-my.sharepoint.com/:x:/p/prateeksha_ravi_ca/EbqOacOLn2RAuHmQgezGb3IBhTd3sfSsGsmnWdaJc0BcRw?e=BoC7Oe&Download=1"))