Power Platform Community Forum Thread Details

I have 5 Galleries, varRole, varFunding, varErisa, varStateMandate, & Result.

I would like to display all matching IDs in the Result Gallery.

If one of the var Galleries is equal to NA, I don't want the match rule to apply.

I've displayed my galleries as lists for visual context with the desired 'Result':

Thank you for any help you can provide

Categories:

Building Power Apps

Hello @kgiles123 ,

I tried something on my side to reach the solution you're looking for. Here is my formula:

With(
 {
 _list: Distinct(
 Split(
 Concatenate(
 Concat(
 cltScreenTable_1;
 Value;
 ";"
 );
 ";";
 Concat(
 cltScreenTable_2;
 Value;
 ";"
 );
 ";";
 Concat(
 cltScreenTable_3;
 Value;
 ";"
 );
 ";";
 Concat(
 cltScreenTable_4;
 Value;
 ";"
 )
 );
 ";"
 );
 Value
 )
 };
 Filter(
 ForAll(
 _list;
 If(
 ThisRecord.Value in Distinct(
 cltScreenTable_1;
 Value
 ) && ThisRecord.Value in Distinct(
 cltScreenTable_2;
 Value
 ) && ThisRecord.Value in Distinct(
 cltScreenTable_3;
 Value
 ) && ThisRecord.Value in Distinct(
 cltScreenTable_4;
 Value
 );
 {Value: ThisRecord.Value}
 )
 );
 Not(IsBlank(Value));
 IsBlank(TextInput.Text) || Value <> TextInput.Text
 )
)

"With()" constructs a list of all distinct values from all collections.

"ForAll()" returns all values who match all collections.

"Filter()" removes blank values and values matching the Textinput.

You can replace the collection's name with your tables and the Textinput with "NA" and it should work fine.

Don't hesitate to ask if you have any questions.