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

Multiple choice update using flow in Dynamics 365

Dear Community,

 

I have created a flow, which is triggered by an update, where i create a new record in a different entity. Both entities have a common "choices" field where i want to translate the data from entity A to entity B. The choices fields are identical but when i create the new record with the dynamic content of the other entity, the choices aren't taken across.

 

Please can you help? I've seen that maybe i need to create and array before transfering the data but been unable to do this sucessfully.

 

Many thanks

9 REPLIES 9
Reimi
Community Support
Community Support

Could you please tell us how the output of choices look like?

drewcarousel
Frequent Visitor

@Reimi this is part of the issue i think. When i run a test, the field within CRM which i have created doesnt appear in the output body. I ran a "compose" task over the field (as it is available to select from the dynamic options) and the below appears:

drewcarousel_0-1608646302671.png

 

I am not applying any filters to the trigger other than the field which i wish it to be triggered from. Below shows that the field is able to be selected

drewcarousel_1-1608646423010.png

 

 

drewcarousel
Frequent Visitor

@Reimi one other thing to note is if i click to download, it takes me to the below webpage where nothing loads

 

https://prod-61.westeurope.logic.azure.com/workflows/7b1af91c78344fb29103d566586f6f9f/runs/085859296...

@Reimi one other thing to note is if i click to download, it takes me to the below webpage where nothing loads

 

https://prod-61.westeurope.logic.azure.com/workflows/7b1af91c78344fb29103d566586f6f9f/runs/085859296...

 

ManishJain
Solution Sage
Solution Sage

Hi @drewcarousel ,

 

If nothing is showing in the output when you click on the link it means that there is nothing coming in the input. Also can you please confirm if the choice field is yes / no or optionset.

 

Thanks

its an options set "Choices" field type under the new naming convention

ManishJain
Solution Sage
Solution Sage

Hi @drewcarousel ,

 

For updating optionset you would need the integer value and not label which you see on the UI , so if you have both optionset value same then you can update it with output of initial step. 

 

For eg. entity A has following optionsets:

 

Text             Value

XX                1

YY                 2

ZZ                 3

 

whereas if entity B optionset has following values :

 

Text              Value

 

XX        4

YY        5

ZZ        6

 

updating values from Entity A to B wont work in this scenario as the values behind the labels are not same. In this case you need to do mapping between entity A values and B  Values .

 

Thanks

Hi ManishJain,

 

The option set on both entities are identical, there is no difference on the value. Any other suggestions?

 

Best regards,

Drew

ManishJain
Solution Sage
Solution Sage

Hi @drewcarousel ,

 

Can you please do compose action after the trigger step and put the optionset value in compose to see if the value is retrieved .

 

Thanks

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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