Map MultiOption Set Field using Power Automate from one entity to another

(2) Share

Report

Posted on by lawix10

334

Hi I have a requirement to Map MultiOptionSet from one Entity Case to a child entity Web Application using power automate.

I ensured the option set are exactly the same , I have mapped in Power Automate but its returning null.

Both Entitles have the Same field called Areas .

the area field is a multi option set field .

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Community Member on at

Like (2)

Report

Hi Adeyemi,

Maybe you can add one 'Get a row by ID' step before 'Add a new row '.

(1)Get a row by ID

(2) Add a new row

The areas should be filled with value from 'Get a row by ID' step.

Test Result:

Also, i have used global option set to the MultiOption Set Field-Areas.

Global option sets are useful when you have a standard set of categories that can apply to more than one entity. Maintaining two separate option sets with the same values is difficult and if they are not synchronized you can see errors, especially if you are mapping entity fields in a one-to-many entity relationship.

Go to Settings > Customizations > Customize the System > Option Sets to create New.

Then expand Entities to find Case entity and Web Application, click Fields to create new.

In the field editor, select Yes for Use Existing Option Set.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
lawix10 334 on at

Like (0)

Report

Thanks the Get row ID solved the Issue ..I always use get row ID if am trying to get records from other entity than the one the power automate trigger is working on.

I didn't have to use global option set thou but I understand its best practice. But the field has already been created.

But just adding that row ID works thanks, trying to mark this has the verified answer but not seeing the option yet.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Don’t worry!

You have already marked this has the verified answer!

Regards,

Leah Ju

Was this reply helpful? Yes No
Anwar Noori 3 on at

Like (0)

Report

Thank you for answer !!

Can we set from JSON response using expression ?

Please let me know

Regards,

Anwar

Was this reply helpful? Yes No