Power Automate – Community Question – Read Excel file (Dynamic Table) and Update SharePoint items



Power Automate – Community Question – Read Excel file (Dynamic Table) and Update SharePoint items

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.