web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Compare Two Collections

Power Apps

Unanswered

Compare Two Collections

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

can anyone help on this thing...

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you elaborate on your need/issue?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation