Returning multiple data values.

[MattyH]

I currently have a field in a Powerapp where most responses would be a single piece of data, so a Lookup function works fine. However, there are a very few where the response would be more than one piece of data.

As the Lookup function only returns the first piece of fitting data, is there a better option to return all values that fit the criteria.

Formula syntax  would be most appreciated!

[dinusc]

Hello @MattyH,

You should be able to use "Filter" to return multiple records based on the provided ctriteria. Example:

Filter(YourSource, Field = "searchCriteria")

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

[v-xida-msft · Accepted solution]

Hi @MattyH，

Could you please share a bit more about about the single piece of data that you mentioned?

I agree with @dinusc's thought almost. I think the Filter function could achieve your needs.

Please take a try with the following formula:

Filter(YourDataSource, 'Filter Condition')

e.g.

Filter(DataSource, ColumnName="xxxxx")

More details about the Filter function, please check the following article:

Filter function

Best regards,

Kris