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 typ... . 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!
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.