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?