LinkedIn
Twitter
I can't figure out how to reference the output from a Call a process automation step in a subsequent step's start-end loop. Can someone explain how to accomplish this?
Here's the details of my automation.
Parts that work
The "Duplicate item" Call a process step calls the "New item" process, whose Return a value step returns a value for NewItemID. I can then reliably reference the NewItemID value in, for example, a straightforward data action step to set a column to that value. This all works reliably as explained in Use values from a previous step in a non-reusable action or task and Use 'Call a process' and 'Return values' steps in ... - Google Cloud Community.
Call a process step: Duplicate item
Return a value step: Return item ID
Data action step that (successfully) sets column value using [Duplicate item].[NewItemID]
Part that doesn't work
In the same automation I have a subsequent Call a webhook step that calls the AppSheet API and whose body includes a start...end expression to iterate on a list of rows to update one column in each row. It's an EnumList column, and I need to add NewItemID to each row's list for the column. Any way that I try to reference NewItemID, the app returns an error--either immediately upon saving in the editor due to an invalid schema reference or else later when running the automation and blank is returned for NewItemID, which results in the column failing validation. I know blank is returned from the Automation Monitor--for instance, in this example, the EnumList column's sole existing value (e447bd88) is listed followed by a comma indicating the NewListID blank value was appended to the end of the list, which in turn results in an error because that list isn't valid for the column:
\"Assigned Items\": \"e447bd88 ,\"
Error message:
Row having key 'ee94dee2' in table '...' containing value 'e447bd88 ,' in field 'Assigned Items' failed 'Valid_If' condition
Following are some of the syntaxes I've tried in the webhook body:
"Assigned Items": "<<[Assigned Items] + LIST([Duplicate item].[NewItemID])>>"
"Assigned Items": "<<[Assigned Items] + LIST([_THISROW].[Duplicate item].[NewItemID])>>"
"Assigned Items": "<<[Assigned Items] + Duplicate item[NewItemID]>>"
"Assigned Items": "<<[Assigned Items] + Duplicate item Output[NewItemID]>>"
