Let user select one Excel file but output to multiple sheets

Question

Hi all, I'm wondering how to use only one "file browse" tool to let user select single output Excel file, but in my flow, I will be outputting information onto different sheets of the selected output file?

For instance, depending on the condition, my results will be output monthly bills to tabs such as "Paid", "Unpaid", which have same structures. But I also will have "Summary" tab of a summation of paid amounts, and an "Exception" tab which means I received a bill that cannot be mapped to any booking records.

Thanks!

Qiu · Answer

@yoyoumysin

There is an option for outputing multiple sheets with one file by feeding the full path.

If you could proivide a sample dataset, we can definitely figure something I believe.

yoyoumysin · Answer

Yes Qiu, you are correct, I intend to overwrite the output file.

Qiu · Answer

@yoyoumysin 
By allowing user to select the output file, is that correct to assume that it is allowed that selected file to be overwrriten?