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 / Compare Two Collections
Power Apps
Unanswered

Compare Two Collections

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

murali1680_0-1658415524392.png


can anyone help on this thing...

Categories:
I have the same question (0)
  • WiZey Profile Picture
    3,023 Moderator on at

    Could you elaborate on your need/issue?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Step1. If, Project is Rejected by Admin  I am storing those vales in RejectedCollection(Collection1) and as a user I will modify the Data and try to resubmit again to Admin Review.


    Step2. Now, this time Admin Approved my Project. again for Approved Projects I am storing in ApprovedCollection(Collection2)


    Step3. I want Compare 2 Collections and If I found the same record exist in 2 Collections  then remove the matched record(Entire Row) from RejectedCollection(Collection1)


    Step4.  Finally, I want to return Existing Rows Count after Matched record removed from RejectedCollection(Collection1)

  • WiZey Profile Picture
    3,023 Moderator on at

    Thank you, I have a clearer picture now.

     

    I believe you already figured how to setup Step1 and Step2, so I'll jump to the next one.

     

    For Step3, you'll need "RemoveIf()" to remove a record based on a condition. Something like:

     

     

    RemoveIf(Collection1; ID in Collection2.ID)

     

     

    For Step4, you can use "CountRows()" to get the number of rows in your collection. The function will automatically re-calculate the result in real-time, meaning you only have to put the code inside a label for display.

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 Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard