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:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (0)

Suggested answer

SL-11020816-0 23 on at

Like (0)

Report
Compare two collections and return values

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.
Suggested answer

MichaelFP 1,827 Super User 2025 Season 1 on at

Like (0)

Report
Compare two collections and return values

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.