Why am I seeing this error when I use lookup() inside a workflow template ?
Not sure, but anyways I would try LOOKUP([_THISROW].[CUSTOMER] etc…
Also, it shows success here when there is an error.
Always does… One must use the Automation monitor…
Ok, I asume you get a green “Check” symbol in your formula in the editor?
And that all table name and column names are spelled right.
And no sec filters blocking (you can “Bypass securityfilter” in the task)?
And you use << >> around the formula in the template?
Sorry, no more clues…
For lookup i can use ANY(SELECT(),…) Function. But I notice this error for the first time.
Also, here is the images for reference.
Sales Invoice template
Sales Table
Customer Table
Error
Even I’m out of clues.
But your error is in Body template.
What do you have there…?
Same formula wrapped with << >>
Everything was working fine until i moved it to automation bot. Here is another example that is causing me error in a delivered application
Maybe try ANY(SELECT… and see. Should give the same result.
Any(select ()… ) Always works. Lookup is showing me the error.
Unbelievable.
Attn @prithpal @Dan_Bahir @praveen
This is definitely a bug. Please contact support@appsheet.com for help with this.
I will take a guess that the response to the success when it fails will be that the bot “successfully started” and is not indicated “the bot successfully completed all tasks”. I have seen somewhere that that was how it was described.
Hi Rifad,
Could you send an email to support@appsheet.com, provide the App Name, UserId, Bot Name and allow support access to your app?
We will debug this issue and get it working for you.
Thanks
Done @Dan_Bahir
I don’t see it mentioned here…Did you try inserting explicit quotation marks around the second, third and fourth parameters of the LOOKUP(). Leaving them off is really a shorthand approach within AppSheet’s parsers.
Yes i tried and it did not work @WillowMobileSystems
Automation Monitor is not showing my app
Attn @prithpal @Dan_Bahir
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |