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

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

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 

1 ACCEPTED SOLUTION

Accepted Solutions
iotc
Level: Powered On

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

Filter(myDataSource, ID=myConditionID).myColumn

View solution in original post

3 REPLIES 3
Microsoft Employee

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

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

Highlighted
AnthonRiber
Level: Powered On

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

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
Level: Powered On

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

Filter(myDataSource, ID=myConditionID).myColumn

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 191 members 5,502 guests
Please welcome our newest community members: