Skip to main content

Notifications

Community site session details

Community site session details

Session Id : +90bykF1u5dlUryJ+0FwdS
Power Apps - Microsoft Dataverse
Answered

Option Set not Displaying on DropDown Box

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2018 19:27:10 by

Hi All,

 

I have created an Entity with a simple Option Set (Meeting_type) on the CDS, when I try to create a form in a Canvas App the dropdown list has no options.   Meeting Type also has Text field connected named "Meeting_Type Value" which I dont fully understand. 

 

Can anyone help me with this problem, I just want the 3 Options that I created in the Option Set to appear on my form.

 

Kind Regards

Jamie

 

Entity OptionSet.jpgOptionSetOnCanvas.jpg

Categories:
  • SristiJain Profile Picture
    13 on 03 May 2023 at 13:01:26
    Re: Option Set not Displaying on DropDown Box

    I did the same then why is my drop down field displaying blank values 😭

  • CU01081947-0 Profile Picture
    716 on 04 Aug 2020 at 18:17:18
    Re: Option Set not Displaying on DropDown Box

    Hello @Aphelion,

    Thanks so much for posting this. You will not believe the time I spent searching Google looking for this answer. I too added an input "Drop down" field, but instead of seeing just three values from my option set field, I was seeing ever option set value for all the records that had a value; so hundreds of duplicates.

    Then I stumbled onto your message and it solved the issue. I wrote Choices('My Entity'.MyOptionSetFieldName) and now my drop down field is showing just three option set values.

    Great stuff! What a palaver to display an option set field!

    Thanks so much,

    Garry 

  • Adnan Khan Profile Picture
    27 on 12 Dec 2019 at 05:05:51
    Re: Option Set not Displaying on DropDown Box

    Hi,  I am facing similar issue.

     

    I am developing Canvas app on CDS. I have option sets on entities, so when I create Edit Form in Canvas app, PowerAPPs automatically adds mandatory fields on the form. The option sets which are mandatory do not display the options in option sets. It displays a text field instead. But If that option set is not mandatory in CDS,  canvas app EDIT form displays all the values in drop down with no Issue. 

     

    So to confirm this,

    I changed a mandatory option set to Non Mandatory and created a new Edit form. This time on edit form the option set displayed all the options in drop down.

    Then  I changed back that option set to non mandatory and then created a new edit form, I faced the same issue.

     

    I tried this for both Edit and New form modes Behavior is same.

     

  • Aphelion Profile Picture
    9 on 04 Jun 2019 at 23:30:42
    Re: Option Set not Displaying on DropDown Box

    I figured out my issue below - simply wasn't using the Choices formula.   I will leave post below in case others have same issue.

     

    "I am finding that the DropDown for Option Sets doesn't display just a list of the option set values in the Option Set if the DropDown is not in a form. Instead the DropDown displays all values of the option set used in the items from the current entity which may be calling on the option set.  For instance, rather than displaying the 5 options I have in the option set, I get a list of all the values of the option set for all my accounts (ie hundreds of duplicates, not just 5 items to choose from).  I'd like to use a drop down to filter a gallery based on the option set, but given the above that's not feasible. Is there a way to do this?"  YES - Use  'Choices(Option Set)'

  • v-micsh-msft Profile Picture
    on 11 Jan 2019 at 01:40:12
    Re: Option Set not Displaying on DropDown Box

    Hi all,

    The Option Sets should work with Dropdown for now.

    Please take a check and let me know if there are any further issues on this.

     

    Regards,

    Michael

     

     

  • Abe Saldana Profile Picture
    75 on 10 Dec 2018 at 17:11:47
    Re: Option Set not Displaying on DropDown Box

    I understand that Optionsets are not working on Forms and we need to use them in different ways, the easiest way to use them could be the Forms and just use all the functionality, but this one is not working, I have created collections for the optionsets and then use them with the Combobox control. 

     

    I have a blog post that explains how to use them and how to save them using Patch functions. Here is the blog post and the video you can follow how I created my application

     

    Using the Dynamics 365 Connector

    https://abesaldana.com/canvas-using-optionsets-and-lookup-fields/ 

     

    Using the CDS Connector

    https://abesaldana.com/powerapps-canvas-using-lookups-with-cds/

     

    Hope this helps 

     

    abe

  • Verified answer
    v-xida-msft Profile Picture
    on 21 Nov 2018 at 01:50:34
    Re: Option Set not Displaying on DropDown Box

    Hi @Anonymous,

    Just an update -- The response from Filip Karadzic (A SENIOR PROGRAM MANAGER) as below:

    Drop downs don’t support Option Set data types from CDS.  We are currently working on enabling the Combo box to handle Option Sets, and full support should be coming out soon.

     


    Currently, the Option Set type column are not supported within Drop downs, the product team is working on enabling the Combo Box to handle Option Set type column.

    You could also consider take a try with the alternative solution I provided above, then check if the issue is solved.

     

    Best regards,

    Kris

  • Community Power Platform Member Profile Picture
    on 20 Nov 2018 at 07:48:58
    Re: Option Set not Displaying on DropDown Box

    Hi Kris,

     

    Many Thanks for taking the time to re-create my problem, I will have a go at setting up my drop down menu's when i return home this evening.


    I will feed back to you once this is done.

     

    Thanks Again

    Jamie

  • v-xida-msft Profile Picture
    on 20 Nov 2018 at 07:43:02
    Re: Option Set not Displaying on DropDown Box

    Hi @Anonymous,

    I have made a test, and the issue is confirmed on my side. When I generate an app based on a CDS entity, the following error would show up:

    Invalid argument type (Text). Expecting a Table value instead.

    7.JPG

    It seems that PowerApps does not recognize the data source name (on my side, it is TaskLists) as a data source table, instead, recognize it as a Text value.

    I would post this issue to my product team, if the issue is solved, I would reply here.

    Currently, as an alternative solution, please modify the formula within the AllowedValues property of the Data card in the Edit form to following:

    DataSourceInfo([@TaskLists], DataSourceInfo.AllowedValues, "_crd1f_meeting_type_label")

    On your side, you should type following:

    DataSourceInfo([@YourCDSEntity], DataSourceInfo.AllowedValues, "_cr615_meeting_type_label")

    Note: YourCDSEntity represents your CDS Entity name, the _cr615_meeting_type_label represents the column in your CDS entity.

    After that, the Meeting_Type Dropdown box works well as below:Test1.gif

     

     

    Best regards,

    Kris

  • Community Power Platform Member Profile Picture
    on 16 Nov 2018 at 09:59:44
    Re: Option Set not Displaying on DropDown Box

    I've the same issue. Just created a post under general discussion:

     

    https://powerusers.microsoft.com/t5/General-Discussion/Dropdown-menu-not-showing-items/m-p/180782#M59683

     

     

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard

Featured topics