MS Flow to grab photos in Survey123 and add them to a sql report

[JevitaWebster]

i'm using MS Flow to grab data from a Survey in Survey123, but the survey has photos. Can i use MS Flow to grab these photos and add them to the SQL report?

[JamesTedrick]

Hi Jevita,

Currently, downloading an attachment in Flow is somewhat difficult.  Here is an example workflow:

The steps are:

1. Send a request to the QueryAttachments Resource
2. Parse the results of the request as JSON
3. Extract the attachment id from the result (the ‘Compose’ step)
4. (optional) Extract the attachment’s file name (the ‘Compose 2’ step)
5. Request the attachment, using both the objectid of the feature and the id of the attachment

For steps 1 & 5, you will also need to provide a token of a user with the ability to query the feature service – Flow currently cannot access the token of the submitting user.

We are working to make this less cumbersome in the future.

[JevitaWebster]

does this work if the images question is in a repeater?

[JamesTedrick]

Hi Jevita,

This basic technique would work for images in related records - the main difference is the URLs used in steps 1 & 5 should refer to the layer number of the repeat table in the service.

[JevitaWebster]

James, Can you export the flow? 

[JamesTedrick]

Hi Jevita,

Here's the JSON export of the flow.

[NatalieAyala]

Are there any updates to this? Or possibly a new version of this JSON export? I've tried uploading this into Flow but get an error message. I've also tried recreated the flow as described but am having trouble finding the connectors from your screenshot above. 

I've got a Flow set up to generate a word document based on Survey123 data but need to include photos into the document as well. 

[NicholasConnolly]

Hi James,

Flow doesn't seem to be exposing the "attachmentInfos" "id" field. How do I get to the attachment id?

Thanks

Nicholas

[JamesTedrick]

Hi Nicholas,

It looks like you may have supplied the wrong payload to the queryAttachments step.

[RichardHughes2]

Hi James,

Today I am going to try a recreate your Flow to use attachments from a Survey.  We had issues with the Survey 123 Connector but we want to use Flow for handling event escalation and email notification from filtered surveys.  Do you know if there has been any progress on the MS Flow and Survey 123 issues in the past few months?