Notifications
Announcements
No record found.
Hi,
I am investigating creating a workflow to automatically update a field on the most recent opportunity based on a field value in the Contact.
The problem I have is that a lot of our Contacts would have multiple open opportunities. How can I create a workflow that will only update the most recent opportunity?
Thanks
Ted
Hello Ted,
The issue with workflow - you can't do it easilly.
You will have to either create a custom logic - either plugin or custom workflow activity or use Power Automate - that could be performed in a no-code manner.
Use list rows action in power automate to fetch recent updated opportunity.
docs.microsoft.com/.../list-rows
You can order by modified on and pick first record.
Create a Custom Action and call that custom Action from Microsoft flow or
Create a Console Application that calls CRM System --> use Fetchxml or Queryexpression to take only last modified record(modified on desecending) for each contact's Opportunity and perform your operation
Please mark as Answer if it is helpful and provide Kudos
Subscribe : www.youtube.com/.../UCnGNN3hdlKBOr6PXotskNLA
Blog : microsoftcrmtechie.blogspot.com
Hello,
If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 61
Gerardo RenterÃa Ga... 52 Most Valuable Professional
