Email error. Can't find column that's there

[Simon1]

I'm trying to set up an automated email.

I get an error saying a column doesn't exist when it does.

This happens when I try it like this and in a template.

Am I missing something very obvious?

[MultiTech]

No that's a weird one.... "Name" is kinda a reserved word in a lot of instances - perhaps if you changed the name to something other than just that single word, that might do the trick?

[Simon1]

Glad it wasn't me missing something obvious.

I've changed it to Staff and then tried Staff name but the same error is still there.

I changed the column type from Name to Text and it still has the error.

I also tried a different column which is Email Address and that is also an error.

[MultiTech]

Yeah that's a weird one... I'd reach out to support about this one.

Contact us - AppSheet

[Simon1]

thanks will do

[Simon1 · Accepted solution]

I changed the table I was using and the way I was trying to get the data into the email, so forgot to switch ForEachRowInTable on.

So it didn't know where to get the data.