Unanswered

Compare two collections and return values

(1) Share

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 (2)

Answers (0)

Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report
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
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