Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

How to get Dynamics 365 records and filter records with empty Project Number fields. Create HTML table and Email

I'm trying to create a scheduled flow that will run every 2 weeks.

This flow will pull a list of Project Records from Dynamics 365 and filter the list to only contain records that

meet the following conditions met

   1. Status = Active  (FYI - the actual Field label is Status BUT the field name is statecode with an option value of 0 - Active or 1 - Inactive)

   2. Project Number Field is empty


If both those conditions are met, a HTML Table is created and then emailed to a user containing the Project Name, Date Created and link to the Project form in CRM for that particular record.

Currently the flow runs successfully but I do not receive any email. I'm pretty sure the issue lies somewhere in the middle of the flow.

Help me out fam!


Image of current flow:


Zoomed In Image of Current Flow:



CRM Project Number Field:




Accepted Solutions

@PowerBack19I actually figured it out. See image of flow below and the image of the result.


Scheduled Notification Flow.PNGCapture4.PNG

View solution in original post


@MattP13 - What account are you using for the "Send an Email (v2)" step? Is it a service account, your account, or some other account? If it's a different account, do you have permissions in Exchange to send emails on behalf of that account?

@PowerBack19I actually figured it out. See image of flow below and the image of the result.


Scheduled Notification Flow.PNGCapture4.PNG

One last thing, I would suggest you start using the Common Data Service connectors. The Dynamics 365 connectors are deprecated.

Thanks for the feedback, I will start doing so!

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,860)