Announcements
Hi Everyone,
I have a column Case Status, Which is a choice column. Now i want to retrieve its data in gallary through a Label. Now , The formula i am using is ThisItem.'Case Status'.Value. But I am not getting its value. While writing this formula, I am getting an error. Could anybody please help me with this. Without Value, I can not change its color or anything.
Hi @CRAO
Try this
Switch( ThisItem.'Case Status' 'Status (<tableName>)'.Update, Color.Yellow, 'Status (<tableName>)'.New, Color.Beige )
If you have any questions or feedback, please let me know. Have a great day! 😊-----------------------PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
'Status (<tableName>)'.Update,
getting error in this line. What this Status is refering to ?
HI @CRAO, try this.
Switch( ThisItem.'Case Status', 'Case Status'.Updated, Color.Yellow, 'Case Status'.New, Color.Beige )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
View my blog James Yumnam
This Too is not working. I feel i am making some mistake in the datatype. I have choice type column in Dataverse. Can you please guide if i am going anywhere wrong in the process ?
@CRAO
What is the name of the Dataverse table?
Please change <tableName> with your table name.
Also check this blog How to work with Choice columns in Dataverse.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 408
timl 340 Super User 2026 Season 1
Vish WR 319
