Answered

Scheduled Flow (Outlook 365) Notification of Events

(0) Share

Report

Posted on 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.

Categories:

Building flows

C3.PNG

C1.PNG

2.PNG

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
Nucho 16 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Nucho ,

Please share the flow screenshot.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Nucho 16 on at

Like (0)

Report

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Nucho 16 on at

Like (0)

Report

@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:

Was this reply helpful? Yes No