Re: Read local excel in Power Automate web
Hi,
To read the content of a table from a local Excel file and iterate over its rows in Power Automate web,
you can use the Read from Excel worksheet action.
This action allows you to retrieve the value of a single cell or a data table.
Here’s how you can use it:
To access the local file system in Power Automate, you can use the File System connector1.
This connector allows you to connect to file systems on your local or network machines to read from and write to
files using the On-Premises Data Gateway.
Here are the steps to use the File System connector:
Add the File System connector to your flow.
In the File path field, specify the path to the file you want to access.
In the Username field, enter your Windows username.
In the Password field, enter your Windows password.
In the Gateway name field, specify the name of the gateway you want to use.
Once you have connected to the file system, you can use the Read from file action to read the contents
of a file and the Create file action to create a new file.
Add the Read from Excel worksheet action to your flow.
In the File field, specify the path to the Excel file you want to read.
In the Worksheet name field, specify the name of the worksheet that contains the table you want to read.
In the Table name field, specify the name of the table you want to read.
In the Output field, specify the name of the variable that will store the table data.
Once you have the table data, you can use the Apply to each action to iterate over its rows and perform any desired operations2.
Regarding the issue you encountered where Power Automate continues to read the same file even if you replace
the local Excel file with another one of the same name,
it could be due to the file being cached by your browser.
You can try clearing your browser cache and cookies and see if that resolves the issue.
