News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Automatisation project

Microsoft Dynamics CRM forum

Suggested answer

Automatisation project

(1) Share

Report

Report

Posted on by FM-02051120-0

18

Hello,

We currently have linked opportunities in our system, and I would like to know if it is possible to automate the process of updating their statuses. Specifically, when one opportunity changes from one status to another (e.g., from /Identify/ to /Qualify/), I would like the other linked opportunity to automatically follow the same status change.

Could you please inform me of the available options to achieve this automation? Is it possible?

Thank you in advance.

Categories:

Development / Customization / SDK

All responses Img

All responses (2)

Answers Img

Answers (0)

FM-02051120-0 18 on at

Like (0)

Report

Automatisation project

Hello,

Yes, that's exactly what I'm trying to do. After several attempts, I still can't manage to get it right. I'm stuck at the first step because I can't access the Opportunity Sales Process table, even though I know it exists.

Thanks,
Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report

Automatisation project

Hi，

It's possible to be achieved!

Based on your description and screenshot, the opportunity and itself have 1:N relationship, Right?

You mentioned process status: from /Identify/ to /Qualify/

--In fact, this should be a stage change on BPF(Business process flow), as well as BPF itself being a table.

If so, you can use power automate to update bpf stage of related opportunities based on the change of parent opportunity.

My example：

1.Trigger

--When stage change on this BPF

2)Get opportunity related to the changed BPF

3)Retrieve related partner opportunities related to this opportunity.

--Format： _lookuplogicname_value

4)Get BPF of these partner opportunity

5)Update BPF stage of these related partner opportunities:

--Populate active stage with value from trigger

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Helpful resources

News and Announcements

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,753 Super User

#2

Martin Dráb 225,302 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans