Power Apps Export data to Excel with Flow - Collections to CSV file

In this video, you will learn how to export data from Power Apps to Excel thanks to collections and Power Automate aka Flow. The video shows you how to output a CSV file but more important it goes through the mechanics so once you get your data into Flow you can do whatever you want.

[@peterlabermeier215]

You are a Goldmine of nuggets! Worked on this same kind of problem yesterday and got really close but no cigar. You provided the key information once again. Thank you.

[@ShanesCows]

Awesome Peter!

[@karlnixon5606]

OMG this is the final piece for my app I've been looking for - Thank you!!!!!

[@ShanesCows]

I knew you needed it. 😉

[@DanielChristian19]

Well done Shane! The combination of Compose and Parse JSON are my personal favorite steps. These give you the flexibility to convert the data and use it however you see fit.

[@kmuralikrishna1582]

Hi Daniel Can you reply here... By any chance can we create excel file instead of CSV ..? Yes as per requirement we need to create .xslt excel file ....kindly help me if possible

[@ShanesCows]

Agree! Ever since I added Compose into my toolbelt I do so much with it now. Very much a core action of building a flow.

[@carlosalexleon]

I watch many of your videos and was looking for a solution on Google and this video came up without knowing it was yours! Knew right away i wouldn't have to look any further.

[@ShanesCows]

Thanks Carlos!

[@NKBobcat]

I have a project that has this requirement. Thanks for saving me a lot of time and headache!

[@ShanesCows]

Glad I could help! Now go build something awesome Bob.

[@BillyRayErwin]

Fantastic Video. It's the only one on the subject that worked for my system. THANK YOU!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@javiercabrera2930]

Excellent video as always. Thanks Shane!

[@ShanesCows]

Thank you Javier!

[@Ballistik3]

Great video! Another way to grab the schema that I've seen is by setting a label in Powerapps to that json variable and copy/pasting from there.

[@ShanesCows]

Cool. Thanks for sharing.

[@n2datasolutions443]

Fantastic!!! Thanks Shane :)

[@ShanesCows]

Glad you liked it!

[@KingOfBlades27]

Awesome video! Very informative for the project I have going on atm :)

[@ShanesCows]

Awesome. Glad to help. 😀

[@ashokpershad]

Awesome as always...thanks a lot

[@ShanesCows]

My pleasure!

[@helloanurag]

Great video as always, Shane. I am still waiting for CDS Permission and Security video (Part 2). It's difficult to find any simple resource which exlainps how to manage entities permission in CDS. Thanks very much!

[@ShanesCows]

Coming soon I hope. 😍

[@barbloke1566]

Great work chap, as ever

[@ShanesCows]

Thank you! Cheers!

[@nipun399]

Thank u so much Shane ❤️

[@ShanesCows]

Glad it helps you. 😎

[@flamengoevida6414]

Thank you Sr Shane, you help-me for my work..

[@ShanesCows]

Glad to help

[@flamengoevida6414]

@@ShanesCows Shane, how do I do the excel document and send it to the attached email? Could you make a video teaching?

[@nipunverma7127]

Hi Shane, Love the stuff on PowerApps. Would love to see an app video based on CRM security role model like editing of a field only for specific CRM role... Thanks and keep posting!!!

[@ShanesCows]

I need to do more CDS content for sure.

[@MikeFicetola]

Great Shane! Thank u

[@ShanesCows]

Glad to help Mike.

[@brightonalbert3237]

thank you shane your my man

[@ShanesCows]

You are welcome.

[@Shinupp]

Thankyou very much for making this video

[@ShanesCows]

You are welcome 🤗

[@mohammedkhamis757]

Thank you very much Shane

[@ShanesCows]

Glad to help. 😀

[@patriciahester2347]

Hi Shane! You're videos have been so helpful, thank you! I am running into an issue with doing something like this from a SharePoint list to a simple CSV file. My "assigned" column is a multi-person selector option. Whenever my data goes from the List to the CSV file, I get a really long OODATA string it looks like. Would you be able to help point me in the right direction with parsing the JSON in the right way?

[@maggieho9521]

Hey Shane, nice video! My collection probably has too much info to pass to the flow. Often the generated Word file missing some data. However, all selected record ID in the collection are in the generated Word file. Just some text (large text) fields are missing data. My second thought is just pass the selected record ID to the flow, then in the flow, use the IDs to retrieve the other fields data in the flow to generate the Word file. My app uses DataVerse. Do you have any video that demo the use of DataVerse to retrieve data, record by record? Greatly appreciated is you can provide me some ideas what I need to do in my flow!! Thanks!

[@franknielsen3219]

Nice video (as usual). Is the only way to avoid problems with JSON and blank fields to use [“string”,”null”]?

[@joelgeorgeejoseph]

Thank you so much Shane, this was very much needed!! Any chance of exporting record columns? I have multiple people picker columns.

[@ShanesCows]

Not that I have figured out. I think on the Power Apps side you would need to extract the people as text using Concat. That is what I would try.

[@sokgat7019]

This is huge. Thank you Shane!!!!

[@ShanesCows]

Glad to help!

[@williampurcell606]

Hi Shane, thank you for so many great videos. I am currently using this type of flow for an inventory power apps program I designed. Currently I am using the flow to send an email of a collection of received inventory items. My received items have pictures. As we cannot patch a picture to a share point list, is there a way to write a flow to patch the picture from this collection to the same share point ID of received items?

[@SaurabhYadav0989]

Thanks for this useful video i need a vedio on converting csv data to excel format using powerautomate

[@elisama2936]

Thank you Shane! One question, I don’t have any dynamic values available. Do you know why that might be? Thanks!

[@DataisKing]

Hey Shane, I have a flow that creates a csv file that is generated from columns in a SharePoint List. Some of the columns have a text data type and some have a number data type. I am trying to separate the columns in the csv file so that only the columns that have a text data type have quotes around them. Any ideas?

[@zonvas]

Dear Shane, I already prepared my flow and it can export data in csv successfully. But I also facing some issues, if the column has null value "Parse JSON" giving me some error like "Required properties are missing from object:" If I edit the JSON Schema like "type": ["string","null"] , it can create the JSON Schema but in my csv that column is coming full blank. Could you please guide me to resolve this part. I want to export that column with DATA and null value both.

[@gorantrifunovic2506]

Hi Shane, First of all, thanks for all the great work and effort you've provided here. I have some problem that I hoped I could solve with this example, but I don't need a CSV file, I need the data to be saved into existing Excel table instead and I hope you'll be able to help me with. In my app I am loading the data from Excel table and use them in the Gallery with checkboxes, creating a collection based on checked items and I need to save the data from collection(or Gallery) into a different Excel table along with some other stuff in the app (text boxes, labels etc.). I've tried various different things but every time hitting the wall when it comes to write collection into Excel table. It would be great if you could make a video on this subject. Thanks,

[@Joshkl2013]

Export it to a CSV first and then save it somewhere on SharePoint or OneDrive. That's your first piece. Then your problem isn't "Get all of this data into an excel file", it's "Get this CSV into an online Excel file automatically". Then you can use Azure Functions or Visual Basic or something else (run Azure Functions from a flow?) in order to get that CSV info, dump it into Excel, and then delete the CSV. Then you have a self-resetting system which puts the latest data in Excel. Or just use a SharePoint list and create items in SharePoint from your CSV flow. Then you can set up a data connection in Excel to said list and you just need to hit refresh to get the data down to Excel. Hope I helped. J

[@ShanesCows]

We have done it for a customer. It is hard. Not sure it will be a video anytime soon but I will note it. Sorry I don’t have an easy solution

[@TheSwedishRocks]

Hey Shane! Loving the videos, though I have a question about this one. I have SP List data source with a lot of drop down lists and these are all populated in this manner, {"Value":"High"} instead of the hoped for High. Have you ran into this before? Keep up the good work, Thanks!

[@ShanesCows]

I haven’t. If I did I would try some string manipulation to remove the extra characters. Maybe replace? Though there a lot of ways to do so

[@plamenlazarov6633]

Hi, Shane! Another great video. Thank you for the materials and ideas shared! Can you please advise if it is possible to extract data from PDF file using Powerapps PDF connector, transform the data and transfer it to XLSX/CSV format and then use the query in Power Automate? That would be very useful. Warm regards!

[@ShanesCows]

Not the free connector. Maybe one of the third party ones.

[@kevinstevenson7078]

Love this process but can you change the order of columns in a collection, as they are alphabetical and that's not very useful when they go into my CSV?

[@ShanesCows]

That is a great question Kevin... I don't know... I haven't tried that one.

[@rabiguthrie7987]

Great video! Got it working finally as I ran into trouble when the Schema for the Parse JSON step in the Flow didn't like empty fields (as the Output just put "null" where a field was empty) so I found a fix where for any fields where you could expect it to be empty to add ["null"] to the "type". However. I've got another question regarding the actual CSV output. When I open the file, it's turned boolean fields into simple true/false and where a field is populated from a "Choices", it just puts in a numerical code rather than the text itself. Is there any way of having the CSV file show the actual text in the field?

[@ShanesCows]

You would have to write If logic to change the results to show what you want. 😑

[@utoroprincewill7808]

This is really a nice feature and knowledge to get. Thanks as always Shane. Just a quick question. How do you reduce the number of columns exported to the csv.?

[@ShanesCows]

Remove them from your collection. The DropColumns function can help.

[@johnheck1551]

@@ShanesCows You can also use ShowColumns to build the collection. I do this for different user permissions as to what they can see based on permissions. I had issues when dropping some of the columns using DropColumns, it worked out great by just using ShowColumns and entering the columns I wanted to show up in the CSV file.

[@powerappstw]

thanks for sharing, if possible to export 2 lists(master and detail) to 1 csv at the same time?

[@ShanesCows]

Sorry I am behind on comments. Yes, you would need to nest your Concat functions to do so.

[@kevinstevenson5787]

Hi, my sharepoint table has richtext format on some fields, and if i use this method i get all the richtext info in the csv. Can i export the data without the richtext formatting?

[@ThermalWarrior]

Great video thanks Shane. But what if I pass a single JSON record and want to stop for each in flow. I guess you got round it with an action that expects multiples. I want to pass a single Jason record of values for a stored procedure but that darn for each....

[@ShanesCows]

It will always be a table even if it is a single line I think. You might be able to parse the JSON, Apply To Each through it, and then write that info to a text variable so you don't have to deal with the table. I kind of show it here kzbin.info/www/bejne/h5S6m3SqbLaJpJY where I only want one table but still have Apply to Each.

[@sujaysooknanan9367]

Thanks Shane! This is helpful! How do you keep the order of the parsed JSON objects? I'm passing the fields from the collection in a specific order, however the compose action puts this in alphabetical order which does not display in the correct order on the csv file.

[@sujaysooknanan9367]

I managed to fix this by selecting "Custom" instead of "Automatic" under Columns in advanced options. Thereafter it allows you to specify custom formatting. Thanks again for this Shane. Your content is always extremely informative :)

[@ShanesCows]

Glad you got it. 😀

[@liamratcliffe7030]

Thanks Shane, I have a flow using similar to this and the CSV is being emailed out and stored in Sp docs currently, what would you recommend as the best way to take the CSV and get it onto my companys network? Map the sharepoint site it is stored in on the server? Or a flow using a gateway to copy the files to the server as and when they're created? End goal is it automatically loads back into our ERP system. Thanks

[@ShanesCows]

I think gateway and have the flow do it.

[@LordNifty]

Where do you originally go through the JSON function in detail? It says it wants data, but it doesn't accept collections or the original SharePoint data source.

[@salma201084]

HI Shane, Great Video. thank you. I am facing a challenge when i am passing a combined collection. The parsing fails when i pass the combined collection output. it says expected object but array was passed. How do i fix it?

[@keepinitreal551]

Hi Shane, Thanks for the great video. Do you know if you can use the same CSV file to continue to store collection? In other words, every time you export, can you make it add onto an existing CSV file? This way you can continue to collect a library of information all on the same CSV file? Thanks in advance!

[@ShanesCows]

I haven't tried. I guess you could grab the old contents of the CSV, add the new stuff, and then make a CSV from the combination of the two. Not sure.

[@poojashetty2195]

Hi Shane, is there any way to avoid duplicate records while exporting data from powerapps to flow and storing it in excel?

[@himanshu21093born]

Hi Shane, thanks for the world of knowledge. I am facing an issue in many of my applications. Issue: My Applications are single-page applications (no landing page!) and while loading, Looked up items in my gallery or my sub-gallery (which is filtered from my parent gallery item) misbehave and do not populate properly for the first or second item. The issue resolves itself when I use any of the filters or some other action which refreshes the gallery. So I assumed this had something to do with the OnStart functions. My Resolution(1): Create a landing page. A pretty obvious solution, it allows the Application OnStart to run while loading landing page and the gallery to load when I open the next tab. My Resolution(2): Instead of creating a landing page, (since I have a search input text) I set the default for the search to a random string "Xyz" or "Loading Data" and set it back to "" after 2 seconds, all this while showing a Loading shape on the front end. This solves the inconsistency and allows my users to land on the page after 2 seconds. Any clues, or anything I might be doing wrong? (other than not having landing page- I am going to have them going forward anyways) Additional Info: I am using search and filters on Excel data backend (buzzKill)

[@ShanesCows]

I blame Excel. 😀 I would show a spinner until all of your loading finishes and make the user wait.

[@Prateeksha1993]

Hi Shane, Great Video! I currently ran through the steps however when I did the second step in the MS Flow and got the Inputs/Outputs, I guess they were a large number of records and hence had to download the output file however I was unable to paste that as my sample schema and it kept giving me errors. I was unable to use the IndentFour JSON format though for my dataset and had to instead use IncludeBinaryData as my format. would that now change how I parse the JSON?

[@ShanesCows]

You need to make a small test so you can’t get small output to define the schema

[@richiebrown6327]

This is a great video Shane, I'm wondering if there's a way to Parse blank information to a csv? I currently have a form with non mandatory questions. When these are left blank the export fails. When all questions are completed the export works perfectly.

[@jimhoeger5232]

I got the same error. I got around this by scrubbing my data and entering a placeholder for all blank fields.

[@jmajoros81]

Awesome! Can you do this other way round... CSV into PowerApps without using a 3rd party connector or xlsx table import action?

[@ShanesCows]

This is pretty close 😀 kzbin.info/www/bejne/h5S6m3SqbLaJpJY

[@clwumu]

Hi Shane. Thanks a lot for the video. Awesome. One question, can we create an excel file instead of csv?

[@ShanesCows]

Making an Excel file is possible but way hard! You need to have an Excel file that is a template, make a new file from the template, and then write your data to the table that was already in the new file.

[@andraa.5676]

Really cool! How did you create the first table with the checkbox? Can you point to the other video, please? Thanks!!

[@ShanesCows]

I think it was this video kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@Harm0n1cH0r1z0ns]

Thank you for your wonderful videos. I am not able to get the JSON format, in the flow the input and the output shows null. What am I doing wrong?

[@ShanesCows]

I am not sure. SOrry

[@adrianrolon5904]

Great video Shane! Is there any limitation regarding the number of rows the clearcollect function can gather?

[@ShanesCows]

If you are collecting from a data source then it will only retrieve up to the delegation limit. If you are adding them other ways there is no hard limit I know of.

[@Sam-bx9yv]

@@ShanesCows What are the other ways to get all the records from powerapps data table into power automate flow and create CSV. Do you have any related videos.

[@jackiedavis8339]

Shane, I've been watching your videos and you are awesome, got all my filters and sorts working because of you. One thing I am banging my head against the wall about is not how to export records so much (thanks to this video) but how to export ONLY the currently filtered records in the gallery. I'm beginning to think there isn't a way. Is there a video you could point me to that would help me with this? Thank you so much.

[@vascosoares7784]

try to create a collection while filtering and export the collection after.

[@reypangilan7157]

Hi shane, thanks for this video it help a lot. my only concern is once the file is exported the formatting of the date is different. how can we format the date when the file is exported according to our liking. Thanks.

[@ShanesCows]

You would have to write logic in Power Apps or Flow to make it your format. Save it as text not date at that point.

[@shrutivishal2621]

how to give an header to the csv file. like i want to name ur list as employee details with user logged in and then the list need to be printed

[@jesusitomaregmen1153]

hello sir, thank you for the video. this is what i need for my app. however when naming the created file is there a way that the filename of the csv file will be based from a value of an object in powerapps?

[@ShanesCows]

You can “ask in Power Apps” in your flow for the filename from Power Apps

[@MrAmitav2000]

Thanks for the video Shane. 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 connector with close to 10 K records to a CSV. Thanks in Advance.

[@ShanesCows]

Not sure I have never tried

[@queren7806]

Thanks Shane! Great video. Is there a way to populate an Excel template with some formatting? Thanks!

[@ShanesCows]

There are some actions but I haven’t ever tried 😑

[@queren7806]

@@ShanesCows Thanks Shane!

[@larsvanginkel3438]

Hi Shane, Thanks again. I implemented this in my app and works like a charm. One question: in your example the csv data is auto delimited into columns. In my csv export I still have to do the manual text to columns action. Is this an excel setting or am I missing something in the JSON to csv process?

[@larsvanginkel3438]

I figured it out . In my excel language settings ; is the delimiter. I put a replace on the csv table output to replace all commas with semicolons.

[@ShanesCows]

Glad you got it Lars. 😎

[@Higor682]

@@larsvanginkel3438 How did you do it?

[@WhyNot-gc7vf]

Super!

[@ShanesCows]

Thanks 😊

[@janicemorgan-singh7343]

This works brilliantly for my needs as a real newbie to powerapps but... I have one final nagging little problem which I can't seem to solve by myself. In the CSV output file, the optionset field values are all preceded with the word "value" when really all I want is the actual option selected in my sharepoint list. Any ideas what I would need to configure in the JSON example to drop the word "value" from the CSV file?

[@ShanesCows]

I haven’t tried. Guessing it will be a pain in the butt to do

[@johnheck1551]

Hello Shane, thanks so much for this great video. Really helped out. I have some fine tuning and additional things to do for the export based on user permissions, though this is a great start. I do have one question, how would you go about making the naming of the CSV file dynamic so that the Name can be system generated via what the user selects to filter the employee list? Or is there a better way? Another question, is can you use the items in the gallery list for the records to be exported to a csv file?

[@ShanesCows]

John you could make a string of the file name you want in POwer APps. Then set the flow up to "ask in power apps" for the filename. Pass the string and you are all set.

[@johnheck1551]

@Shane Young - figured out the filtering of the data based using the filter on the gallery to filter the employee list in the ClearCollect statement. I did try using ClearCollect(colEmployee, Gallery.AllItems) and kept getting an error in that statement. No issues with the filter being used in the ClearCollect(colEmployee, Filter(Employee, If(varActiveOnly, Accountenabled, !IsEmpty(AccountEnabled)), "DisplayName", "EmailAddress", "Title", "Location") works great. I can add all of the filters that the user can select in the viewing of the employee list for the gallery.

[@cipriantotal6097]

Thanks for the video, is it possible to populate a specific excel file from SharePoint (the file is like a quiz form)?

[@ShanesCows]

You can only write to files in OneDrive

[@aprachordia3228]

Thanks Shane for the video. It worked fine for the first time when I am writing csv file to OneDrive but if re-run it doesn't overwrite the previous file . Any idea what should i do for that?

[@ShanesCows]

Generate a dynamic file name so each one is unique

[@NL_IceMan]

Hi Apra. I just inserted a step before the file create to delete the existing file. Hope this helps. 🙂

[@robshields76]

HI Shane. Really like your videos. got me out of many a mess. I am trying to export an already filtered (using a searchbox) set of data and want to export the filtered data to a CSV. I come unstuck when Im trying to drop columns as 'IsChosen' doesn't exist its just filtered. Looked all over for help but cant find exactly the help I need.

[@ShanesCows]

You can't use IsChosen. You will need another method to select the records you want. Something like the concept from this video. kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@robshields76]

@@ShanesCows Thanks Shane. Looks v in depth. Will give it a go.

[@sanmeshghongade]

Hi shane great video Thanks! Is there a way to load more than 2000 items into a collection? When I tried this it returned only first 2000 items

[@ShanesCows]

Not directly. There are ways to trick it into loading more but I would push back and ask why.

[@dishankashetty9191]

Very useful video.I have a requirement where i want to convert the created csv to excel and send as a attachment via mail.please let me know how to convert it to excel witout storing it somewhere.

[@piyushlamba1134]

Hi, Thank you again for such an amazing video, can you please tell me is there a data limit for this, I have some 6-7k data rows with 19-20 columns, It is giving me error if I add all columns, if I add only 4-5 columns, it works.

[@ShanesCows]

It might be the type of columns you are adding, not the number. But I am not positive.

[@mrmitchell1121]

Great content as usual! Has anyone figured out a way around the size limit of the JSON function in PowerApps? It is a size limit issue not a record count issue which I have confirmed. Seems to raise it's head around the 4000 record size. So frustrating...

[@ShanesCows]

Interesting. I haven’t ran into that. 😑

[@kmuralikrishna1582]

@Shane By any chance can we create excel file instead of CSV ..? Yes as per requirement we need to create .xslt excel file ....kindly help me if possible

[@ShanesCows]

The very end of the video I talk about you have all of the info in Flow. So I don't see why you couldn't use that info to populate an Excel file. Not sure about XLST, I have never tried.

[@DedeP14]

Hi Shane, thanks for the video. I have a problem when generating the csv file. the header is correctly in one row, but the value of each column is in a different row. (Ex. Column : Year is in the first row, Value : is in the second row; Column : Report Number is in the first row, Value : is in the third row; etc) I expect, value of each column is in the same row

[@ShanesCows]

I am not sure, I would try again and see if you can find the issue in your setup. Sorry, not much help

[@otanzion9584]

Great video and really helpful. however how do you sort the columns as Age was first column on the export which is is awkward

[@ShanesCows]

I think if you use ShowColumns you can specify the order. Not sure though.

[@otanzion9584]

@@ShanesCows I am actually using ShowColumns yet the collection is sorted alphabetical order. ClearCollect(dbaseone, ShowColumns(Table1,"EID","EMAIL","Title","REGION","UNIT","GENDER","DESIGNATION","LOCATION"));

[@DeepDeep-zd5jq]

Hello I am getting data from dynamics CRM and creating CSV file in azure blob but formated value of options set field is not available for all records it showing only for starting 5000 records.

[@Seabaer]

Hello Shane! I try to the same as you. But i cant find an action "compose". Is it possible that i havn't Sharepoint. I only have dataverse?

[@martinwhite2369]

Hi Shane. Thanks for the video. Would it be possible to export the data to excel AND put the picture into a cell as well? Could it be possible to use the absolute URL for the picture? (Also, would you still do this the same way as it's been a number of years since the video was produced?)

[@ShanesCows]

Martin, I am not sure. I have never tried to put an image in Excel. Everything in this video should still be accurate but the stuff with Images I am just not sure.

[@tommills9364]

Hi Shane, complete beginner here but managed to create a data custodian app all through using your videos. Thank you so much for such great videos and clear explanations! However, after selecting a record the input is not working and is coming back with a 'click to download' button, what am I missing here? Any ideas? It seems like it should be so simple to select one record and export the data within that record to a .csv but after a week of various attempts I can't figure it out!

[@ShanesCows]

Not sure Tom. You are right should be possible but there are so many moving parts not sure how to nudge you along. 😐

[@tommills9364]

@@ShanesCows No problem Shane, thank you for taking the time to read and reply to my comment. For the moment I found a work around by clicking into said item and creating a csv with each datacardkey and still working on selecting each product in a gallery. Makes it so much more satisfying when I figure it out!

[@marounsader318]

hi shane appreciate your videos and help, im facing some issue with the check boxes, that when i check 2 or 3 all get rested and i have to check them again, have you faced this behavior before? can you help?

[@ShanesCows]

I haven't but check the Default property of the Checkbox and make sure it is ThisItem.CheckedColumnYouUsed

[@marounsader318]

@@ShanesCows worked thanks alot! i added a text box also to make users write the name of the output file :)

[@rocheverte]

Hi Shane, this is very useful and helps me out a lot. The problem I have is once I export a file in SharePoint I can't do it again as the file name already exists. Is it possible to create a CSV file that then adds an incremental ID to the filename?

[@rocheverte]

Nevermind, I've worked out I can use the Createfile_Filename function from the Dynamic Content and then specify the filename from within the app.

[@ShanesCows]

Awesome. Glad you got it. 😊

[@avaniejain5733]

That's a great video. Just one question, Every time , I am hitting button, CSV file is getting overwritten. IS there any way to append the exported CSV ?

[@ShanesCows]

I don't know how to append it. You might have to get creative and grab the content of the old CSV and then crate a new CSV that is Old + New

[@satyamdas1854]

Hello Shane... Hope you are doing great.. Can we achieve same functionality with out using onedrive Or SharePoint create file action??

[@ShanesCows]

You need to create the file somewhere. YOu could add the file as an attachment to an email I guess.

[@ashishojha7248]

How will manage comma (,) in csv for a comment column and if we have main header (Amount) of sub headers (Min, Max) so how we will populate it in a collection to pass in compose. Thanks 🙏

[@genaricheta5823]

A quick question, is there a way that the columns exported will not be arranged alphabetically? I would like my columns to be in the sequence I like.

[@ShanesCows]

You could try wrapping it in ShowColumns and specify them in the order you want. I am not sure it works but that is what I would try.

[@joseguilhermebustamante3654]

Hey Shane, Ur the best man! I did the same and my table has not seppared, all the info is on 1 field seppared by commas, did I mess something up ?

[@ShanesCows]

I would go back up stream and look at your collection and make sure it has columns, then make sure the JSON shows columns. Guessing the issue is earlier in your app/flow.

[@nAhmd1]

Hi Shane, is it possible to use JSON function in PowerApps to send data to flow to create a word document?

[@ShanesCows]

If you look in flow there are several Word actions you can use. :)

[@sunshinelabz]

Super... kindly show to convert to excel format without using SharePoint...like using Azure functions etc

[@ShanesCows]

I haven't done that before. Sorry.

[@sunshinelabz]

@@ShanesCows possible kindly do in near future

[@ryanvigneau1442]

Hey I'm having a little trouble with the last part of this. My Flow works, and it's created the file in the SharePoint site, but it won't open properly. Is there a way to make it into an Excel workable CSV?

[@ShanesCows]

Check your computer to see what CSV file defaults to. My computer opens these files in Excel automatically

[@zarzar1973]

Super input you Are making. Q? can you make a video(power app) where you import 3 col from a Excel sheet 1. Then in the app insert 4 New values and a date in the same Excel file but in sheet 2

[@ShanesCows]

Yikes Jens. I will have to think about that but I have never done anything like that so not sure I am much help with a video.

[@moazhar1064]

hii sir , i am taking sql table and making a collection then i am converting into Csv format with this method . and i m getting right output but if i add one more column in sql table and again create collection and run flow again then i am getting error i know because i m passing one extra column in JSON PARSE , so my question is "how can we convert a sql table which contains dynamic columns Adding into CSV ??"

[@ShanesCows]

I think you can make the fields not required but I haven’t tried this so it super sure

[@michaelhoangnguyen4077]

Hi Shane, I was able to export a gallery to CSV file. Is there a way to format this CSV file(converting the range into table) so that I won't need to format the file every time the I open this CSV file.

[@ShanesCows]

Not that I know of. I am sure it is possible but I got nothing to help here.

[@NtetheleloButhelezi-bh8bp]

can you please give more details on how to Import excel to power apps and display the data on a gallery to perform CRUD functionality

[@gayathrij9098]

I have a flow for creating and updating an items but the column formatted as a Number in SharePoint not accepting the Blank values. Can you please help me to fix this issue.

[@srilaxmigrao2734]

I had a doubt after creating the flow in power automate we do not have to share that to the users right? Sharing the app will be sufficient right?

[@ShanesCows]

COrrect, if the flow is triggered by Power Apps then you do not have to share it with the user.

[@RobinDamronII]

Hi Shane, been using this for a while now, however recently both of my apps that use it started reporting “JSON function cannot serialize…”{Attachments}””. I added attachments to the varDroppedRecordColumns and it fixed the issue for one of my apps but the other is still saying the same error. Wondering if you’ve encountered this recently and how you’ve worked around it?

[@RobinDamronII]

I found the solution, changed jsonformat.indentfour to jsonformat.ignorebinarydata & jsonformat.ignoreunsupportedtypes 🎉

[@ShanesCows]

Awesome Robin, glad you got it!

[@Eddyyc]

How do you update a csv value using Json? for example if i click again i would like to update only values that changed

[@ShanesCows]

Not sure. Haven’t done it.

[@troystaylor11]

Rather than changing the connection in PowerApps to get the Create File action to work, can't you just test the Flow using the I'll perform the trigger action? I find that performing the trigger action for new SharePoint actions fixes that the error.

[@ShanesCows]

Interesing idea.

[@pasupuletiramyabhargavi8268]

Hi Shane, Can you please explain how to export the gallery data to excel

[@jaimaxragnar3848]

Hi, thank you very much for your wonderful video, this is just what I am looking for. I have a little problem. I followed step by step the video and my csv is created but it is not properly formatted. All the data appears just in one column. Also the data appears with strange symbols. I use Spanish language with "Ñ" and accents. Could you please help me with that? Thank you very much!

[@ShanesCows]

Sorry for the delay. I am not sure. :( If you try it by using English do you get multiple columns? I wonder if the problem is Spanish characters or you have a bug. Trying English will at least help you confirm where the problem is.

[@tesnim89]

hi is really a nice feature . Thanks Shane. Just a question. How can i show my data with forgien charactere exemple in my csv file i have name "Frédric" it show for me after export "fr@Adric" .?

[@ShanesCows]

I am not sure. Sorry haven’t tried.

[@danielhampson5918]

Hi Shane, great Video as always. Just this time i am having Problems. My CSV File just writes each record in a singel cell. Not like your Demo CSV where everything is in a extra Cell. Could you help me on this topic?

[@ShanesCows]

Daniel I am not sure. Are you using the JSON function before sending your collection to Power Apps?

[@danielhampson5918]

@@ShanesCows Hi, and yes i am. I have narroed the issue down to the point of creating the csv. My Power Automate does not give me the choice "Body". I live in germany (incase that causes some sort of issue), and the only thing i can choose without the apply for all ist "text".

[@carolinapatino9503]

@@danielhampson5918 Hi Daniel, Can you solved your issue? Because I have the same problem and i dont know how i can solve that