How to build a scenario which identify a specific upcoming meeting and send an email to participants (microsoft calendar & outlook)?

Dear all,

I am a make newby and I struggle to implement a scenario that I guess should be pretty simple.

I am looking to create a scenario whose trigger is:
search microsoft calendar for an event called “HR committee” that happen at Day+2

If no: abort

If yes : send an email to participants asking them for the topics they want to put on the agenda

Obstacles that I face are the following:

  • the trigger identify all meetings with this specific name and not only the upcoming one at Day + 2
  • the email i want to send does not include the carriage returns and thus is written on only 1 line

Could you pleas help me lift these hurdles ?
I thank you very much for the attention you piad to my use case

Hi @guitton

Welcome to Make and have fun!

Can you show your scenario and the bundles you receive as input and output? Ideally, if you provide your scenario and blueprint it might help also.

The filter for the date might be incorrect, which is why you get all the meetings.

For the emails, you might have to send the information in HTML as in this example:

Source: Create message - Microsoft Graph v1.0 | Microsoft Learn

L

Thank you very much for your message!
You will find below the screenshots of:

  • the search for events form
  • the email to be sent form

Are these elements answer your questions for further details ?

Merci!

Can you also show the input/output bundles (the content of the (1) at the top right of the modules)? Ideally, if you can share the full content that would be best. But if there is private information in them, you may need to edit it out.

I notice you use “Created Date Time”. Is that the correct field? To me it means “the date the event was put in the calendar” not “the day the meeting is scheduled” but I could be wrong. I’m also curious to see why it returns all of them. The results will (hopefully) show the “created date” and help identify where the error is.

For the email writing module, use HTML tags to break up you lines. So something like this:

Bonjour,<br/><br>

Nous tenons ensemble un CRH…<br/><br>

Auriez-vous des points…

<p>Merci!</p>

I don’t have a Microsoft Mail setup ready so I can’t test directly, but based on the API documentation page and how other email systems work, I think it should do the trick.

L

Thank you very much again for your support. I was able to find the input/output bundles and also modify the formatting of the email thanks to your advise.

You will find attached to this reply the screenshot that may help. I have saved the updated scenario and it does not send email anymore… It does not identify meeting with the specified name.

I agree with you “Created Date Time” does not seem the correct field because like you it seems to me that it means “the date the event was put in the calendar” not “the day the meeting is scheduled”. However the drill-down list only propose “subject” / “Event ID” / “Created date time” / “last modified date time” / “Body preview” . Thus I cannot find some criteria that matches my need it seems.

Best regards,
Guillaume


Salut encore!

Can you open the filter completely? Or copy and paste the bundle input?

Out of curiosity, when you made your first snapshots, did you create the events in the calendar on that day? If so, it might explain why they all showed up and why they are no longer appearing today.

I will try to see if I can set up a Microsoft account to test this, unless someone else knows what’s happening.

L

Hi,

Here is the microsoft calendar input bundle :slight_smile: [
{
“limit”: 1,
“filter”: [
[
{
“a”: “subject”,
“b”: “Comité RH”,
“o”: “contains”
},
{
“a”: “CreatedDateTime”,
“b”: “2024-07-25T17:22:35.542Z”,
“o”: “eq”
}
]
],
“orderby”: “subject asc”,
“calendar”: “AAMkAGFhMGU0OWY2LWIwMmQtNDc1Yi04ZjJkLTRlZmYxMzdkZmYzYwBGAAAAAADqVJD40RswRqRdtFMVqFkzBwAf45oQFRyOT4pn0GORuTicAAAAAAEGAAAf45oQFRyOT4pn0GORuTicAAADeHU8AAA=”,
“calendarGroup”: “AAMkAGFhMGU0OWY2LWIwMmQtNDc1Yi04ZjJkLTRlZmYxMzdkZmYzYwBGAAAAAADqVJD40RswRqRdtFMVqFkzBwAf45oQFRyOT4pn0GORuTicAAAAAAEGAAAf45oQFRyOT4pn0GORuTicAAADeHU7AAA=”
}
]

The output bundle is:
[
{
IMTLENGTH”: 0
}
]

I thank you very much for your support. It is fine if we do not succeed. I am not sure if this topic is really worth your time.

Bonne journée,
Guillaume

The Make support team has just responded to me:

Just to clarify Created Date Time and Last Modified Date Time refers to when the event was created or modified and not when the event is due to start.

Therefore I recommend removing that part of the filter completely. I’m afraid it is not possible to limit the search by the event start date with the Microsoft 365 Calendar - Search Events module. In other words, this module will list all the events that meet the filter parameters regardless of the event start/end date.

As a workaround, you can filter just by the subject and increase the limit according to your needs:

So essentially every time you run the scenario this module would list ALL the events with that subject. And then you could set up a filter between the modules to pass through only the ones that are due to start in two days

2 Likes

Yeah, I kind of suspected that. So it looks like you will have to open each calendar event to see the content and see if the date of the event is within the next two days (or whatever your filter is). That could be costly in terms of operations if you have a lot of events.

If you decide to continue, let us know.

Bon succès!

L