Help with updating Text Labels with Person and Date/Time

[jbrines]

Hi Guys,

Below is an App edit page

When I click on Yellow Card Sent I want it to put the current user of the app display name as well as update the field in the SharePoint List

When I click on the Yellow Reason I want it to put in the current date and time as well as updating the field in the SharePoint List.

Currently in the OnChange of the button field of Yellow Card Sent I have

UpdateContext({var2:User()})

And on the Update of the Yellow Issued By I have tried below, but it doesn't like it as it is expecting a record value

var2.FullName

Currently for Yellow Reason OnChange I have

UpdateContext({var:Now()})

On the Yellow Issued Date card I have 

var

The issue with the date and display name part is that when I click on + to create a new item the date and display name are put in instead of waiting for me to make my changes.

John.

[RandyHayes]

@jbrines 

So, if your underlying column is a Choice column (single choice, not checkmark choice) then the formula for the Update should work fine.

So, first look at your list definition of that column and verify the above, and if it still is an issue, then I would consider removing that field from the form and then adding it back in.

Again, depending on the timing of the column change and when you made the form, it might still think it is a boolean yes/no column.  Removing the field in the form and adding it back will clear that up.

[jbrines]

@RandyHayes 

Added it again and now get this.

[RandyHayes]

@jbrines 

You have two errors in that screen shot.  

The one you showed the formula for though is because you removed the datacard and added it back in.  So, your original DataCardValue11 is most likely no longer there and you need to change that name to the new toggle that you have.

Did you put a toggle in your datacard as you had before?  If so, then again, just reference that in your above formula.

[jbrines]

@RandyHayes The Data Card name is the same. No I Made it a dropdown.

[RandyHayes · Accepted solution]

@jbrines 

argg...you keep changing control types and field types on me!!! 🤣🤣🤣😂

If you're going to use a dropdown, then it is a whole lot different than a toggle.

First off, I would assume that your datacard (when you added it), because the underlying column is now a Choice column, it showed up as a datacard with a dropdown in it already.  So, there is NOTHING that you have to change for the datacard for that control/column.

For your other formula, you need to make that a formula for a dropdown, so, replace DataCardValue11.Value with DataCardValue11.Selected.Value = "Yes"

[jbrines]

@RandyHayes sorry for messing you around 😀 but the dropdown came in when I removed and added it.

That's it working, many thanks yet again you are a top guy

John.