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/U...