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

How to lookup for value that is stored in choice type of column

Hi all,

 

I have a question related to LookUp formula. I am trying to get value from choice type column called "Business" in list called "People". My formula looks like this:

 

LookUp(People,Text(User().FullName)=FullNameMid,Business)

 

This condition works alright "Text(User().FullName)=FullNameMid"

My problem si retrieving value from column "Business". Note that this colum doesn't have multiple values choosen.

 

Is there a way how to retreive this value and store it as text?

 

Thank you

Lukas

1 ACCEPTED SOLUTION

Accepted Solutions
TimRohr
Level 10

Re: How to lookup for value that is stored in choice type of column

If "Business" is a Lookup field, like you say, then you need to include the ".Value" on the end of it:

 

LookUp(People,Text(User().FullName)=FullNameMid,Business.Value)

4 REPLIES 4
emh
Level 8

Re: How to lookup for value that is stored in choice type of column

Hello,

 

Here is how I have done exactly what you want to do. I set the result of the LookUp to a global variable. In your case:

 

Set(globalBusiness, LookUp(People,Text(User().FullName)=FullNameMid,Business))

 

Hope this helps.

lamacz
Level: Powered On

Re: How to lookup for value that is stored in choice type of column

Hi,

 

Thank you for your advice, unfortunatelly I am not looking for solution that would need to perform an action to set a variable.  I have a form that is populating field business automaticaly based on a user that is filling the form.

 

Lukas

TimRohr
Level 10

Re: How to lookup for value that is stored in choice type of column

If "Business" is a Lookup field, like you say, then you need to include the ".Value" on the end of it:

 

LookUp(People,Text(User().FullName)=FullNameMid,Business.Value)

lamacz
Level: Powered On

Re: How to lookup for value that is stored in choice type of column

Thank you, that did the job.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 54 members 4,581 guests
Please welcome our newest community members: