Hi Folks,
I would like to store an array that I generated in flow in a new excel file inside OneDrive. It's an array with single object of string type values. What should I give in file content of create file action to achieve this?
Expected output:
Thank you.
That’s exactly what I was suggesting!
👍
Hi @MarconettiMarco ,
I was able to complete this requirement by following the below video:
https://www.youtube.com/watch?v=RB_ySjhm9Sg
Thank you.
ok @rbn_nue ,
so you should follow these actions:
1.Create a file with content equal null,
2. Create an excel table : you have to specify the range and the columns names
3. Add a row into a table: got from your array, so the system will automatically create an apply to each loop
Please let me know
BR,
Marco
Hi @MarconettiMarco ,
Yes, that would be ideal and straight forward. But due to business requirement we have to go with OneDrive to avoid dependency with an SPO site. I just want to store current data in OneDrive, so that next time the flow runs I can check if it's same item.
Thank you.
Ok @rbn_nue ,
have you ever considered to use a SharePoint list instead of the excel spreadsheet?
BR,
Marco
Hi @MarconettiMarco ,
Add a row might work, but what I'm looking for is to create a new excel file and add this array as content.
Hello @rbn_nue ,
are you able to grab these values form the array and using the excel “add a row” action, add the row in your spreadsheet?
otherwise please use the “Parse JSON” action, the From must be your array, and in the body click on “generate from sample “ and past your json structure.
Then you should be able to grab the values and put them in the excel “add a row” action.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco