Answered

Scheduled Flow (Outlook 365) Notification of Events

Like (0) Share

Report

Posted on 5 Dec 2023 23:10:54 by Nucho

The Flow I’m working on is a Scheduled Flow that would run every Monday. It’s pulling info from an Outlook calendar that has our Workshops on it and ss sending out an email with all of the classes for that week to the instructors who are scheduled to teach them (they’re added on the calendar invite as a Required Attendee).
I got everything working so far, but the problem I’m having is that it is sending the email for every single class they teach that week. So, if they’re a required attendee for 3 classes, it’s sending the same email to them 3 times.

How can I generate a single notification email to be sent to each person listed on the calendar during this reoccurrence trigger every Monday? Only one email that would have the information of each event they are listed under as a 'required attendee' in Outlook.

Thank you in advance for your help!

Juan M.

C3.PNG

C1.PNG

2.PNG

All responses (6)

Answers (2)

Verified answer

Nucho 16 on 06 Dec 2023 at 21:15:20

Like (0)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events

@v-xiaochen-msft
With your help I have been able to find a solution. I had to modify your design but, in the end, it works! Thank you so much for your help!

Here is what I came up with with your help:
v-xiaochen-msft on 06 Dec 2023 at 07:28:53

Like (0)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events

Hi @Nucho ,

There are 2 'Current item' in dynamic content list and you are using a wrong one.

Please try to use

items('For_each_1')

rather than

items('Apply_to_each')

Best Regards,

Wearsky
Nucho 16 on 06 Dec 2023 at 07:12:41

Like (0)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events
v-xiaochen-msft on 06 Dec 2023 at 06:39:08

Like (0)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events

Hi @Nucho ,

Please share the flow screenshot.

Best Regards,

Wearsky
Nucho 16 on 06 Dec 2023 at 06:12:00

Like (0)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events

@v-xiaochen-msft
This is very helpful, Thank you. Now I am encountering issues with arrangement.

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Filter_array_2' at line '1 and column '1891' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Filter_array_2' to be referenced by 'repeatItems' or 'items' functions.'.'.

I think once I can configure these correctly, I may be able to complete this flow. Any suggestions?

Thank you!
Verified answer

v-xiaochen-msft on 06 Dec 2023 at 01:44:35

Like (1)

Report

Re: Scheduled Flow (Outlook 365) Notification of Events

Hi @Nucho ,

Please try this

split(variables('var'),';')

item()

union(body('Filter_array'),body('Filter_array'))

items('Apply_to_each_2')

body('Filter_array_2')

item()?['subject']

items('Apply_to_each_2')

body('Create_HTML_table')

Best Regards,

Wearsky