I've set up a bot that calls two separate app script functions, but only one is successful in setting the returned value, using a data action in the next step. The first function creates a Google Drive folder if the [Folder URL] field is blank and the next function creates a spreadsheet from a template if the [Sample Data Sheet] field is blank. Both functions return a URL which I use the [Step Name].[Output] to set value of the fields in the next step (shown below).
Folder Creation:
Spreadsheet Creation
In the live app the Folder URL will not set the value even though the monitor logs show the URL has been returned, and in the copied app, the Sample Data Sheet URL won't set the value. For example, the automation monitor logs show the full URL successfully returned from the function in step 10, but in step 11, where I run the custom data action "Set Sample Data sheet URL" , the value is blank.
When these run separately in their own bot they work just fine which leads me to believe this is a bug. It seems that if you return two or more values from a script within a single process, at least one of your output variables (e.g. [Step Name].[Output]) will not work. In my live app the Folder URL output variable doesn't work and it's reversed in the copy of the app. Any help or guidance would be greatly appreciated.
User | Count |
---|---|
18 | |
11 | |
7 | |
5 | |
5 |