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 / Look up a SharePoint I...
Power Automate
Unanswered

Look up a SharePoint ID based on another column in the list

(0) ShareShare
ReportReport
Posted on by 674

I have a flow that reads items from an Excel file, then pushes them to a SharePoint list. In some cases, new items are added (creating a new SharePoint ID), but in other cases, I want to update a batch of records that already exist in the SharePoint list. The Excel file (source for the updates) does not contain the SharePoint ID. However, the SharePoint list has other columns that are unique and could be used to look up a unique SharePoint ID. I would like to use Compose or another method to make sure that within a loop, when using the Update Item action, I am updating the correct item.

Runner55552_0-1652367096939.png

 

Categories:
I have the same question (0)

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard