Announcements
I have a number of dataverse tables with child/parent relationships. I want to use a rgb value from a choice column to colour each gallery item by its RAG status. My problem is I can't figure out how to retrieve the rgb value.
ThisItem.'RAG-Status'.'Rag-Status'
The function gets me the Label but how do i retrieve the value element from within a powerApp?
Hi,
You have to use the Value to retrieve the information from choice field as shown below:
ThisItem.'RAG-Status'.Value
There isn't a .Value listed in autocomplete and the formula reports incorrect use of "." Maybe the structure of my data wasn't as clear as necessary.
ThisItem Table
RAG Status Table (source of lookup)
* this is the choice column I wish to retrieve the Value (rgb values) it is configured to sync with global choice (StatusColour), schema name cr8d1_RagStatus, logical name cr8d1_ragstatus
ThisItem.'RAG-Status'.'Rag-Status' returns the labelHow do I get the Value of a choice?
ThisItem.'RAG-Status'.'Rag-Status' returns the label - can you give the screen shot, what label it is giving?
Hi @mobcdi ,
If you are looking to fetch/get a value from a choice field, please use the below formula:
ChoiceField.Selected.Value => it gives the value of the selected item. (make sure to update the ChoiceField with your choice field name)
Sorry for the delay in responding.
The value of ThisItem.'RAG-Status'.'Rag-Status' returns a string made up of numbers and letters in blocks, after a bit of digging i can see that the Rag-status isn't the column i actually need as its the GUID for the row.
I am still having trouble getting to the colour value from a choice column. I now know the column name is Status Choice but if I use ThisItem.'RAG-Status'.'Status Choice' I get one of the labels below but I need to get the Value which contains the RGB value as can be seen in the image below.
In the formula bar I don't have the option of ThisItem.'RAG-Status'.'Status Choice'.Value as the formula error says "Value" isn't recognised and there are no suggestions presented by code complete
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
