Customer experience | Sales, Customer Insights,...

Flow for Dynamics CRM

(0) Share

Report

Posted on by KristenDME

Hello,

I'm trying to make a flow or even a process to update a record when another is updated in Dynamics.

For example I have a Case that s connected to an equipment. I have an option set field in the case that I have an N:1 Relationship to the same option set in equipment. When someone updates the option set in the Case I want it to also update the option set in the equipment.

I'm not sure where to start, in the process they dont have a start for when a record is updated, only created. When I go into flow I used when a record is updated, update a record. The flow succeeds but when I look at the equipment its not updated. Any thoughts only a good flow to use for Dynamics 365 CRM?

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Yoshika Suzuki on at

Like (0)

Report

Can it be achieved with a Dynamics workflow?

docs.microsoft.com/.../configure-workflow-steps

You can select the workflow start condition when the record is created or updated.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

Could you share some screenshot of what you tried till now so that we can help you to fix your issue?

So I created below optionset in both Employee and Building Entity and Employee has N:1 relationship with Building.

Make sure you have created optionset with same value in both entities.

Now I created flow with below trigger and actions -

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
KristenDME 35 on at

Like (0)

Report

I tried a regular process, but it needs to be when the record is updated. I tried using when the Fields I want changed, but all it did was create a new record not update the current record.

Was this reply helpful? Yes No
KristenDME 35 on at

Like (0)

Report

I tried building with Dataverse however the table for what I want to use isnt listed, which is our Cases.

I think our main problem, is the it need to be able to connect our cases that is updated with the same field to an unrelated entity which is the equipment to the matching field from cases.

.

The flow I originally used a while back for something similar doesnt work. I removed our name.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

The reason why Case entity is not listed is that you are not in correct enviornment.

Try to change the enviornment as highlighted below to select correct instance -

Your previous flow is not working because in Record Identifier you have selected Serial Number but instead you will have to select Equipment Record GUID.

Check my previous post where I used List rows to fetch child records then apply each to process each records.

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
KristenDME 35 on at

Like (0)

Report
Got it.

For the filter row for list row, Im getting a bad request when I input this and run a test. I know you had more language on yours but Im assuming its for that employee value. Not sure if it be the same for mine?

Also I have never used Concatoncat for expression how do I know what strings to put for that in there or do I not need any?

Sorry for the million questions Im super new to flow as I used process before.

Was this reply helpful? Yes No
empath-e CRM 1,136 on at

Like (0)

Report

The bad request error is because within the Filter rows you haven't specified the column for your filter, you have just added the field value.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

What is the Case lookup field schema name on Equipment Entity?

I created new case lookup on Equipment entity new_case so filter row I have mentioned _new_case_value

You will need to change your filter rows as below -

_caselookupfieldschemaname_value eq Select Case from Dynmic content

You don't need concate for your requirement. Please ignore which I posted earlier, it was a sample flow.

You need to only map optionset field in Equipment Entity from Dynmic content from Case optionset.

Hope this helps!

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
KristenDME 35 on at

Like (0)

Report

The case isnt a lookup field and I think thats why its not working.

There can be multiple cases connected to one equipment, so its not a field but a data source for a list.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Can you please share screenshot of the relationship used between Case and Equipment entity to help you better?

Is Equipment custom entity created by you or you are using OOB Facility/Equipment Entity?

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No