
Hi
I am new to Power Automate. I was able to successfully build a manual flow to simply move a specific file from one folder to another. However I would like to automate this as follows:
I want to create an automated flow in sharepoint online to move excel workbooks from an /In Progress folder to a /Completed folder based on a cell value in cell A2 of Sheet 1.
I am not sure how to specify in the flow - to check the cell value of the files in the source folder and if 100% then to move to 'Completed' folder and if >0 and <100 then move to 'Interim folder', if 0%
Any help is much appreciated. Geeta
@gh_sp05 is your data in excel defined as table? Also do you have any other column in excel based its value, you can fetch that row in excel?