Hey Ryan, I tried your proposed solution for unauthorized users but it still didn't display the message.
Here is my validation query (the 'Enable
SQL Validation' is turned ON):
SELECT Authorised as IsValid
FROM UserPortals
WHERE UserID = $(UserID) AND PortalID = $(PortalID)
Validation message:
"Your account hasn't been authorized yet."
Users who are not authorized still did not get the message. So I tried the following to see if the workflow actually works:
SELECT '0' as IsValid
And it did display the message for all users except unauthorized users.
So what am I missing?