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.
Retrieving data ...