cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bubbler
Helper I
Helper I

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

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
v-siky-msft
Community Support
Community Support

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

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

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,339)