Add a Row in a table then send data to a local csv file?

[JMR_]

Hi All,

New to power Automate so apologies if this is easy or can even be done.

I have an MS form, when the form is populated it sends the data to a new row in the online excel table, is there a way this data can then be sent to a csv file on my local machine? 

Any help, advice will be appreciated. 

[manuelstgomes]

HI @JMR_ 

The easiest way would be for you to have your OneDrive synced to your machine and save it to a folder there. Otherwise I can't see a way for Flow to save on your local machine.

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

[JMR_]

Hi @manuelstgomes  

Thank you reply and suggestion i will try to sync it up, how would get the flow to add the row to a csv?

Thanks, 

JMR

[Yang-Liu]

Hi JMR

You will need a trigger - When a new response is submitted

Then Get Response Details 

Then Add a row into a table

Please see the screenshot below, hope this helps!

[JMR_]

Hi @Yang-Liu 

Thank you for the suggestion, i have the above you reccomened already running i want to be able to send the new row data to a csv.

Thanks,

JMR

[Yang-Liu · Accepted solution]

Hi JMR,

Oh, I see. Then you can use the Create CSV table action to convert rows in your excel file and then use the onedrive connector to output the csv file.

[JMR_]

@Yang-Liu Thank you so much for the help and learning today.