Next Birthday/Jubilee

[wshalex123]

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

[rampprakash]

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.

[wshalex123 · Accepted solution]

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

[gowrihalan04]

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