Survey123 - when a survey response is submitted, IF attachment is uploaded - save this attachment to a sharepoint folder & create path to attachment in excel worksheet

(0) Share

Report

Posted on by SunshineK

102

Hi Team,

I am struggling with creating this flow.

Part 1.

When a survey is submitted, IF this has an attachment uploaded then create a file and save this attachment to a sharepoint folder.

Firstly I have no idea what dynamic content to input for the condition.

Secondly, again, I don't know what dynamic content to input for File Content.

I really don't know where to begin.

Part 2.

When a survey response is submitted, this information goes into an excel spreadsheet - this all works well.

However if there is an attachment uploaded, in the 'Attachment/s' column I want the path to the location of attachment to be automatically shown so it can be clicked on and taken to that attachment within the sharepoint folder.

Again, no idea where to begin.

Any help would be greatly appreciated.

Thanks,

Summer

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-alzhan-msft on at

Like (0)

Report
Hi @SunshineK ,

You could refer to screenshot to create the Condition:

empty(outputs('Compose'))

And you could refer to link below to create the file in the sharepoint:

https://www.bythedevs.com/post/working-with-files-on-ms-forms-group-form-in-ms-power-automate

And you could add the link for the created file to the excel table, however we couldn't create a clickable link in the excel table in Microsoft flow currently.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
sverkerEsriSE 3 on at

Like (0)

Report

Hi Summer,
I've been doing some research on this, by testing and by reading the following:
https://community.esri.com/groups/survey123/blog/2019/06/04/survey123-tricks-of-the-trade-integromat

Basically, you need to use the URL for the attachments and an HTTP-request action to download the attachments, then you can attach them. Since the HTTP Request requires Power Automate premium, I haven't been able to test this myself.

If the feature service that hosts the attachments is not public, you also need to supply a login token with the HTTP request that downloads the file. To get this token, you need to first make an HTTP request that gets the token, then use it in the request that downloads the file.

You can read more about that here: https://developers.arcgis.com/labs/rest/get-an-access-token/

Best regards,
Sverker

Was this reply helpful? Yes No
SunshineK 102 on at

Like (0)

Report

Thanks Alice.
Given I am using Survey123 - I am not 100% sure if I am on the right track.
It was 'successful' but didn't do what I wanted it to do.
Firstly I know I missed the 'get response details' action - I don't know what to use here for survey123.

The dynamic content of my 'attachment/s' that I want to save are options as follows:

I used 'feature attachments'.

As said - runs successful however in my folder which was initially empty it has create these subheadings:

Any help would be great?

Was this reply helpful? Yes No
SunshineK 102 on at

Like (1)

Report

Thank you Sverker.

I got lost on the get token stuff.

I can get access to certain parts of premium I guess .... I could use the HTTP action.
However I couldn't use 'when a HTTP request is received' ?

https://community.esri.com/thread/232707-ms-flow-to-grab-photos-in-survey123-and-add-them-to-a-sql-report

Will continue to play around with this flow.

Was this reply helpful? Yes No