How to Export Multi Choice Column data to CSV using Power Automate in the fastest possible way.

Рет қаралды 2,657

Жыл бұрын

In this video I show how to export data from Power Automate to CSV where the source data has nested arrays in the most efficient way possible.
This is an answer to a Power Automate Community forum post:
powerusers.microsoft.com/t5/B...
The user followed a guide by Reza which you can see here:
• Export Power Apps data...
This additional information will help you to deal with complex JSON structures when exporting to CSV.

Пікірлер: 12

@markweyman Жыл бұрын

Thanks Paul- the music was a little off putting but the solution you were demonstrating was compelling enough to watch until the end 🎃

@PaulieM Жыл бұрын

Thank you / the music was an experiment really. Just playing.

@sundeepyama 9 ай бұрын

I spent almost 2 days to figure this out but it didn't work for me. Thank you for making this video, you made by day!

@PaulieM 9 ай бұрын

You're welcome Sundeep

@om0729 Жыл бұрын

Thats amazing and mind blowing 😍😍

@joanconnelly9547 Жыл бұрын

Thank you Paulie, you explained it perfectly and I was able to follow along and get the results I needed using a SharePoint list. Thank you, thank you, thank you!🤓

@heymanpluto2591 Ай бұрын

Is there a way to not use the column header in the csv file and assign a new column header

@praveenkm3964 Жыл бұрын

Thanks for the video, can you please give the expression in the comments .

@stlaurent26 11 ай бұрын

Hi Paulie, I am new to Power Automate, this video just blew my mind : ) , could you please upload video instructions how to back up MS List (with plain text and choice fields) to CSV with field names, without manually mapping fields 1-by-1? I am struggling with "columns = automatic" of "create csv table" action, it doesn't export actual field names, and I have many lists/fields that I don't want to manually map them

@PaulieM 11 ай бұрын

Why not just export it as json? Then it will be in the right format to reimport if you needed to do so.

@stlaurent26 11 ай бұрын

thanks, i did exactly that