web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get contacts based on ...
Power Automate
Answered

Get contacts based on the email on the lead CDS

(0) ShareShare
ReportReport
Posted on by 46

Hello

I am just starting to dip my toe properly into flow, and have a question I cant seem to get right.

What I want to do, is when a I create a lead in the CDS then get a list of all contacts where the email address 1 is the same as the email on the lead.  

This is where I am up to.

Capture.PNG

 

I have tried it as well with emailaddress1_value eq Email

The only way I can get it to work is if I hard code the filter emailaddress1 eq 'xxxx@hotmail.com'  but I need it to be dynamic so it works for all email

Thanks in advance

 
Categories:
I have the same question (0)
  • Verified answer
    Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @Mr_Mather 

    Hi there.  It might need single quotes around the dynamic value in the filter.  Give the below a try and let us know if that works:

     

    20191211a.PNG

     

    Keep us posted.

    -Ed-

     

    If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard