Power Automate flow to send email connect d365 sales

[Indhu]

Hi,

I have never used power automate earlier, Requirement is I need to send email notification to Owner's of the record if the due date is Overdue. How can I achieve this in Power Automate. Like recurring every morning, this flow should run and check for the records which is overdue and send email notification. I googled everwhere but couldnt find the exact way

What I need to select from here? Help

[Mira_Ghaly]

@Indhu 

What is the connector or your data source?

[Indhu]

@Mira_Ghaly  I use dataverse. When I try to set recurring flow, I don’t know what to choose in the next step. I need to open the entity and look for field value and based on that I need to send email

yo user 

[Khaledta]

Hi,

You could do like this:

1-Trigger

2- Dataverse connector - get list (your table)

3- If condition -  check status

4- if true, dataverse connector - get row where id eq "userID" previous step (user table) 

5- Outlook connector, send email to "Useremail" from previous step 

[Mira_Ghaly]

@Indhu

Is overdue a boolean or a date time, either way you need to use List Rows on the Dataverse connector and add an OData filter to get the records that are overdue or alternatively can use fetchxml and then add an apply to each loop and send out your email.

[Indhu]

Over due field is two option set- Overdue/No. I created this as a calculation field, depending on the check it sets overdue or not. 

I have connected to Dataverse-> action(List Row) -> given table name -> then what i should do????

should i do "advanced find" in dynamics for finding the overdue field and fetch XML from that and paste it here in fetch XML Query?

This is my first power automate, so 🙂

[Mira_Ghaly]

@Indhu 

1. Go to your Model driven App

2. On the Top Right bar you will find the advanced find icon

3. Click on it will open advanced find window select you table and add your conditions

4. Then Click on Download FetchXML

Then you can use it in your List Rows.

Hope this helps!

[Indhu]

Thanks @Mira_Ghaly Mira, I have added my fetch XML in the fetch XML Query field under List Rows. Then I selected send mail notification and added owner (Type, Value). I think that gives owner's email id. cz Owner is the field which holds the owner email id.

[Mira_Ghaly]

@Indhu

You need to get the user email address so you need to get Get row by id and choose the table users and pass to it the owner value then from the output of the Get row by id you can use the email in the to.

[Indhu]

can you tell me how to relate to User table and get the related email id from that table

[Mira_Ghaly]

@Indhu 

Yes please check below:

Hope this helps!

[Indhu]

@Mira_Ghaly 

Can you tell me the error? 

User is the table I need to relate with Enquiry table. 

Owner is the Unique identifier of the user or team who owns the activity Enquiry.

[Mira_Ghaly]

@Indhu 

As the error suggests the passed User ID is empty, can you share a screen of the flow itself?

[Indhu]

Yes When i see the data its empty.

This is how Owner from Enquiry is related to User table like

Only Owner has got values in Enquiry. 

[Mira_Ghaly]

@Indhu 

Can you make sure the List Rows fetch has the owner Column to the list of attributes?

[Indhu]

Ownerid is the name of the owner not the GUID.

[Mira_Ghaly]

@Indhu 

That's look right

Can you show me from the flow run history ... for the output of the List Rows?

[Indhu]

[Mira_Ghaly]

@Indhu 

Sorry show me the Get Row by ID in flow editor?

[Indhu]

This is what i see inPower BI