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?
Currently, downloading an attachment in Flow is somewhat difficult. Here is an example workflow:
The steps are:
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.
does this work if the images question is in a repeater?
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.
James, Can you export the flow?
Here's the JSON export of the flow.
Flow doesn't seem to be exposing the "attachmentInfos" "id" field. How do I get to the attachment id?
It looks like you may have supplied the wrong payload to the queryAttachments step.
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?
There have not been any updates regarding Survey123 Connector/Attachment interactions in Flow.
Okay thanks for the response... I was able to get a prototype flow together to grab photos an put into a template by following the steps in your flow. I was surprised how relatively user friendly Flow is. I think I will start incorporating it into more of my projects.
Retrieving data ...