Power Apps - Building Power Apps

Find items of a collection inside other collection

(1) Share

Report

Posted on by EmilioRoqueta69

495

Hi All,

I have 2 collections:

colRFQSupplier

colRFQPO

And I need a result collection colRFQSupplierNotUsed (It means the values the values in collection colRFQSupplier that do not exist in collection colRFQPO)

You can check with these sample values:

 
ClearCollect(colRFQSupplier, {RFQNumber: "RFQ100"},{RFQNumber: "RFQ102"},{RFQNumber: "RFQ103"},{RFQNumber: "RFQ104"},{RFQNumber: "RFQ105"},{RFQNumber: "RFQ106"} ,{RFQNumber: "RFQ107"} );
ClearCollect(colRFQPO, {RFQNumber: "RFQ101"},{RFQNumber: "RFQ104"});
ClearCollect(colRFQSupplierNotUsed,
    Filter(
        colRFQSupplier,
        IsBlank(
            LookUp(
                colRFQPO,
                RFQNumber = ThisRecord.RFQNumber
            )
        )
    )
);
 
The result is an empty values.
 
Thanks for any help!

Categories:

Using Apps Using Formulas

All responses (4)

Answers (0)

CA1105 469 on at

Like (0)

Report

Find items of a collection inside other collection

+1 point to @WarrenBelz sir answer.
WarrenBelz 147,547 Most Valuable Professional on at

Like (2)

Report
Find items of a collection inside other collection

Hi @EmilioRoqueta69,

Also this should work
ClearCollect( colRFQSupplierNotUsed, Filter( colRFQSupplier, !(RFQNumber in colRFQPO.RFQNumber) ) );

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee
ronaldwalcott 3,810 on at

Like (1)

Report

Find items of a collection inside other collection

Here is a weird approach which should lay the groundwork for performing unions and intersections.

ClearCollect(

colRFQSupplier,

{RFQNumber: "RFQ100"},

{RFQNumber: "RFQ102"},

{RFQNumber: "RFQ103"},

{RFQNumber: "RFQ104"},

{RFQNumber: "RFQ105"},

{RFQNumber: "RFQ106"},

{RFQNumber: "RFQ107"}

);

ClearCollect(

colRFQPO,

{RFQNumber: "RFQ101"},

{RFQNumber: "RFQ104"},

{RFQNumber: "RFQ103"}

);

ClearCollect(

colCombined,

AddColumns(

colRFQSupplier,

CollectionColumn,

1

),

AddColumns(

colRFQPO,

CollectionColumn,

2

)

);

ClearCollect(

colRFQSupplierNotUsed1,

Filter(

GroupBy(

colCombined,

RFQNumber,

GroupData

),

CountRows(GroupData) = 1

)

);

ClearCollect(

colRFQSupplierNotUsed2,

ShowColumns(

Filter(

colRFQSupplierNotUsed1,

First(GroupData).CollectionColumn = 1

),

RFQNumber

)

);
Suggested answer

Rajkumar_M 3,685 Super User 2025 Season 1 on at

Like (1)

Report

Find items of a collection inside other collection

Hi @EmilioRoqueta69

Instead of IsBlank(LookUp(...)), use !IsBlank(...) properly, or better yet, use ! (not) and LookUp to check if no match exists.

ClearCollect(
colRFQSupplierNotUsed,
Filter(
colRFQSupplier,
IsEmpty(
Filter(
colRFQPO,
RFQNumber = ThisRecord.RFQNumber
)
)
)
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.