
I would like to create a flow that filters the table for each Item and saves it as new file named Item.
Desired Output is Each Business unit in Separate excel with the BU name. Please someone Guide to achieve the Result.
Note- Am new to Power Automate please explain in detail
I think you should use power automate to transfer the data to a SharePoint list and then create excel files for each business unit and a power query that gets the filtered data from Excel.
I think that would be a better workflow than trying to create individual Excel files with Power Automate.