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
Solved! Go to Solution.
As per our screen sharing session the issue was while adding attributes to the Select Columns
And Although there was real output when the on the Click to download when using the values later in the flow they were null
Resolution: Removing all fields from Select Columns
@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
You could do like this:
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
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.
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 🙂
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!
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.
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.
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.
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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.