cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daved1
Helper II
Helper II

Lookup to a Choice field returns the code of the choice

I am trying to perform a lookup on a Choice field, and it seems to be working however, i am only get the Choice code back.  I want to display the actual choice text.  Here is my lookup

 

Collect(colTemp,

{

'AppItem Type': LookUp(SWAppItems, Name=ddAppItem.Selected.Name).ItemType

}

)

This returns 789310002 which i assume is the code of the Choice field.

How do I pull the text for this from the Choice ?

 

thanks

 

Dave

 

1 REPLY 1
Daved1
Helper II
Helper II

I did a bit more investigating - Here's what I found

 

If I create a record (recTest) with the onSelect of a Gallery, gives the following

- recTest.AppItem_LU.ItemType --  Gives the text expected from the Choice field "Approvals"

 

If I do a ForAll with a Collection, I get the code instead of the text

 

ForAll(galAppsToAdd.AllItems,
Collect(colExport,
{
'AppItem Type':ThisRecord.AppItem_LU.ItemType
}
)
);

 

This returns the Choice code and not the text ...

 

Dave

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (1,701)