cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bneuf
Level: Power Up

Comparing values between two different entities in Dynamics 365 CRM

I want to create a Flow that will update the Account field of a "Lead" in Dynamics 365 CRM based on a look-up of one value in the "Lead" entity and match it with a value in the "Account" entity.

 

Within an "Account" record I have a value that is the email domain of the account. For example "microsoft.com".

 

In my "Leads" records, I parse out the lead's email address, using Flow, and return the email domain value. For example "microsoft.com".

 

Now, I want to use the "Lead" domain to lookup an "Account" record where the domain in the "Account" matches the "Lead" domain. When a match is found, I want to update the "Lead" account field with the associated "Account".

 

screenshot.png

 

 

 

 

1 REPLY 1
Highlighted
RookieI
Level: Powered On

Re: Comparing values between two different entities in Dynamics 365 CRM

What is the problem with your current Flow?

 

You can use List records-Filter Query to filter out the matching records.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,605)