Master Filtering Email Addresses from M365 Calendar Meetings with Make.com
Have you ever found yourself in a situation where you need to filter email addresses from M365 Calendar Meetings and get the row # from Excel that matches any of the attendees? Well, you're not alone. This is a common challenge that many Make.com users face. But don't worry, we've got a solution for you.
Problem
The main issue here is finding a way to use an operator in the Condition to try and match all the possible emails within the Collection. For instance - 1. Attendees[ ALL ]: Email Address.Address. The number of Attendees will not be the same for every meeting. In this example, there are 6 attendees and it should only return 1 Row # as only 1 of the 6 email addresses are in the Excel Spreadsheet.
Solution
The solution to this problem is to use the map function. Here's a step-by-step guide on how to do it:
- Use the map function to extract the email address from the attendees’ fields.
- Then use Array Contains Filter to check it against the email that you are getting from Workbook rows.
- The map function should look something like this: {{map(1.attendees; “emailAddress.address”)}}
Here's a screenshot for reference:
Screenshot from 2023-07-14 22-16-21
Troubleshooting Tips
If you're still having trouble matching the email, make sure that the filter is set up correctly and that the email you're trying to match is the same as the one in the Excel Spreadsheet.
Conclusion
In conclusion, filtering email addresses from M365 Calendar Meetings and getting the row # from Excel that matches any of the attendees can be a bit tricky, but with the right tools and steps, it's definitely doable. Remember to use the map function and the Array Contains Filter to check the emails against the ones in the Workbook rows. Happy automating!
You do have further questions?
Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.
