Hello!
I have a survey that's used for site data collection. The records are edited in the future when the site is revisited. I have automated email sent to a specific group using PowerAutomate once the survey is submitted. I'm setting up the outlook email through PowerAutomate and I cant seem to find the attirbutes containing the submitted and edited date which I would like to include in the email. Is this information possible to pull from survey? Any help is appreciated.
Thanks.
Any updates on this: we have the same issue?
If you "include survey info" option for the webhook, the outputs of the automated webhook trigger from a survey should include most of the attributes, but NOT the standard AGOL hosted feature layer CreationDate and the other "editor tracking" fields. However, you could use the time of the webhook received as the created time, although it may be off technically by 1-3 seconds for the time it took to get the webhook to PA.
If you use Survey123 connect, you can specify in the XLSform that the survey should include the built-in survey "start" and "end" types. You can 'name' these fields to be whatever attribute name you want them to be in the hosted feature layer; these are separate from CreationDate although often the survey "end" (i.e. when user hit the submit button) datetime should be basically the same as the CreationDate time. They do not show up to the user.
The way I do it is I use the webhook as the trigger, but then use the objectid from the survey to query the hosted feature layer for that objectid so I get the 'full' set of attributes, including CreationDate and EditDate. This would be necessary later on anyway if you have a custom field to store an 'edited' datetime instead of using the native EditDate editor tracking field. Lemme know if any of that doesn't make sense I can try to explain further.