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

Notifications

Announcements

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
    68,898 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard