Unanswered

Work Anniversary Emails to Employees

(0) Share

Report

Posted on by rameshmukka

1,115

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

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

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

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 😘

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@Hardesh15 Get group members doesnt give hiredate property. Otherwise I would have gone with filter array.

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

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

Was this reply helpful? Yes No