Column not Found When Using Filter Condition

[googlenoob62]

I'm new to App Sheets and trying to recreate some automations that we had setup in Microsoft Power Automate but running into some issues (I'll for sure be posting more until I get the hang of Google Automate)

The main automation that we are trying to re-create is a weekly email for each row from a database based on specific criteria that that should send an email template to a external customer from a shared mailbox. The first issue that we have run into is around the 'Filter Condition' for when the scheduled event occurs. We are using [Region] = 'NA'  in the Filter Condition and the expression assistant verifies that it is valid but, when you go to test the bot it shows an error that it can't find the [Region] column. Same issue occurs if you try adding in a filter for the processes.

[WillowMobileSys]

Since the error message has "=[Region]", which is NOT how your Event condition is implemented, then the error must be complaining about some other area where that column is being used.  AND since is says the column is not found, the expression seems to be used in a Table context that is NOT of the table that actually contains the column [Region].

You are likely getting RED error flags and messages in the editor?  Click on the "red x" in upper left hand and then see the list of errors and then tap on "Go to problem" for each one to resolve them.  The Editor should take you directly to the place where the error is occurring.

[googlenoob62]

There are no RED flags appearing. In the Expression Assistant for the Filter Condition it shows green and when you go to 'Save &Verify Data' it comes back as green.

When you go to TEST that is when it is showing the error (See updated image as I didn't save it before which is why it didn't have the NA). Also, if you try to add in a condition in the PROCESS section for the same table source it comes back with Column Not Found.

[TeeSee1]

Actually I see nothing wrong here. Just to test, you get similar errors using a different field in the filter condition?

[googlenoob62]

Yes, same error if I use any other column from the table. Works fine in the Expression Assistant and clicking the 'Test' in the Expression Assistant shows the correct data but, when you go to test the BOT thats when it throws the error that it can't find the column.

Something just doesn't seem right that it keeps throwing this error. Power Automate was much easier to work with using OData filters.