Announcements
I need to compare two records. If one is the same as the other. Resulting in true/false. Any ideas?
HI @martinav ,
If you are looking for any identical records in the collection, I suggest you GroupBy the collection by all fields you want to compare (with Data as the last grouped field) and then look for groups where CountRows(Data) > 1
If you are wanting to compare two specific records, it would be the "long way" I would think (each field equalling)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
I ended up doing nested if() statements. Same thing, but different. I was hoping for a full record compare method.
@martinav
Keep in mind the JSON function as well. It is handy for record to record comparison.
i.e. in general:
If(JSON(originalRecord) = JSON(otherRecord, //records are equal, //records are not equal )
I hope this is helpful for you.
Oh, now this is much more like it!! Good one, @RandyHayes
It's a good one, but it is only valid in behavioral actions since JSON only works in those actions.
It would be nice to use it for a property, but that is not an option. For that, you have to do it long hand.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
