To display a list of users with birthdays or anniversaries that occur this month, you can use the Office365Users connector and the Filter function to filter the list based on the Birthday or HireDate property.
Here's an example formula that filters the list of users based on their birthday:
Filter(Office365Users.SearchUser({searchTerm: ""}), Month(Birthday) = Month(Today()) And Day(Birthday) >= Day(Today()) )
This formula uses the SearchUser function to retrieve a list of users, and then uses the Filter function to only include users whose Birthday falls within the current month. The Month and Day functions are used to extract the month and day from the Birthday property and compare it to the current date.
You can modify this formula to filter the list based on the HireDate property for anniversaries, like this:
Filter(Office365Users.SearchUser({searchTerm: ""}), Month(HireDate) = Month(Today()) And Day(HireDate) >= Day(Today()) )
This formula works the same way as the previous one, but filters based on the HireDate property instead of the Birthday property.
