Showing results for 
Search instead for 
Did you mean: 
Advocate IV
Advocate IV

Custom values for option sets in CDS connection not always saved correctly

When using "Create a record" in CDS / Dataverse, and populating multiple option set columns with custom values, the value/formula is not always stored. Changing one column formula for an option set custom value may wipe out another option set custom value.


I end up having to save, exit, reopen the flow and "Peek code". 


Community Support
Community Support

Hi Stevenfayers,

I'm sorry if I misunderstood, what doesn't save the configuration in the action?



Advocate IV
Advocate IV

Hi Javier


Take the following example from CDS Create a record:



You can see there are 2 option set fields I am populating with a custom value (i.e. from a variable or formula).

I recently had to change the formula for the "Type" field. When I saved it, the formula for "Type" was saved, but the formula for "Snapshot type" was wiped out. Going back in, I filled in "Snapshot type" again and upon saving the formula for "Type" was wiped out.

I had to change both formulae at the same time, check that it has been updated with "Peek code", and then save to get it to work. 

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Top Solution Authors
Users online (1,783)