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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 296 Most Valuable Professional
11manish 224
Valantis 181
