Announcements
I have seen a number of related posts on this subject incl ThisItem.Status = This formula uses scope, which is not presently supported for evaluation. Data type: text . However, in my case I simply want to display a simple Varchar(128) field so not a complex at all.
Interestingly when I first insert the gallery and connect to my SQL Datasource the Checkpoint title is displayed. I resize and add my pretty status indicator then, the Checkpoint field value goes awol 🙄- it has done this twice now. I can replace ThisItem.Checkpoint with a variety of swear words and they all appear!
Hi,
What have you set in the Items field of the Gallery?
Hi
Thanks for replying
Yes, for this initial prototype, it is the simply the database table. Now it is finding the record as I see the active status transitions when it displays the screen in the Power Apps editor.
Quick update: this morning a couple of us have been changing the db schema to see what the impact is . Looks like Checkpoint is a reserved word in SQL i.e. [Checkpoint]. When we created a similarly named field with the same size there are no probs displaying the data.
We also tried ThisItem.Table , which was defined with and without the '[]' and there were no issues.
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 476
WarrenBelz 365 Most Valuable Professional
Vish WR 339
