How to Save Excel files within the flow?

[RamyHussein]

I have Excel File in SharePoint folder.
Usually the Users make updates every month.
I create the flow to consolidate the Sheets in One Excel file.

how to overwrite the recent consolidated Excel file and save it with in the Flow in temp folder for example?

[k10shetty1]

Hi @RamyHussein,

You can use the Create Temp Folder node to create a temporary folder within your workflow data area. This node’s output will contain this folder’s location as a flow variable. You can use Excel Writer to save the input file in this location and use it for further use within the flow.

Best,
Keerthan

[RamyHussein]

I made this, and it works with me now.
Transfer the DATA from SharePoint to Work Flow, and then everything moves easy