Hello All,
I have 3 flows and three outputs. I wanted to consolidate all these outputs into a single file. E.g. In a single file one tab for each output. Please assist.
Solved! Go to Solution.
Hi @Learner09
As long as sheet names are different you should be able to write to single file different sheets. Just make sure the output option is set to overwrite sheet and not overwrite file.
Workflow:
Hope this helps 🙂
Thanks you @atcodedog05 for the flow, but how I can consolidate all three outputs in the Single output excel sheet. I want tab like
1 tab - Output 1 data
2 tab - Output 2 data
@atcodedog05 Please see the attached file for expected output. Basically, I need to merge all outputs into 1 file, or I can say I want all output in a single file with different tabs so that I able to see all data in a single file.
Hi @Learner09
The above example is doing the same as your expected output. Can you check the attached output excel file.
In the workflow at end i using input tool to just show you all the different sheets
Hope this helps 🙂
Hi @atcodedog05 in all the output data tool i have updated the paths "Output sheets.xlsx|||Output1", "Output sheets.xlsx|||Output2", "Output sheets.xlsx|||Output3", but how i extacted / export all those outputs in single excel?
_
Hi @Learner09
In this path "Output sheets.xlsx|||Output1"
Output sheets.xlsx - file name
Output1 - sheet name
Hence all paths are writing to the same file different sheets.
Hi @atcodedog05 Thank you, Now I got your point. It's working 🙂