Export Power Apps data to Excel in CSV format

Подписаться 127 тыс.

Просмотров 207 тыс.

50% 1

In this video, you will learn how to export Power Apps data to Excel thanks to the JSON function which allows us to send Collections, Tables and Gallery data to Power Automate flow. The flow will build the CSV file and send a response back to PowerApps with the exported excel spreadsheet file link. The excel file will be available to download in Power Apps. Best part is the flow is reusable and can be connected to any Power App and can export tabular data.
#PowerApps #Excel #PowerAutomate
Table of Contents:
00:00 - Intro
01:05 - Create a Power Apps export to excel button
01:45 - Create a flow to export excel data from Power Apps
04:09 - Call flow from Power Apps and pass JSON data
07:05 - Create CSV Table in flow from Power Apps JSON data
09:39 - Create excel file in OneDrive and get share link to file
13:07 - Respond to PowerApps from flow
17:11 - Test Power Apps button export collection to csv
18:01 - Reuse export button with gallery data
23:36 - Reuse export to excel flow with a different Power App
25:48 - Subscribe

Опубликовано:

27 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1 тыс.

@teresaagustin5191 3 года назад

Awesome video Reza! Thank you so much for sharing this flow and all the filtered variations with us. I can already think of several use cases. I can’t wait to see the pdf version!

@RezaDorrani 3 года назад

Glad you enjoyed it! The pdf version is even better :)

@teresaagustin5191 3 года назад

Hard to imagine it could be better. Now I really can’t wait! I’m sure I’m not the only person who runs into folks at the company who are much more comfortable with spreadsheets and thus are a little reticent about converting certain processes to PowerApps. This solution gives us the best of both worlds so everyone can be happy 😃 I’m glad you shared the filter options because one of my use cases is exporting a list of raffle winners from my raffle app to Excel so we can send a report to Payroll. We used to have to manually type up a report so this will be an awesome timesaver. Thanks again Reza.

@RezaDorrani 3 года назад

@@teresaagustin5191 You are most welcome and thanks for the topic suggestions.

@PaulintheUK86 6 месяцев назад

I can't get the dynamic input for "content input" ... No dynamic content available... First step doesn't work for me. Any help?

@365g 3 года назад

Many thanks Reza - great stuff as ever and exactly what I need for the closing stages of an ongoing build. Looking forward to the PDF aspect in the next video.

@RezaDorrani 3 года назад

Glad you enjoyed it! The pdf version is even better :)

@bhainsley 3 года назад

Brilliant, patient, generous teaching, Reza. Clear instruction. Thank you. Thank you.

@RezaDorrani 3 года назад

You are most welcome

@cztop54 3 года назад

This is PERFECT! Anticipated every question and explained it in a manner that made it easy to understand and implement! Thanks -- once again!

@RezaDorrani 3 года назад

Thanks Cindy

@VikasShankarMishra 3 года назад

Thanks this is one of most common use case and you explained it in a great way !!

@RezaDorrani 3 года назад

Thanks for watching

@UB-qc8yk 3 года назад

Awesome! I really like the way you showed the various possibilities, you covered a lot of ground in this video.

@RezaDorrani 3 года назад

Thank you for the amazing feedback

@MrEk5150 3 года назад

Man, I feel that I owe you a lunch for this. This approach is so much better than the way I was doing this. I'll be able to cut down on controls in my app and make this process 1000% better for my users. Thank you Reza!!!!!!!!!!!!

@RezaDorrani 3 года назад

You are most welcome. COVID is only allowing virtual lunches at the moment.

@jasmingutierrez6815 3 года назад

Yes! I did it. I followed your instructions from start to end and i successfully exported my data to excel. Thank you so much. It made exporting data so easy.

@RezaDorrani 3 года назад

Fantastic!

@robinjamesnjarlely 3 года назад

Power Platform Masterclass. Great explanation Reza.

@RezaDorrani 3 года назад

Thank you Robin

@bideyyusuf 3 года назад

Its amazing the level of presentation you have Reza. it makes your videos more interesting and educating to watch. The PDF version is going to be even better am sure. Great job as usual.

@RezaDorrani 3 года назад

Thank you very much!

@anstolze3280 Год назад

TYSM Reza! There is no challenge that I could not solve through your videos! And it is always an incentive to optimize my apps again and again!

@RezaDorrani Год назад

Happy to hear that! Thanks so much for watching and learning from the videos.

@erikkozlowski4736 2 года назад

As someone just learning PowerApps, this video saved me so much time. Your skill and level of presentation is top notch.

@RezaDorrani 2 года назад

Thank You!

@KazekanAgiel 2 года назад

Thanks for the video, Reza! It was exactly what I needed. One question though: As of September 25th, Microsoft has retired the 'Direct' link option for creating a share link because instead of creating a long-lasting share link it would download the file instead... Unfortunately, downloading the file is the behavior I want and now I seem relegated to just opening the file in the browser, which for my situation is not ideal since you can't edit the Excel doc in the browser even w/ a link type of 'Edit'. Do you have any alternative methods to actually download the file rather than open it in the browser, apart from browser-level settings? Figured I'd ask it here rather than the Power Apps forums in case it helped others watching the video who noticed the different behavior. Thanks in advance!

@RezaDorrani 2 года назад

Try creating file in SharePoint library (with everyone having access to it). Then provide the link to file back to Power Apps.

@andrej8823 2 года назад

Did you manage to figure smth out? I have the same issue, as since the file doesn't get downloaded anymore all the data appears in 1 column...

@RezaDorrani 2 года назад

@@andrej8823 1 column should not be the case. I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com

@stevenmuchiri4856 2 года назад

@@RezaDorrani Hi, I tried providing the sharepoint link to the file in powerapps but I still can only open in a new browser. The Link Types in "Create sharing link to a file or folder" are only "View Only" and "View and edit". Or am I doing something wrong

@RezaDorrani 2 года назад

@@stevenmuchiri4856 Direct link is deprecated. You can formulate a link to SP manually.

@Joao-ze6mj 3 года назад

Great Reza! Saved me again! I have a question. When I create a collection, the columns are placed in alphabetical sequence (in the CSV file, the same). Is there a way to choose the column sequence I want? As your folllowers, can´t wait to the PDF video! PS: I was supposed to send you an e-mail about my PowerAutomate - PowerApps begginer mistakes to help you, but the last 2 weeks was crazy. I am really sorry about that.

@RezaDorrani 3 года назад

alphabetical sequence is an in-built behavior of the Create CSV table action. In advanced options for create csv table action, you can define custom columns and list out the header and values. Those will be ordered. Its more work. PDF video is in the works. PowerAutomate - PowerApps begginer mistakes - No worries. Whenever you get a chance, send me the list.

@Joao-ze6mj 3 года назад

@@RezaDorrani Ok, thank you!! I am trying to do that now. Finding out how to enter "value" expression.

@RezaDorrani 3 года назад

@@Joao-ze6mj To learn expressions check aka.ms/learnexpressions

@amiturmipurohit4297 3 года назад

I wish I had seen this comment after watching your video yesterday. I spent several hours trying to figure out why the VENDOR column was always placed last in the downloaded CSV Thanks for this video (and all the videos) Reza. They have helped me a lot in getting on board with PowerApps.

@adminipiapps8035 3 года назад

Iam also curious on how to change the column order of the collection to get another column order - non-alphabetically - in the exported CSV-File...i dont have a glue how to get it done...any suggestions?

@moniso2277 2 года назад

You are basically doing my project for me. I've been watching your videos all day long. Thank you so much! Greetings from Mexico City!

@RezaDorrani 2 года назад

Awesome! Thank you for watching my videos.

@Itsprincessa01 3 года назад

you are awesome Reza, i initially had an error and could not go past the first flow but once i resolved that, everything else worked like magic. Thank you so much

@RezaDorrani 3 года назад

Great to hear that it worked!

@anilkumar-ml2sl 8 месяцев назад

Following you for more than 2 years now amd every time i see your videos, my concepts become more clearer, thank you❤

@RezaDorrani 8 месяцев назад

Happy to hear that!

@anthonydemarco5567 2 года назад

Reza....this is just what I needed after searching so many videos....THANK YOU!

@RezaDorrani 2 года назад

Glad it was helpful!

@EchoDaPogi 3 года назад

I've been waiting for this kind of flow for a looooong time.. thanks reza

@RezaDorrani 3 года назад

You are most welcome

@kyawthumin9767 3 года назад

Thank you so much for teaching us. Really appreciate your effort. May God bless you.

@RezaDorrani 3 года назад

Thank you 🙏

@MohammadAli-ts2ev 2 года назад

This is going to be an asset for life and will be used in almost each and every app. Great research...

@RezaDorrani 2 года назад

Wow! Thank You!

@MohammadAli-ts2ev 2 года назад

While using the "Create Share Link" of Onedrive, I am not finding the Direct in "Link type" drop-down, the ms community says it's been deprivated in. Sep 2021. View or Edit option doesn't download the file directly. It opens an excel sheet online for viewing

@RezaDorrani 2 года назад

@@MohammadAli-ts2ev That feature was deprecated. That is a limitation now.

@kyawthumin9767 3 года назад

Very nice explanation. The way you explain is very clear and simple. Thank you so much.

@RezaDorrani 3 года назад

You are most welcome

@James-vm9mw 2 года назад

Wow, this video has been great! Spent ages trying to workout why I was getting an 'ID' error upon submitting the form only to realise that I had capitalised 'ID' in the schema - Doh!

@cristianlipski3730 3 года назад

The best explain about this issue. ThankYou Reza. you have a new follower. Good job!

@RezaDorrani 3 года назад

Awesome, thank you!

@sabrinatocho7206 3 года назад

Excelnte video, gracias por compartir! MUY ÚTIL

@RezaDorrani 3 года назад

Gracias

@paultyso 2 года назад

Brilliant stuff, answered all my questions before I had a chance to ask them!!

@RezaDorrani 2 года назад

👍

@thameralreefy 2 года назад

Once again, you come to the rescue, thank you so much, you are my savior Reza, Thank you.

@RezaDorrani 2 года назад

You are so welcome

@tristangeoffroy9286 2 года назад

Impressive !!! Reza!! It’s an entertainment to listen your tutorials. This one is very very helpful. Also interesting to see how you also have to struggle with issues, and how you managed to go through.

@RezaDorrani 2 года назад

Glad to hear that! I try and showcase the real-world experience of App/flow building.

@moneebtrq Год назад

Protect this man at all cost !

@RezaDorrani Год назад

Thank you 🙏

@ArijitDas-fr8ss 7 месяцев назад

You are a true life saver buddy. This is what we need exactly

@RezaDorrani 7 месяцев назад

Glad to hear the video is useful. Thanks for watching

@rajagopal9835 2 года назад

Excellent video and thanks so much for your valuable guidance always to Novices like us.

@RezaDorrani 2 года назад

Your most welcome!

@emailtosamit 2 года назад

Thanks Reza for Sharing your knowledge. Its helpful to quickly look at your videos for reference to build any functionality. Keep up the good work.

@RezaDorrani 2 года назад

Glad to hear that!

@zelfiroze 7 месяцев назад

Thank you so much. I won't probably be able to figure this out alone.

@RezaDorrani 7 месяцев назад

Glad to hear that! Thanks for watching.

@officialhumblefool 3 года назад

Great Explanation !!! your videos have made my life easier. I always look forward to them. Thanks

@RezaDorrani 3 года назад

Glad to hear that!

@rahulkumar-px7rk 3 года назад

After export column's sequence will change automatically, can you please look into this and suggest any solution

@RezaDorrani 3 года назад

@@rahulkumar-px7rk Many have commented on this. The sequential part is the default behavior. You will have to add a Select action and manually select fields in order you need.

@xdaniels13 Год назад

Man! I have been trying to do a better way to export data from powerapps. I try excel connector, sending email report. This is be far the best solution that I ever seen. Reza you are a legend!! So many thanks

@RezaDorrani Год назад

I will give you a better one which can work with large data as well. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UZdngrwWsqA.html

@xdaniels13 Год назад

@@RezaDorrani the only thing that I added to your solution is a wait for an hour and delete the file so my one drive doesn't get full of files. :)

@sabirrehman8733 3 года назад

Thanks Reza, you did well. Appreciated

@RezaDorrani 3 года назад

Thank you

@MadhusudanKaleMK 3 года назад

Awesome content! Explained really well Reza!

@RezaDorrani 3 года назад

Glad to hear!

@percymoyo2835 3 года назад

Amazing I have learnt a lot in two days watching these Videos

@RezaDorrani 3 года назад

Glad to hear that

@sachinmangalwedhe8194 3 года назад

Excellent...much needed...you are the best!!

@RezaDorrani 3 года назад

You are so welcome

@yakirrabinue3889 3 года назад

Great video! thank you for your efforts and for sharing your insights!!

@RezaDorrani 3 года назад

My pleasure!

@fionacai9225 3 года назад

thank you Reza!! You rock!

@RezaDorrani 3 года назад

Thank You

@rashidkhalid2010 2 года назад

Great work man! This option is way better than the PCF option. PCF has limitation on number of records.

@RezaDorrani 2 года назад

Thanks Rashid

@gepialago8782 3 года назад

Thanks! Very useful!

@RezaDorrani 3 года назад

You are most welcome

@swathibhat7577 2 года назад

Thanks for the detailed explanation.

@RezaDorrani 2 года назад

Most welcome

@ff-ui5ql 3 года назад

Very good tutorial, thanks for sharing!! Appreciate the level of detail you put on that. I hope MS will make things like exporting to Excel much simpler. Meanwhile, follow Reza's workflow.

@RezaDorrani 3 года назад

Thanks for watching

@ohmkumar80 3 года назад

Awesome Tutorial!! Exactly helped to my requirement.

@RezaDorrani 3 года назад

Great to hear!

@MrChaix 3 года назад

Very Powerfull ! Thanks !

@RezaDorrani 3 года назад

You're very welcome

@piantospestcontrol 3 месяца назад

An excellent guide - very well explained and concise.

@RezaDorrani 3 месяца назад

Glad it was helpful!

@mewithsharepoint8543 2 года назад

bro you are awesome in one shot you covered all :)

@RezaDorrani 2 года назад

Thank You

@kaveeshwijesinghe390 Год назад

Thanks a lot Reza, It is pretty clear and understandable

@RezaDorrani Год назад

Glad to hear that! Thanks for watching.

@Christian-tf6ol 3 года назад

Superb! Thank you Reza 👍

@RezaDorrani 3 года назад

You are most welcome

@djendjou1 Год назад

You Rock, Reda!

@RezaDorrani Год назад

Thanks Lessy

@bharanilinks Год назад

Very useful. Thank you Reza !

@RezaDorrani Год назад

Welcome

@oluwatobiyusuf 2 года назад

Another knowledge learnt. Thanks so much Reza

@RezaDorrani 2 года назад

You are most welcome

@ramprakashm7891 2 года назад

Thanks Reza! Learned a lot :)

@RezaDorrani 2 года назад

You are most welcome

@swamys9625 Год назад

thanks for the wonderful demo

@RezaDorrani Год назад

Thanks for watching!

@lamvu9748 Год назад

This really help me. Thanks alot Reza. Wish you all the best.

@RezaDorrani Год назад

Most welcome

@BronceCaballero 3 года назад

Thank you Reza!! 🤝

@RezaDorrani 3 года назад

👍

@viricoria2132 2 года назад

Thank you very much. This video is amazing

@RezaDorrani 2 года назад

Most welcome!

@ajaychoudhary5596 3 года назад

Amazing video.. really helpful.thanks Reza you are awesome 👍🙏

@RezaDorrani 3 года назад

Glad it was helpful!

@hansanacham 3 года назад

Thank you. you saved my life

@RezaDorrani 3 года назад

Happy to help

@dianarobledov1670 Год назад

you are awesomeeee!! thanks for this!

@RezaDorrani Год назад

You’re most welcome

@dev6296 6 месяцев назад

Many thanks 🎉 Very useful content ❤

@RezaDorrani 6 месяцев назад

Most welcome

@nicaortiz 3 года назад

Excelent!! Thank you

@RezaDorrani 3 года назад

Thanks Alvaro

@alexandrebormio 2 года назад

Great job! Tks.

@RezaDorrani 2 года назад

Thanks for watching!

@Deadpool12353 3 года назад

excellent video i was looking forward to this.

@RezaDorrani 3 года назад

Thank You

@cheltonnunes7921 Год назад

Hello Reza, iam from Mozambique and i like so much your videos it helps me a lot! A learned a lot of things with you Thank you!

@RezaDorrani Год назад

Thanks so much

@cheltonnunes7921 Год назад

@@RezaDorrani I would like to import data from excel to a gallery in my app and be able to delete some records and then be able to save in SharePoint list. Sorry about my English, my language is Portuguese.

@RezaDorrani Год назад

@@cheltonnunes7921 Why not clean your excel file (delete records not needed), import into SharePoint and then build an app on top of it?

@meryemgazanayi5665 9 месяцев назад

Really u saved my life thank u sooooooooo much u just incredible

@RezaDorrani 9 месяцев назад

Most welcome

@shaikzuber7945 3 года назад

Thank you for another awesome video. Waiting for pdf Generator video.

@RezaDorrani 3 года назад

Coming soon

@mukeshs8973 Год назад

Amazing video!

@RezaDorrani Год назад

Thanks

@frenamakenson9844 3 года назад

Thanks for sharing this useful tuto I’ve been waiting so long for this, i own you a drink... for this one

@RezaDorrani 3 года назад

Glad it was helpful & Cheers!

@frenamakenson9844 3 года назад

Did you already do the pdf version ?

@RezaDorrani 3 года назад

@@frenamakenson9844 Not yet. Working on demos for that video.

@callbainis Год назад

I loved this one - nice work

@RezaDorrani Год назад

Thanks

@christerrussberg3059 2 года назад

Thanks for sharing.

@RezaDorrani 2 года назад

Thanks for watching!

@jevinwang3769 2 года назад

this is super helpful !!!

@RezaDorrani 2 года назад

Glad it was helpful!

@efficiency365 2 года назад

Amazing stuff.

@RezaDorrani 2 года назад

Thank You

@JoshuaRandall-rt1nl Год назад

Good Morning. First off THANK YOU SO MUCH for all your time you spend teaching us. These videos are instrumental in development and are a blessing. I have a question concerning custom options in advanced section of the create csv table. I have sorted my columns, however it is creating an individual file for each row in the flow due to the apply to each. I am not sure how to get past this. The columns get sorted correctly however the data is in multiple files and not just one. Any help or direction you might be able to give would be very helpful! Thank you again so much!

@RezaDorrani Год назад

Thanks for watching and liking the videos. If you follow steps in video, it should create 1 file only be it custom columns or not. I will have to look at your flow in action to know the reason for your issue. It would be best to post your issue with screenshots on the forums at powerusers.microsoft.com

@venumadhavravulapalli1463 Год назад

Awesome Presentation Reza 👌

@RezaDorrani Год назад

Thank You

@CSteinberg03 2 года назад

Awesome as always Reza. Question: Any way to apply specific formatting to excel on export. We want to have a certain order like others have mentioned, but also want to be able to automate the column width and row heights based on the data coming through so the users do not have to format the data once it is exported. Any advice or guidance on this?

@RezaDorrani 2 года назад

I don't believe formatting is an option. You may want to look at Office Scripts for that.

@homaperween9580 3 года назад

Awesome video sir thank you .. plz make videos for accessesbility features in power app

@RezaDorrani 3 года назад

Thank You. Accessibility in Power Apps - check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nEVT8LPrszY.html

@itamarconceicao6708 2 года назад

Awesome!

@RezaDorrani 2 года назад

Thank you! Cheers!

@arshiafirdous367 2 года назад

Thank you Reza

@RezaDorrani 2 года назад

You are most welcome

@SKEDURINRAJA Год назад

Excellent 👍

@RezaDorrani Год назад

Thanks

@ssmatos1970 2 года назад

Thank you Reza for your videos, I'm learning a lot with your videos. I have a question, if in my galery I have photos can I export the photo link for the excel file?

@RezaDorrani 2 года назад

If you have a column that stores photo link then Yes.

@muhammadfadhli9900 2 года назад

This is awesome..

@RezaDorrani 2 года назад

Thanks

@oluwatobiyusuf 2 года назад

Thank you Reza. This video came in handy today, I also leverage the new power automate pane feature so I did not have to reconnect my flow when I made a change. However, I did not see "direct" option, I only saw view and edit option in the link type under the create share link action in power automate

@RezaDorrani 2 года назад

Thanks. The direct link option type has been deprecated since. You will need to store file in a data source eg. SharePoint and then get its link.

@oluwatobiyusuf 2 года назад

Thank you so much @@RezaDorrani

@Samshujayanagar 5 месяцев назад

It’s not power apps anymore. Reza apps 😀. Thank you so much for the video. Great job 👏🏼

@d3f0n3 2 года назад

Reza - You are magnificent! You have helped me immensely lately with your videos. I do have a question. I noticed that your columns on the CSV has spaces between words on the SPO list and did not show up with 0X0020 between the words like mine does. I know now that I shouldn't use spaces on columns but is there a way to fix it without having to rename everything everywhere? Also my columns on the csv are showing names with "Field_ColumnName" (the field part) what is causing that? - Thanks again!

@RezaDorrani 2 года назад

Thank You so much. Happy to hear my content is helpful. That's internal name of column in SharePoint. Only way to change it would be to recreate it or use Select action in flow to map your column names.

@varmanvishnu 3 года назад

Awesome, great video. Everything you make our job easier and address the essential requirements. Thanks for your support. You have shown me to create the file in CSV format. Is there a way to create.xlsx file? It really helps me in my project. Thanks in advance.

@RezaDorrani 3 года назад

For xlsx, you would need to create an excel file, add table to it and then start adding rows in the table. It's a longer route. CSV is also a type of an excel file.

@isomuchps3 2 года назад

Hello reza , it’s appreciated what ur doing with sharing ur knowledge with us and the efforts u put , kindly can u clarify how we can re arrange the columns when we create csv,I have tried the parse then select , but my columns sometimes having a value and sometimes not and if I defined the schema it will fail if there is discrepancies in the value , do u know any way around it ? Very much appreciated

@RezaDorrani 2 года назад

In advanced options for create csv table action, you can define custom columns and list out the header and values. Those will be ordered. I believe you need to use the expressions syntax there. Something like item()?['Column internal name'] I do not have a specific video on this scenario though. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@snkvlogs1994 2 года назад

Very helpful tutorial, but it would be great if you can share how to work with Create CSV Table custom Column option.

@RezaDorrani 2 года назад

Custom columns is to select the columns you need from the array object passed to the create csv table action. I do not have any video on that. I will recommend checking on the forums at powerusers.microsoft.com/

@adilaishak1476 9 месяцев назад

Hi reza, awesome video as always! Just wondering, if I already have a collection do I have to repeat step at 21:05 ?

@RezaDorrani 9 месяцев назад

You dont have to. All it needs is a collection.

@jcbagz 3 года назад

Thanks @rezadorrani! How would you handle a 'Choices' type with multiple values?

@RezaDorrani 3 года назад

Use Concat function

@logeshwariannamalai2754 3 года назад

Great Video! Its very helpful and understandable !Can you share the same in pdf format with more filters in gallery data

@RezaDorrani 3 года назад

I am working on a video on the pdf export.

@zerocool200380 3 года назад

Reza, this is GREAT! Can you kindly provide us with a link for the flow and one power app dummy so we can play with this?

@RezaDorrani 3 года назад

Since my data source is SharePoint, it would be a challenge to share the list. The video is a step-by-step tutorial. I would recommend to try it out and if you have any issues, I am here to help and guide.

@prajwalskateel 3 года назад

Great video

@RezaDorrani 3 года назад

Thanks

@EcoRhythmExplorer 3 года назад

Very useful

@RezaDorrani 3 года назад

Thanks

@user-we9rs7os2z 11 месяцев назад

Thank you so much, amazing tutorial and very good explanation. Can you please let me know if it is possible to export the file on local computer folder instead of one drive or sharepoint

@RezaDorrani 11 месяцев назад

I am not sure what options are there for it. There may be a specific connector for it. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

@motor6656 Год назад

Thats great stuff! Thank you. At 21:35 where you create the collection: is it possible to custom sort the column names for the Excel output? Currently sorting is always alphabetical in ascending order.

@RezaDorrani Год назад

Many have commented on this. Alphabetical sequence is an in-built behavior of the Create CSV table action. In advanced options for create csv table action, you can define custom columns and list out the header and values. Those will be ordered. Its more work.

@shrikantgaddapati Год назад

Hey Reza, its really amazing with the experience you have been giving us to explore and drive properly with the concept, the video is really useful!/ I have a multiline column, but when I export the values are broken into different pieces that to fir in one cell. Bring know also used Substitute Function, with spaces but no working at all!. can u suggest something on that, how dynamically we can do that?

@RezaDorrani Год назад

Thanks so much. I have not come across this issue related to spaces. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@anupmondal6723 Год назад

Thank you for the wonderful lesson, I am new to this powerapps things and learning lot from your videos. I have one question when I exporting a collection using your flow all text field giving correct result but for choices columns getting {value : "abc"} in csv, how to eliminate that?

@RezaDorrani Год назад

Because thats how choice columns are rendered. You would need to either shape the data in power apps and send to flow or write expressions in flow. I have also shown another technique for export scenario which may help. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UZdngrwWsqA.html