Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Filter(myDataSource, ID=myConditionID).myColumn

Was this reply helpful? Yes No