Power Automate

Upload Existing MS Forms Images to SharePoint Image Column

(0) Share

Report

Posted on by rameshmukka

1,129

I'm trying to migrate existing MS Forms responses into a SharePoint list, and I'm stuck on the image part.

Scenario

User X owns an MS Form with a File Upload field where respondents uploaded their profile pictures.
These are old submissions (I'm not processing new form responses).
The responses are available in the Excel file stored in User X's OneDrive, and that Excel has been shared with me.
I can loop through the Excel rows and create SharePoint list items without any issue.
The SharePoint list has an Image column.

The problem

The Excel only contains the image URL. I can open that URL in my browser, so I clearly have access to the file. However, I need to upload that same image into the SharePoint Image column.

The actual file is still stored in User X's OneDrive, so I can't use the OneDrive connector with my own connection to get the file content.

I know one option is to ask User X to use their OneDrive connection in the flow, but I'm wondering if there's another way.

My question

Since I can already access the image URL in the browser, is there a way to retrieve the image content directly in Power Automate (using the URL, HTTP action, or another approach) and use it to populate the SharePoint Image column without relying on User X's OneDrive connector?

Has anyone handled this scenario for existing MS Forms submissions?

Categories:

Building flows

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

sannavajjala87 883 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Yes, this can be done, but the key challenge is authentication. Being able to open the URL in a browser doesn't necessarily mean Power Automate can access the file content using that same URL.
A couple of approaches you could try:

If the file URL is a SharePoint/OneDrive URL within your tenant, use an HTTP with Microsoft Entra ID action (or SharePoint REST API) to retrieve the file content, provided your account has permission to the file.

If the file has been shared directly with you and your account has access, you may be able to retrieve the file using SharePoint actions against the underlying document library rather than using User X's OneDrive connector.

If the URL requires User X's identity to access the file, then using User X's connection (or moving the files to a shared location) may be unavoidable.

For the SharePoint Image column, the typical pattern is:

Get file content.

Upload the image to SharePoint.

Update the Image column with the uploaded image reference.

I'd first determine whether the URL is pointing to a SharePoint document library behind the Forms upload folder. If your account can access that library directly, you may not need User X's OneDrive connection at all.

Thanks & Regards,

Manoj Annavajjala

www.powerplatformengineer.com

Was this reply helpful? Yes No
rameshmukka 1,129 on at

Like
a
(0)

Report
Copy link

Link copied!

I have tried with below SharePoint action. The action succeeded but the response don't have file content to use it in my SharePoint action to populate the image column.

Here is the response of the action

Was this reply helpful? Yes No