Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Work Anniversary Emails to Employees

(0) ShareShare
ReportReport
Posted on by 1,085

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.

 

RameshMukka_0-1636354095304.png

 

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Work Anniversary Emails to Employees

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

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Work Anniversary Emails to Employees

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

  • Paulie78 Profile Picture
    Paulie78 8,407 on at
    Re: Work Anniversary Emails to Employees

    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 😘

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Work Anniversary Emails to Employees

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard