Add a photo from a Microsoft form into a SharePoint folder on a site using Power Automate

Question

Hello -

I have a form that includes taking a photo. I would like to have that photo to be uploaded into a specific folder on a SharePoint site using Power Automate.

This is how I presently have my Flow set up:
When a new response is submitted > Get response details > Create File (included the correct site address from my drop down, selected the correct folder path, file name is stored correctly, file content is dynamic content and I selected the question that requires the photo).
My problem that I'm having is that when the photo gets uploaded to the correct folder, I'm not actually able to view the picture, which gets uploaded as a general File and not a JPG or PDF.

How can I fix this? Thank you!

Answer 1

Hi Ally,

For your concern, the issue is that the photo question output is not the actual image binary but it's a JSON file containing the reference text. In your current flow, the "Get response details" action returns the response data dynamically, while SharePoint "Create file" expects actual file content/library to upload a usable file.

In this case, you likely need a Parse JSON action after Get response details > Apply to each uploaded photo > Get file content > Create file.

That said, for you to receive the best possible suggestion and guidance, I recommend posting your scenario in the Microsoft Power Platform Community Forum Thread. This forum is dedicated to Power Automate and is actively monitored by experienced users, Microsoft partners, and engineers who can provide detailed guidance and share best practices. 

I apologize for redirecting you to another community, as I may not have the necessary skills and experience to provide an appropriate JSON script or an appropriate setup that can be applied to your flow. Although I cannot provide further assistance due to my limited knowledge of Power Automate, directing you to the correct and specialized support is the most effective help I can provide from my position. 

Thank you for your understanding and I truly hope everything gets sorted out soon.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.