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 Apps / How to find matching r...
Power Apps
Answered

How to find matching record of 2 collections

(0) ShareShare
ReportReport
Posted on by 98

Hello,

 

I am following the guide (link below) to bulk update records. I have a seperate collection for modified records and will be added as soon as any input change, got that working so far. 

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

However, I added a button that would simply add a new record in the collection. This creates a problem where functions like: 

Remove(Modified_Collection , Filter( Modified_Collection, ID = ThisItem.ID ))

or

LookUp(Modified_Collection, ID = ThisItem.ID)

These wont work anymore as adding a record manually does not generate a unique ID ... Now I coul theoratically manually generate the ID by taking the last valid ID and increment by one, temporarily. But this feels like dirty work is this the proper way of doing it?

 

Another thing I tried was from another collection I added a delete button what would look like this:

From_Original_Collection: Remove(Modified_Collection , ThisItem)

This does nothing ... Any idea?

 

 

 

 

Categories:
  • Verified answer
    TimRohr Profile Picture
    669 on at

    One suggestion... You could have an extra column in your Collection that represented a "Local GUID" that you would manage. Write your new items to your Collection and handle any algorithmic output of an ID as makes sense to you.

     

    Then, follow the logic in this post to tie the ACTUAL GUIDs (in your datasource) to the records associated with your local GUID field, and update accordingly).

  • Owizardo Profile Picture
    98 on at

    Thanks TimTohr it makes more sense doing it like that. Ill give that a try. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 283

#3
Mohsin Ali Profile Picture

Mohsin Ali 221

Last 30 days Overall leaderboard