I'd like to create a flow which works as follows:
I'd like to get one part of the data from a master excel sheet on a monthly basis and save this chunk of data in a separate tempalte file. I'd also like to rename this new file adding the timestamp. So basically at the end of the process I'd like to have 1 master sheet, 1 blank template file (which can be duplicated in every month) and 1 new file with timestamp which has the structure of the template and the data from master. The sheets are stored in a OneDrive Business folder.
I already have the pieces I'm just not sure how to put these together. So the logic I followed is this:
- extract data from a master excel file (node: List rows present in table)
- paste the data into a template file (node: Apply to each & Add row into a table)
- save & rename the template
The issue is that I loose the blank template file so next month I cannot put data in there.
As a workaround I tried to duplicate the blank table in the flow before pasting the data from master but I wasn't able to use this newly created sheet as a reference of the paste part of the flow.
Any idea how to solve this?
Thanks for any help in advance,
Yes, good idea. This is what I wanted to do as a workaround - tried to describe it here, sorry if it was unclear:
"As a workaround I tried to duplicate the blank table in the flow before pasting the data from master but I wasn't able to use this newly created sheet as a reference of the paste part of the flow."
Let's say I duplicate the sheet using the name with a timestamp. How should I tell Flow to use this file?
Hi @Paulie78 ,
could you please share the details with me? I'm still struggling to figure this out and it seems that you managed to find a solution.
Hi @P_D_G ,
I did build a solution, but I didn't post the details of it. It was flaky and not a good enough solution to post. It's actually a tricky problem. I didn't put any more time into finding a solution once the method I initially thought proved to be unworkable.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!