PowerApps - Is there really no Lookup function that a one column list

[AnthonRiber]

Hi there!

I have a list with several column.

I want a function that does the same as teh LookUp function but instead of returning one value only, i want it to return a list of values that fulfills the condition, from a given column of the source.

Hope there is someone who know a workaround or better yet know a function that does just that.

Cheers

- Anthon 

[dinusc]

Hello @AnthonRiber,

I believe "Filter" is the function you're looking for. It has a similar format as "LookUp". Please see this page: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

[AnthonRiber]

Thank you for the reply.

But this is not what i am looking for. 

Filter does not have an option to only return data from one column of a list. Which LookUp does.

- Anthon

[iotc · Accepted solution]

Filter(myDataSource, ID=myConditionID).myColumn