nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Power Automate - Upload Repeat Photos to SharePoint

BattJones

Hello, all.

I have a survey that has 2 different repeat tables (not nested) - 1 (Inspection Photos) with photos. I'm trying to get photos from the Inspection Photos repeat to upload to SharePoint by using Power Automate. However, I've been unable to get the actual photos to upload - only text or it fails entirely with an error stating the object needs to be an array. I've tried a number of different variations of 'Apply to each' and what the 'File Content' field for SharePoint is, but none have been successful.

I've attached an example of how it currently looks. I've previously looked at both of these posts for reference as well (https://community.esri.com/t5/arcgis-survey123-questions/finding-the-picture-url-in-power-automate-in/m-p/1099924 and https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-working-with/ba-p/1000916).

Unsure if I'm just getting the field names wrong (they don't fully display in Power Automate). Any assistance on how to get this to work would be greatly appreciated. Thank you!

PowerAutomateExample.png

RequiredFields_Constraint.png

Encontre mais publicações marcadas com

Accepted answers

BattJones

@DerrickWestoby - Thank you SO much! Your answer gave me enough to bridge the gap I was missing (HTTP GET and the right combination of Apply to each (Iterator in Integromat).

My final(ish) flow is attached as a screenshot and text below. I run into an error between Apply to each 4 and Apply to each 5 when there's a blank image, but I'll be modifying the Survey to resolve that issue. Otherwise, working as intended!

Apply to each (feature repeats RepeatName)

Apply to each (feature repeats RepeatName attachments ImageFieldName)

HTTP - GET (URI: feature repeats RepeatName attachments ImageFieldName url) and (Queries: token / token (from a Parse JSON earlier in the flow))

SharePoint - Create File (File Content: Body of HTTP - GET)

PowerAutomate-RepeatImages.png

All comments

DerrickWestoby

I'm sorry I can't help you on Power Automate specifically, but I can show you how I have it set up in Integromat if that helps. It took me a bit to get this working in integromat as well. Same setup as you, photos in a repeat.

The array I'm passing to the iterator is the repeat itself (field_observations)

Then I run the scenario once by triggering the webhook with a submission, so that now I can see the structure for the next module. Here's where I'm grabbing the URL using an HTTP GET module

And uploading each photo to google drive, while renaming the photos. Note that in my scenario, I have to include the file extension when renaming.

BattJones

@DerrickWestoby - Thank you SO much! Your answer gave me enough to bridge the gap I was missing (HTTP GET and the right combination of Apply to each (Iterator in Integromat).

Apply to each (feature repeats RepeatName)

Apply to each (feature repeats RepeatName attachments ImageFieldName)

HTTP - GET (URI: feature repeats RepeatName attachments ImageFieldName url) and (Queries: token / token (from a Parse JSON earlier in the flow))

SharePoint - Create File (File Content: Body of HTTP - GET)

PowerAutomate-RepeatImages.png

DerrickWestoby

Welcome, and I'm glad it helped you!

(Credit to @IsmaelChivite and his awesome blog posts for teaching me how to do this in the first place)

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.