Need help regarding sending an email reminder via flow

(0) Share

Report

Posted on by santoscp_mwci

I have 2 SP list namely EmpList and OvertimeRequest,

EmpList has the following fields: employee_name, level1approver, level2approver, level3approver).

OvertimeRequest has the following fields: emp_name, level1approvstat,level2approvstat,level3approvstat

What I want to happen is to send a daily email to approvers who have pending items in the OvertimeRequest SP list. The flow that I want to happen in power automate is:

Flow checks for items in OvertimeRequest who has "Pending" as status in either level1approvstat, level2approvstat, level3approvstat -> Flow then retrieves the current approver based on level from EmpList through the common id employee_name and emp_name (in a way cflow checks emplist on who is the current approver for a specific employee based on level) ->flow then sends an email to appropriate approver

Apologies if this is too basic, but I can't seem to make it work. Thanks in advance for the help.

All responses (2)

Answers (1)

santoscp_mwci 35 on at

Like (0)

Report

Re: Need help regarding sending an email reminder via flow

Will try this out and get back to you as soon as it works 🙂
Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report

Re: Need help regarding sending an email reminder via flow

Hi @santoscp_mwci

In my understanding, you want to send an email to the first approver whose status is pending for a specific employee. After, you also want the flow to send daily email notification to the approver until approvstat is approved.
If I’ve misunderstood your need, please feel free to let me know.

The following flow is for your reference:
The step ‘Get items’ is for the list ‘OvertimeRequest’.
The step ‘Get items 2’ is for the list ‘Emplist’.
The condition is used to check whether the value for the column ‘level1approvstat’ is equal to pending.

The detailed steps for ‘Get items 2’:
Filter query is used to filter out the item whose value of the column ‘employee_name’ is equal to the current item’s value of the column ‘emp_name’.

The detailed step for ‘Apply to each 2’:
For the step ‘send an email’: ‘To’ requires an email address. (In my example, value in the column ‘level1approver’ is the approver’s email address.)

The detailed step for ‘Do until’:

The same structure of ‘condition’ applies to level2approvstat and level3approvstat.
For example, for ‘level2approvstat’, please use ‘condition2’ in ‘If no’ in ‘condition’(the structure of ‘condition 2’ is same as ‘condition’):

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.