cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bubbler
Frequent Visitor

CDS Optionset failed to load with Choices

I´m using Powerapps Canvas mode with CDS connection

There is one OptionSet that is present and valid in the CDS model that powerapps can't load, attached you can see the screenshots.

I´m currently using many optionsets within the same model but only this one cant be loaded. The error is "Se produjo un error al cargar las opciones" (there was an error loading options)

1 ACCEPTED SOLUTION

Accepted Solutions
Bubbler
Frequent Visitor

Re: CDS Optionset failed to load with Choices

Hi @v-siky-msft 

 

JFTR

  • Could you try to modify your formula to Choices(EntityName.OptionSetColmnName), and check if your issue is fixed?

I did this change but the issue was not fixed.

 

  • If not, try to delete your Option set ,even Entity Field, then re-create it and apply to your PowerApps to check if issue is fixed.

First we tried this on Dynamics365 sandbox and then apply the solution as an update to my environment. It did not fix the issue.

Finally we delete the field and the option set and re-create them with different internal names directly in the destination environment.  This time the issue was fixed.

 

Thanks for the help.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: CDS Optionset failed to load with Choices

Hi @Bubbler ,

 

I have made some test, regardless of global or local option set, I don’t have the issue you mentioned, they all can be loaded successfully. It seems not to be easy to reproduce your issues.

 

Could you try to modify your formula to Choices(EntityName.OptionSetColmnName), and check if your issue is fixed?

If not, try to delete your Option set ,even Entity Field, then re-create it and apply to your PowerApps to check if issue is fixed.

Annotation 2019-09-09 142816.png

 

Best regards,

Sik

Bubbler
Frequent Visitor

Re: CDS Optionset failed to load with Choices

Hi @v-siky-msft 

 

JFTR

  • Could you try to modify your formula to Choices(EntityName.OptionSetColmnName), and check if your issue is fixed?

I did this change but the issue was not fixed.

 

  • If not, try to delete your Option set ,even Entity Field, then re-create it and apply to your PowerApps to check if issue is fixed.

First we tried this on Dynamics365 sandbox and then apply the solution as an update to my environment. It did not fix the issue.

Finally we delete the field and the option set and re-create them with different internal names directly in the destination environment.  This time the issue was fixed.

 

Thanks for the help.

View solution in original post

Microsoft
Microsoft

Re: CDS Optionset failed to load with Choices

Hi All,

This is not a valid solution.

I am experiencing this bug after having things work as expected for months without issue.  I understand recreating it could be difficult because there is no error message generated.  Here is the behavior:

  1. Create a solution in an environment (e.g. DEV) that includes:
    1. a custom entity: Foo with local optionset field: Foo Type
    2. a canvas app with CDS-sourced Choices in a ComboBox control using "Items = Choices(Foos.'Foo Type')"
    3. Validate combobox shows optionset values
  2. Deploy the solution to TEST, open the canvas app and see that the combobox has no values.

What I have seen is opening the canvas app in TEST seems to resolve something and it will load in authoring

Please fix.

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (5,428)