web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to Add Update Del...
Power Automate
Unanswered

Flow to Add Update Delete items from Excel to SharePoint

(0) ShareShare
ReportReport
Posted on by 2

Hi

 

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.

 

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

Gautmish

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,026 Most Valuable Professional on at

    In his video Data1 and Data2 represent columns in his SharePoint list/Excel file.  You have different names on your columns.  Make sure the names match.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard