Set Automatic Replies for different users

(0) Share

Report

Posted on by SK87

I have an excel file which contains below:

Email ids

Resource Name

Leave From (Start Date)

Leave To (End Date)

Out Of Office Message

and I want to set out of office for the mentioned email ids on the day that resource is on leave. I tried multiple things but couldn't get right results.

Kindly help me on this.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

SK87 41 on at

Like (0)

Report

I tried making a flow for one user that is the one who is the owner through below steps:
1. Recurrence (daily at 9 AM)
2. List rows present in a table

3. Apply to Each > Value and then Setup Automatic Replies

Automatic reply is being functional but the Reply message is not being updated based on dates, it is picking the 3rd record only.

Once This is solved then I need to setup Automatic reply for mentioned email-Ids in the excel not only for the owners.

Please suggest

@Nived_Nambiar @Ahammad_Riyaz @MichaelAnnis

Was this reply helpful? Yes No
Riyaz_riz11 3,860 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SK87
Can you please share the output of apply to each while running.
3 times it will be loop and check the first value what data it is passing.

Was this reply helpful? Yes No
SK87 41 on at

Like (0)

Report

@Ahammad_Riyaz
1st loop:
2nd loop:

3rd loop:
And in Outllook this is being set when I run this flow

Was this reply helpful? Yes No
SK87 41 on at

Like (0)

Report

@Ahammad_Riyaz
Any update on this?
@momlo @Nived_Nambiar @Pavel_NaNoi

Was this reply helpful? Yes No
SK87 41 on at

Like (0)

Report

@Ahammad_Riyaz any update, I am using PA.

Was this reply helpful? Yes No
SK87 41 on at

Like (0)

Report

I prepared the flow to set Automatic replies for different users and flow is running successfully - but when condition is actually true i.e. start date is equal to today's date then also it shows condition is false. below are snips of my flow:

After testing the flow, few snips

Kindly suggest, what needs to be corrected.

Was this reply helpful? Yes No