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

All responses (3)

Answers (1)

Gowri Halan 262 on at

Like (0)

Report

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

wshalex123 160 on at

Like (0)

Report

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)

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 5,229 Super User 2025 Season 1 on at

Like (0)

Report

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.