Upcomming Birthdays

(0) Share

Report

Posted on by KGillespie

I would like to create a gallery which shows employees whose birthdays will occur in the next 60 days. The data source is a SharePoint list named MainTable and the column is named DOB. Any assistance is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@KGillespie

My assumption is you want to display this information in a gallery. Put this code in the Items property of your gallery to show only employees with Upcoming birthdays.

Filter(MainTable,DateDiff(ThisItem.DOB,Today(),Days)<=60)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No