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

Опубликовано: 28 Сентябрь 2024
на канале: abm abm
3,753
31

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