Flow to Add Update Delete items from Excel to SharePoin

[Zifeng]

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

Excel table

Name	Age	Location
Bob	18	America
Ana	22	England
Joe	23	Korea

Sharepoint List

Name	Age	Location
Bob	18	America
Ana	22	Canada
David	23	Japan

Name column is the key.

I want the flow delete the 3rd row, add "Joe" row and update the country cell in 2nd row of Sharepoint.

 The Sharepoint list will perform like Excel table.

and this is my reference video: https://www.youtube.com/watch?v=nlw5_qV8pIo&t=611s

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 

[ScottShearer]

@Zifeng 

Are you saying that you want the SharePoint list to be identical to the Excel table?  If so, can you tell me why you want to update the country in the second SharePoint row?  It is Canada in both Excel and SharePoint.

Also, if there aren't a lot of rows, it might be much easier to delete all items in the SharePoint list and repopulate it from Excel.

How is your Flow being triggered?  Recurrence? 

[Zifeng]

Hi ScottShearer

I'm sorry it's my typo, the Canada in row 2 of Excel should be "England" and anything else.

And actually, in my list, there are 3000 rows.

Ideally, I want to Recurrence as the excel sheet uploaded to sharepoint.