cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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: Powered On

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.