Hi @boydsi,
Do you want to look at each row of an Excel file that is stored within your SharePoint library?
If you want to look at each row of an Excel file that is stored within your SharePoint library, I think the "List rows present in a table" action and the "Get a row" action of the Excel Online (Business) connector could achieve your needs.
I have made a test on my side and please take a try with the following workaround:
- Add a proper trigger, here I use Flow Button trigger.
- Add a "List rows present in a table" action of Excel Online (Business) connector, Location set to your SharePoint Site, Document Library set to your SharePoint library within the SharePoint Site that you specified above, File set to your Excel file, Table set to the Table name within your Excel file.
- Add a "Apply to each" action, input parameter set to output of the "List rows present in a table" action.
- Within "Apply to each" action, add a "Get a row" action. Location set to the SharePoint Site that you specified above, Document Library set to your SharePoint library within the SharePoint Site that you specified above, File set to your Excel file that you specified above, Table set to the Table name within your Excel file. Key Column field set to a column within your Excel table and the Key Value field set to corresponding Dynamic content of the "List rows present in a table" action.
Note: I assume that the data of your Excel file (stored within your SharePoint) has been formatted as a table.
Image reference:
The flow works successfully as below:
More details about the Excel Online (Business) connector, please check the following article:
Excel Online (Business) connector
Best regards,
Kris
