Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Common Data Service Option Set Value to Text



I am currently working on a Canvas powerapps application that utlizes the Common Data Service with a  custom entity "Customer".  For this entity, I have a field, "City", which is an option-set with 3 choices (Pittsburgh, Columbus, DC).  I have an edit form attached to this entity that adds records to this entity.  It allows the user to pick a city from the dropdown. The form submits successfully.  I have another screen which is supposed to show the information regarding to the customers they have enetered, but it doesn't show city properly.  It just says [objecct Object]. 


How can I access the city that the user entered? It currently gets stored as a "complex" field type, but I think I would prefer it to be a String (if possible).   


Summarized: I want the city to be chosen from a dropdown and stored in the Customer entity in a usuable format.


Let me know if you need me to clarify anything!






Community Support
Community Support

Hi @mattcole19 ,


Can you please explain more about the part "show the information regarding to the customers they have enetered, but it doesn't show city properly"? Are there 2 entities involved in this app? Did you create a relationship between city and customers entity? 




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,465)