cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

All Formula in the Canvas app Threw Errors after the latest CDS Update

Hi - Last week I received a notification when trying to edit a canvas app in PowerApps. The error was regarding updating/upgrading the CDS as the dataset behind my app to make sure it continues to function after July 2020. As part of the upgrading process I was asked to remove and add the data source back. Since then all the formula throws error pointing out syntax errors that were previously working perfectly fine as well as the fact that none of the records are now displayed in the gallery.

 

Has anyone come across the same issue?

 

Thanks,
Shiva

6 REPLIES 6
chsanche
Community Support
Community Support

Hi @Anonymous 

 

Can you please try deleting the last character in the formula and re-adding that one again? We have seen this scenario in the past that after we update the data source by removing the last character the issue gets resolved.

 

Best Regards,

-- 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution
Anonymous
Not applicable

Hi @chsanche,

 

Thanks for your response, unfortunately this didn't resolve the issue. What's odd is that the formula are showing errors that were not existing before. For instance, in multiple places I had formula in which a specific choice from an option set was used in a text evaluation as a filter, and it was working just fine, but now it says incompatible data type and none of the solutions online in using value, etc. worked.

 

Are there any other steps I can take?

 

Thanks.

Hi @Anonymous 

Could you post some examples of the errors that you are getting please?

Anonymous
Not applicable

Hi @Drrickryp,

 

This is an example of a formula that was functional before:

Capture.PNG

Account is an entity, DiversityProgram is a column (option set with two choices) in that entity. The error makes sense as far as compatibility of data type but it wasn't an issue before updating the CDS connector.

 

I tried different syntax with text, value, etc., as well as [@DiversityProgram].WM instead of "WM" but it didn't work.

 

Thanks.

Hi @Anonymous 

Here is an article related to Option sets and syntax. It has a better explanation than I can give you and I hope it helps. https://michalguzowski.pl/how-to-work-with-option-set-in-powerapps/  

Anonymous
Not applicable

Thanks @Drrickryp , I came across this article but unfortunately it didn't resolve the issue. 

 

What I'm trying to do is to use the choice from an option set as a filter in a formula (e.g. to count the records in a gallery that meet a certain criteria, or to only show records in the gallery that have a specific value in a column (the column being of option set type), etc.). Do you have a suggestion on how I can make this work now that my previous formula is no longer working?

 

Thanks.

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,870)