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
I did the same then why is my drop down field displaying blank values 😭
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
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.
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)'
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
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
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
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
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
I've the same issue. Just created a post under general discussion:
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional