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
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
User | Count |
---|---|
20 | |
11 | |
9 | |
5 | |
5 |
User | Count |
---|---|
32 | |
32 | |
18 | |
18 | |
7 |