Using LookUp Value but displaying multiple results rather then only first value?

[cdebloi]

Maybe a gallery is the better way to do this but currently I am trying to use a simple text label but display the results of a lookup function (the name of a person) with multiple criteria. I have a sharepoint list as my datasource (Notes), and i want to lookup and display the names in a text label that meet two criteria. The criteria are:

1) A number value in another column is equal to a specific value I am defining (DataCardValue3)

2) The value in a "on hold" column is set to true (This is a toggle in my power app so its a true/false flag in my Notes source)

I.e a name would be displayed if the other two conditions are met. I have it working with the formula:

LookUp(Notes,Value(DataCardValue3.Text)='Number' And 'On Hold?'=true).Engineer.DisplayName

However, it only displays the first value it comes across where the criteria matches. In my case, it is possible that there are maximum 2 distinct names that are outputted that meet the criteria. How would I get it to display both names that meet the criteria in the cases that there are 2 names?

[etroy333]

Personally I think yes, you would be better with a gallery or maybe a data table to show the multiple values.  

Otherwise, maybe you can create a collection from the selection? I know this is a bit messy as I don't really know how your data sits for the Number value.

ClearCollect(colNames,LookUp(Notes,Value(DataCardValue3.Text)='Number' And 'On Hold?'=true),DisplayName:Engineer.DisplayName})

If you can get the list in there, you might be able to set your text label to a variable (Text = varName) and this formula Set(varName,Mid(Concat(colName,"; " & DisplayName),3,500)).

I did something similar but it was with multi select combo box data.

[cdebloi]

Do you have a recommendation on doing this inside of a gallery? I was struggling at a similar point in a gallery where it was only showing the first value but multiple times rather then the distinct values. 

[etroy333 · Accepted solution]

With a gallery it would be a Filter rather than a lookup.  

If you only want something displayed only if there is a number value then this should work:

Filter(Notes,'On Hold?'=true ,DataCard3.Text = 'Number')

If you want something displayed if there is a number value or just everything on hold this should work:

Filter(Notes,'On Hold?'=true ,IsBlank(DataCard3.Text) || DataCard3.Text = 'Number')

[cdebloi]

That worked, thank you!

[etroy333]

Glad to help.