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.
Solved! Go to 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.
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.
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!
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
User | Count |
---|---|
32 | |
31 | |
24 | |
24 | |
20 |
User | Count |
---|---|
59 | |
57 | |
43 | |
37 | |
28 |