web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Compare two collection...

Power Apps

Suggested Answer

Compare two collections and return values

(1) Share

Report

Report

Posted on by xFelipeDuartee

I have two collections in Power Apps: ValoresDropDown and ValoresGalleryText.

I need to compare ValoresGalleryText with ValoresDropDown, where ValoresDropDown is the base and ValoresGalleryText is the current one. I need it to perform this comparison and return the values that are missing in relation to the base collection (ValoresDropDown).

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

MichaelFP 1,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello!

You can do it a for all for that.

Clear(MissingItems); ForAll(ValoresDropDown as VD, If(IsBlank(Lookup(ValoresGalleryText,Value = VD.Value)),Collect(MissingItems,VD.Value)) );

You will iterate all of the ValoresDropDown Values and try to find these values im ValoresGalleryText, If the Lookup() is blank means that the current value is missing in ValoresGalleryText, and you include in a new collection to have the list of missing values.

Was this reply helpful? Yes No
Suggested answer

SL-11020816-0 23 on at

Like (0)

Report
Copy link

Link copied!
I find this:

https://www.matthewdevaney.com/powerapps-collections-cookbook/find-matching-values-within-two-collections/

By refining the code to display only the items that differ between the two collections, we arrive at the following:

ClearCollect( col_MissingValue; ShowColumns( Filter( AddColumns( ValoresDropDown ; MatchFound; !IsBlank( LookUp( ValoresGalleryText; Value = ValoresDropDown[@Value] ) ) ); MatchFound = false ); Value ) );;

I hope this has been helpful or provided some guidance. Best regards.

Was this reply helpful? Yes No

Join the conversation