You’re offline. This is a read only version of the page.
I want to establish a connection between Sharepoint and an excel file (exported from Sharepoint in an .iqy format) through Power Automate in order to update automatically the megadata of the Sharepoint library when I make changes to the excel file. Which process and steps should I follow?
You can’t automate changes from an Excel IQY file → SharePoint metadata directly, because an IQY file is just a web query link, not a live data connector Power Automate can trigger from. Instead, use this supported approach:
Recommended Process
1. Store the Excel file in SharePoint or OneDrive
Power Automate can only read Excel reliably when the file is stored in SharePoint/OneDrive and formatted as a table.
2. Convert your Excel sheet to a Table
Open Excel → Select your data → Insert → Table
Save the file back to SharePoint.
3. Build a Power Automate flow
Trigger:
When a file is created or modified (properties only) (SharePoint), OR
Manually trigger a flow if you want to run it on demand.
Action: List rows present in a table (Excel Online connector) → point to your Excel file and table.
Loop through each row.
Update file properties / Update item (SharePoint) → map the Excel columns to the SharePoint metadata fields.
Share
Report
All responses (
Answers (
224
