Set the value of some columns in this row - invalid error

[Mike_T]

I might be missing some setting somewhere, can someone point me in the right direction? Here is the setup.

My table has a list of dates (datetime type) in the [Sail Date]. I’m using a slice to show only rows where the [Booked By] column is blank. I’ve set up an action to set the value in this column to USEREMAIL() when this row is selected in a table view. I’m also using a generic confirm message.

I’m getting Invalid Sail Date

[LeventK]

Do you have any expressions in any property of [Sail Date] column?

[Mike_T]

Yes. I have this:
Sort(SELECT(Allure Schedule[Sail Date], [Booked By]=""))

in the Valid If of the Sail Date column.

I’m thinking, I should probably use a slice instead? no?

[Mike_T · Accepted solution]

HA! I think i forgot i had this Valid If expression in there and later added a Slice that did the same thing. I removed the Valid If Exp and it worked like a charm!

You guys are awesome at this Appsheet stuff! Great teachers can teach by asking one question!

Thank you!

[LeventK]

You’re welcome