Power Platform Community Forum Thread Details

Power Automate desktop

Here is my flow

I have clarify my Flow and requirements

1. I have Excel file, in excel file new joiners Employees Joining date and Employees Email Id present row by row.

2. I have outlook emails from last three months.
I got this emails from posh@india.com.
I have total 8 POSH emails in my outlook
1st POSH email start from 28th August 2024
2nd POSH email - 4th September 2024
3rd - 11 September 2024
4th - 18 September 2024
5th - 25 september 2024

I want to send POSH emails to new joiner employees but condition is if
POSH email date < employee joining
If True => send POSH email to employee email id

For example
Your Date of joining is
12 September 2024.
So before 12 September whatever POSH emails i have in my inbox I want to send it to you.

I'm able to send emails successfully to employee. But emails are going on one go. And it should be looks like Spam in employee outlook.

My flow is

1. Launch Outlook
2. Retrieve email messages from Outlook
3. Launch Excel
4. Read Excel File
5. For each (Excel file)
For each (Retrieved Emails messages)
If(POSH email date< employee joining date)
Send an email message through outlook
END
END
END

It's looks nested loop, so every time I'm checking all POSH email with employee date of joining.
Then I'm picking 2nd employee date of joining and checking with all POSH emails and so on.

I want here emails are gone to be later some time. I'm fine with any one below time

1. Per 2hr. Email should go
2. per One day
3. Per 4hr. Is also fine

Could you assist here, if any thing clarifications, let me know. I'm strictly using only power automate desktop

Categories:

Power Automate Desktop