Is there a way to add a sheet to with built in excel formulas to multiple files all located in the same location? Kind of like a directory input but for the output where the sheet would go out to all the .xlsx files in the folder.
Sorry, so I have a flow that is creating multiple sheets based off a column value using a formula and filepath tool. Then those multiple sheets are going in to multiple files ina n output based off the column value. Once the 100 files each with their multiple sheets are sent to the folder location I was wondering if I could create a new flow and input a summary tab with built in excel formulas and create an output that would send the sheet to all the 100 files in the folder location.