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".
Hi Stevenfayers,
I'm sorry if I misunderstood, what doesn't save the configuration in the action?
Regards,
Javier
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.