Answered

Send reminder message to manager everyday when on leave

(0) Share

Report

Posted on by Qilafara

Hi everyone. I really need help. I create one attendance forms. Every morning people need to fill up forms and submit attendance. Then I can view from microsoft list too. Let say if I key in that I was on leave for 3 days, how can I power automate send the email for 3 days to manager? If I on leave for 5 days, then 5 days manager will get message that I on leave. Please really need help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Qilafara,

I think this is a data set issue, you need to add two columns represently for StartDate and EndDate, and then create another recurrence flow to trigger everday and check if there is anyone on leave today.

Recurrence, triggers everydaye

Get Items,

Condition, if today is between StartDate and EndDate.

formatDateTime(utcNow(),'yyyy-MM-dd')

Note that select the StartDate and EndDate from the dynamic content of Get Items action, and put them represently on the left pane of the condition, write the above expression on the right pane of the condition.

Using the Or to combine two conditions.

If yes, send an email to manager

Was this reply helpful? Yes No
Qilafara 3 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you so much . But I do have another question. for now I really don’t know how can I trace who not submit attendant. I have microsoft forms where I put drop down all the members name in question no 1( Your Name). And after submit it will store in sharepoint list ( Name) . How can I do flow check their name in power automate ? Do I need to retrieve all drop down name from microsoft forms compare to all the members who already have submit forms in sharepoint list?Thank you 👍🏻

Was this reply helpful? Yes No