Power Automate – Community Question – Read Excel file (Dynamic Table) and Update SharePoint items
This video explains how to read an excel file dynamically from OneDrive and filter SharePoint list record and update list item.
Expression I used for creating Excel Table range
=OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),3)
Community Question:
https://powerusers.microsoft.com/t5/Using-Flows/Update-SharePoint-list-items-with-Excel/m-p/2075637#M37697
Comments are closed.