I currently have an automation set up which is set to run whenever the status of a row change, and send out an email to a point person. It worked at first, but now I’m getting an error every time I try to run it and I’m unable to figure out why that is.
This is the error I get.
_DEREF expects parameter input to be either a row from an unknown table or a list of rows from an unknown table, but found value (’’), which is a text value
Has anyone ran into this error before and been successful in troubleshooting it?
Actually it looks like event with Concat changed to Concatenate I’m still getting this error
CONCATENATE("Hi ", thisRow.[Step 1 Result].[Textbank Point Person(s)].Name, ", this is just a friendly notification to let you know that the status of your ", thisRow.[Step 1 Result].[Textbank Name], " request has changed to ", thisRow.[Step 1 Result].Status, “.”), from: “SendDem Coda Bot”)
Try putting this formula directly into a new and see if that gives any more useful error information: CONCATENATE("Hi ", thisRow.[Step 1 Result].[Textbank Point Person(s)].Name, ", this is just a friendly notification to let you know that the status of your ", thisRow.[Step 1 Result].[Textbank Name], " request has changed to ", thisRow.[Step 1 Result].Status, “.”)