The button works correctly and executes the flow as I wanted it to do.Ħ.After all those steps I would finally like to show how the output from my flow looks in my Excel file.

On the picture above you can see that I am launching the flow using a button in another list. Next I would like to show you how the specific elements of my flow look in detail:.Here is an example of what the data from that folder looks in the Excel:Ĥ.Below I will present what the data looks like in Power Automate and what flow I have built in order to try and solve the issue:.Here is an example of how the data looks in a specific folder:.I would like to merge those three sheets into one sheet using Microsoft Power Automate.īelow I attach the screenshots of what I was trying to do to solve the problem:ġ.Here is how the folders with the Excel data look in SharePoint initially: Each of the tables contains relevant data. I have three Excel sheets in three separate folders on my SharePoint site. I am experimenting with Microsoft Power Automate but quite recently I encountered a problem which is too complex for me to solve.

Power automate desktop sharepoint excel