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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
28 | |
26 | |
23 | |
17 | |
10 |
User | Count |
---|---|
58 | |
56 | |
29 | |
27 | |
24 |