Hey all, I’m trying to create a scenario that watches an Esri Survey123, and creates a report for new records. It puts the report in a cloud drive and creates an email. I used this tutorial as a guide: https://www.youtube.com/watch?v=a7pABoinPlM
I have pieces of this working but I’m getting tripped up on the where clause in the survey123 create report module. I’m trying to format this to just get the record that is being processed in the queue but nothing seems to work. The objectid is the uniqueid for the record. There is already a field for putting in the objectid in the survey123 report module, and since I don’t need to do any advanced filtering I tried just leaving the where clause field blank or using ‘*’ , but this doesn’t work.
Anyone have a scenario with a survey123 report? How am I supposed to format the where clause to get the current queue item? thanks.