Unanswered

Option Set not Displaying on DropDown Box

(0) Share

Report

Posted on by Community Power Pla...

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.jpg

Categories:

Microsoft Dataverse with Power Apps

Entity OptionSet.jpg

OptionSetOnCanvas...

I have the same question (0)

All responses (10)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-xida-msft on at

Like (1)

Report
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.

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:

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
Abe Saldana 75 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-micsh-msft on at

Like (0)

Report

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

OptionSets.gif

Was this reply helpful? Yes No
Aphelion 9 on at

Like (1)

Report

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)'

Was this reply helpful? Yes No
Adnan Khan 27 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like (1)

Report

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

Was this reply helpful? Yes No
SristiJain 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No