cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MattyH
Level: Powered On

Returning multiple data values.

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!


Accepted Solutions
Community Support Team Rank
Community Support Team

Re: Returning multiple data values.

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


All Replies
Microsoft Employee

Re: Returning multiple data values.

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

 

Community Support Team Rank
Community Support Team

Re: Returning multiple data values.

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