I have already created Work Anniversary Emails to Employees and its working fine. However, I feel the flow is not efficient. As I do not have a filter query or OData filter option to get users having anniversary on that day, I have to go with condition to check for each user profile. This is eating up so many API calls. I am here to check from experts if there is an efficient way of doing it like graph API to get all users in json format and use Parse JSON and filter out the users. Please suggest if any.
@Paulie78 I would like to get users directly from M365 or Azure. I dont have any filter options in the action to apply while I get them so I was thinking if at all possible to get them using any API?
@Hardesh15 Get group members doesnt give hiredate property. Otherwise I would have gone with filter array.
This video I made might be useful for you:
How to send Automatic Birthday / Anniversary Email using a Power Automate Cloud Flow
It's done in the most efficient way possible (that I am aware of).
Blog: tachytelic.net
YouTube: https://www.youtube.com/c/PaulieM/videos
If I answered your question, please accept it as a solution 😘
@RameshMukka if you are checking dates in loop then Use one more filter array and filter your data based on date.
Please share compose and condition expression.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.