Next Birthday/Jubilee

(0) Share

Report

Posted on by wshalex123

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

wshalex123 160 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

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

Was this reply helpful? Yes No
Gowri Halan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No