Move files based on cell value in an excel sheet

[gh_sp05]

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

[annajhaveri · Accepted solution]

@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?