web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : HeKNe97Bv+CfaKo4ER7O0Z
Power Apps - Microsoft Dataverse
Answered

Next Birthday/Jubilee

Like (0) ShareShare
ReportReport
Posted on 28 Nov 2022 11:04:27 by 160

Hey there,

 

In my app, you can create a new employee, create his login data and add him to groups automatically. The Data is being saved in a Microsoft Dataverse "employee" table, where all employees are listed. 

Also the birthday and the date of employment are being saved there.

 

My next step ist to generate the next birthday date of every employee and his next jubilee year date. 

Does it make sense to calculate it with a new column in the Dataverse? If yes, how is it working?  Or do you suggest another solution?

If one of the dates = today, it should trigger a flow and post a message in a ms teams chat. 

 

Would be happy if someone can help me out 🙂

 

Cheers, Alex

 

Categories:
  • Gowri Halan Profile Picture
    262 on 28 Nov 2022 at 14:36:46
    Re: Next Birthday/Jubilee

    @wshalex123 In your list record step. either add Name field afteradding a comma or keep it blank, You will get all the attributes.

     

    gowrihalan04_0-1669646200003.png

     

  • Verified answer
    wshalex123 Profile Picture
    160 on 28 Nov 2022 at 14:13:28
    Re: Next Birthday/Jubilee

    Hey @rampprakash,

     

    iam already working on a solution like that. I once made a similar approach with an excel action. Here, i don't get the other column dynamic elements (Iam filtering the Date of Birth and want to get the name in the same row)

     

    wshalex123_1-1669644731581.png

     

    Do you maybe know why? I also was thinking about a solution in a seperate app in power apps, since there also is a MS Teams connector...

     

     

     

     

  • Ram Prakash Profile Picture
    5,309 Super User 2025 Season 2 on 28 Nov 2022 at 14:06:27
    Re: Next Birthday/Jubilee

    Hi @wshalex123 

     

    One suggestion from my end,

     

    Create a field and populate next year birthday date in that.

     

    Then trigger a schedule flow on daily basis then check today = table field date then post a message.

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete