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; } } }

Can "Upload file from URL" destination be a SharePoint folder?

Tiff

I have a flow set up that starts with a Survey123 submission trigger, generating a feature reporting and then uploading that to OneDrive and subsequently sending an email.

This project is highly collaborative and I would like the reports to reside in a shared SharePoint folder rather than my personal OneDrive. I have not been able to find any resources on how to do so/whether it's possible using the Destination File Path parameter. Any assistance is appreciated!

Find more posts tagged with

Accepted answers

Beard_Greg

Oh no! Sorry about that. You got me curious so I looked around and found some things and built one. Once again, @IsmaelChivite coming to the rescue.

Main Source for flow (Source 1): Survey123 Create Report action in Microsoft Power Automate (Preview)

Answered SharePoint Portion (Source 2). Ismael suggested transferring from OneDrive to SharePoint: Use Power Automate with Survey123 and SharePoint

So based on what I found, it wasn't quick and easy to get the PDF report into SharePoint. However, it was super easy getting it into OneDrive. The flow I will be showing: When a Survey123 is submitted, create a report, download report into OneDrive, copy the data from OneDrive into SharePoint, sends email with attachment, deletes OneDrive file.

Overview:

Step1: When a survey response is submitted. Choose your survey123.

Step 2: Create Report. For this to work, you will need to have already created a report template on the Data tab on the Survey123 Website. Source 1 has a video. First two questions are your Survey123 information. If you've create a report template, it should be listed as a drop down. Object ID is the ObjectID of the survey123 so that should be simple. Report Name is what you want to call the file. Make sure it is unique! Change the format to PDF.

Step 3: Upload Report into OneDrive. Source 1 does a really good job explaining this. I chose to put mine in a specific folder. Hypothetically if this works perfectly every time, this folder will always be empty. I changed my Overwrite output to "Yes" just in case, but it works with No as well. "Yes" helps with testing. It's transferring to SharePoint so it doesn't matter too much especially if you give the file a unique name.

Source URL = Use URL - URL of the first result file from Dynamic Content

Destination File Path: Where you want it saved. I added Name - Name of the first result file from Dynamic content

Step 4: Get the File Content so that you can transfer to SharePoint.

File Path: Use the dynamic content Upload file from URL - Path

Step 5: Create File (SharePoint). Site Address / Folder Path for where you want it saved.

File Name you have some options, but I just went with the name generated by Step 3.

File Content: Use Dynamic Content to find Get file content using path - File Content (second image).

Step 6: Send Email

Attachment Name / Content: I used the same fields I used in Step 5 for creating the file in SharePoint

Step 7: Delete file (OneDrive)

The ID is from Upload file from URL - ID (The unique identifier of the file or folder)

Hope this helps!

All comments

Tiff

Thank you, @Beard_Greg! I'm testing this out now and hoping you or @SeanKMcGinnis could offer some more insight. I am realizing now that the HTTP/Situation Report operation in Premium only. Unfortunately I don't think I have premium.

Am I able to perform the "Create file" action without the Situation Report operation / Is there another way to get the feature report into SharePoint with a similar workflow? Of course, followed by getting the URL/PDF to send in an email.

I see Greg is using the "Get attachments" action as well. I'm not entirely sure what "List Name" refers to, but it is only letting me put in the general site address (not the specific folder where the PDFs will live).

Beard_Greg

@Tiff,

I might not be understanding the question. Are you trying to get the URL and / or the PDF to send in an email? If so, both are possible.

1) I don't have a flow screenshot using the ArcGIS Actions method, but I found a popular guide that uses a similar method Shawn mentioned. Survey123 Tricks of the Trade: Working with attachments in Microsoft Power Automate. If you need to generate a URL, you can use "SharePoint's Create Sharing link for file or folder".

2) I'm using 365 so I can't help you there.

Tiff

Thanks @Beard_Greg! This is something I am looking into possibly because I may want to transfer the flow to someone else in the future.

Tiff

Hi @SeanKMcGinnis, thank you again for this. I am still trying to gain access to the correct SharePoint folder so I have not yet been able to test this out. I just have a couple questions:

1) Can this feed into additional actions of 1. getting the file content by path and 2. sending an email with the PDF generated?

2) We have an older version of SharePoint as well; do you know if this only works with modern SharePoint or possibly the one we are using as of 2018?

Beard_Greg

@Tiff,

You can share your flow with the person that owns the OneDrive folder and they can make the connection for you if needed.

Beard_Greg

Thanks for the quick reply. I'm not sure why it isn't working for me. I'm rebuilding using the ESRI's "Get Attachment" instead of using the HTTP. That seemed to have resolved my issue.

SeanKMcGinnis

@Beard_Greg - I am testing a number of different flows in support of UC presentations and am having no issues.

Beard_Greg

@SeanKMcGinnis / @Tiff ,
Are these flows still working for you? I found this suggestion on another thread a little while ago and it had been working great. Unfortunately the PDFs in SharePoint are coming in empty now. It looks as if they are there, but the files are only 1KB now.

SeanKMcGinnis

@Tiff - I am not 100% sure. But I think if you have permissions to write to the directory you should be able to create the file.

Tiff

Thank you so much! I will try this out. Related question - is it possible to have the folder path be in someone else's OneDrive and not your own? @SeanKMcGinnis

SeanKMcGinnis

@RobertAnderson3 - glad it helped!

RobertAnderson3

Oh this is awesome, I appreciate this step! I had been using the flow from Ismael that uploads to OneDrive, then gets content, then creates the SharePoint file and then deletes from my OneDrive but this makes way more sense!

SeanKMcGinnis

@Tiff - I recently built a flow that does the steps you are looking to accomplish. There are a couple extra steps needed, but it is pretty straight-forward.

The first thing I do is use an HTTP action to get the report from the URL as defined by the Create Report action.

Then use the SharePoint 'Create file' action to write the body of the HTTP request as the File Content.

Below are the two steps from the flow:

Screen Shot 2023-06-20 at 5.14.08 PM.png

Hopefully this helps and please let me know if you have any other questions.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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