433
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,
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?"
Hi,
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
Hi,
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,339
Super User 2024 Season 2
#2
Martin Dráb
228,177
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (