Notifications
Announcements
do you show the birthday also in the gallery or outside in a text label?
for the visible property you could do something like this:
Text(Today(), "MM-dd") = Text([YourDataSource].Birthday, "MM-dd")
In this formula, replace [YourDataSource] with your actual data source name and adjust any field names as necessary.
Let me know if my answer helped solving your issue.If it did please accept as solution and give it a thumbs up so we can help others in the community.Greetings
Correct, in the gallery.
try this for the gallery:
Text(Today(), "MM-dd") = Text(ThisItem.Birthday, "MM-dd")
you just nee to change the Birthday column to the on you have
Error Message: Incorrect format specifier for 'Text'. Remember, I need to add "Yes" if they wants to visible.
try this instead
DateDiff( DateValue(Text(Today(), "MM-dd-yyyy")), DateValue(Text(ThisItem.Birthday, "MM-dd") & "-" & Text(Today(), "yyyy")), TimeUnit.Days ) = 0
what do you mean with the yes part?
Still error.. Error message: "Incorrect format specifier for 'Text'."
maybe the issue was that i forgot that one is a datefield in sharepoint.
can u try this please:
Yeah! Birthday is a datefield. Still error, why! I using "default" is a property, and items put it in 'DHS All User'.
I found it and fixed; correct is Filter('DHS All Users', Birthday = Today())
@dylandavis09 I created this example. This shows the user birthday and then a trimmed version of it. The same for Today's date. Then I have an icon and a message that appear if the dates match and the user chose "Yes" on whether to show the message. For my example, I used a collection as my datasource, but you can easily adjust it for your datasource and columns.
To trim the birthday:
Text(DateValue(userBirthday.Text),"mm/dd")
To trim today's date:
Text(Today(),"mm/dd")
The code in the visible property of the birthday message:
If(userBdayTrimmed.Text = todaysDateTrimmed.Text && showBirthday.Text = "Yes",true,false)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
