Power Platform Community Forum Thread Details

I am creating a flow to Add Update Delete items from Excel to SharePoint

Excel table

Name Age Country

Bob 15 America

Ana 19 Canada

Joe 22 Canada

Sharepoint list

Name Age Country

Bob 15 America

Ana 19 Japan

David 23 Japan

I want the flow delete the 3rd row, and update the country cell in Sharepoint list row.

finally, the Sharepoint list will perform like Excel list.

at the last process, when I entry item()?[‘Data2']

the error message shows The expression is valid

Could you please help me with any option .

Thanks

Gautmish

Categories:

Flow to Add Update Delete items from Excel to SharePoint