cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JMR_
New Member

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

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

YangLiu_0-1625238540284.png

 

View solution in original post

6 REPLIES 6
manuelstgomes
Super User
Super User

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.

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

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!

YangLiu_0-1625237231353.png

 

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

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.

YangLiu_0-1625238540284.png

 

JMR_
New Member

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (3,787)