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

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (3,622)