Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

dinusc Microsoft Employee on at

Like (2)

Report

Hello @Anonymous,
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

iotc 43 on at

Like (1)

Report

Filter(myDataSource, ID=myConditionID).myColumn

Was this reply helpful? Yes No