I have a gallery where I am displaying items from a SharePoint list. In one of the text controls inside the gallery, I want it to display the text "Estimated return date: " and the date field from the SharePoint item. In the Text property of the control, I'm using this code:
"Estimated return date: "&ThisItem.'Date Planned Return'
For all items except the item at the top of the gallery, this is displaying correctly (for example, "Estimated return date: 4/29/2024"). The first item only has "Estimated return date: " with no dynamic field content. I checked the SharePoint list to make sure that there was a date in that column, and the data is not missing.
I tested the gallery by just having the field read the date:
ThisItem.'Date Planned Return'
And the date shows up properly in all items.
Is this a known glitch? Is there some sort of fix?
Hi Fhamm! 2. Possible troubleshooting steps:
1. Try removing the text control in the gallery and then create a new control WITH just the date (ThisItem.'Date Planned Return'). The control itself may be the issue.
2. If you get no errors, then add in the text portion ("Estimated return date: " & )
Let me know if that works for you.
I realized it was a problem with the formatting--the issue is actually with the selected item, not the top item. When the field is bolded, it hides the date field. I just needed to resize the controls in the gallery.
WarrenBelz
146,601
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional