Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Automating Marketing Lists

We have been experimenting with a concept for a new flow and would welcome some advice. Our firm runs Office 365 E3, Dynamics 365 Sales, and have made use of certain Azure resources (Ex. Azure SQL Databases). Our firm has many software power users, but most development work is done externally. Accordingly, we prefer low development or no development solutions to our objective, which is to automate the addition of new contacts to our marketing list, based on who contacts us and who we contact.


The high level requirements for this objectives have been defined as follows:


1) Identify all email addresses that send emails to users in our domain.

2) Identify all email addresses that receive emails from users in our domain.

3) If an email address exists in 1) and 2), then add the email address to our Dynamics 365 Marketing List.


If anyone has thoughts, we would be greatly appreciative.

Community Support
Community Support

Hi @petrosk,


Where do you place all the email addresses? I mean you need something like a contact list stored in a database, such as Azure SQL database. Then you could get all the email addresses from the contact list, using a condition to check if the coming email address exists in the contact list or not. If yes, add the email address to the Dynamics 365 Marketing list.


Please take a try with it on your side and feel free reply if you need more help.



Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion
Community Champion

Hello,  @petrosk!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,416)