I made many combinations of Select and IN, I knew that was the way but I did not have the mental clarity that you have. Just great
But I have another problem:
When I do the TEST of the expression, it returns the path of the correct PDFs but when I execute the Workflow, it fails and I get the following error:
“Errors”: "Error: Workflow attachment file ‘3’ not found for UserId: 461773, UserEmail: ‘firstname.lastname@example.org’, Provider: ‘google’, DataSource: ‘google’, Path: ‘DocId = 1vevAJh_ZEh9 -8zaj3ycJkXSzKi-iZX0IeFf6fh8qWqk ‘, Table:’ Products’ [Shared], ProbableCause: ‘Failed: Path:’ 3 ‘, Message:’ Searching for ‘3’, Cache entry not found ‘.’ “,
“Warnings”: “Warning: App version 1.000530 is not deployed.” All workflow emails are therefore being sent to the app creator This email should have gone To 'at.talknet @ gmail.com, simasanjuan @ gmail.com, jahernandez @ gmail .com ‘CC’ed to’ ‘and BCC’ed to’ '”,
If I click on the file icon in the app, open the pdf without problems, there is no route error, but I am intrigued by that number 3: “Failed: Path: ‘3’, Message: ‘Searching for’ 3 '”
I do not understand where it comes from, it’s as if one of the files had the route as 3.
Some of the products do not have an associated pdf, and the cell of the route is blank, first I thought the error was caused by not finding any route, but I copied the route of another product in the cell of those that had no route and He kept giving the error.
Thanks in advance for the help