SharePoint Attachment Issue

[xuyinaoyixue1]

Hey there,

I tried to pull the attachment saved in sharepoint into the list, but it shows error below. Do you know why? 

Below is how I set 

See below error

[ManishSolanki]

Hi @xuyinaoyixue1 

In Get file content, you have typed the folder path, but it should be a valid file path. Pls try adding the file path & retest the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[xuyinaoyixue1]

@ManishSolanki Thanks, but it still shows error, even I copied the link of the path where the attachment goes. Not sure because that link is not accessible to everyone. 

Here, let me explain what i want, you might give me some ideas what else I should do. 

I created a form in microsoft for user to fill in the form to submit the IT service request, and then each record should populated in share point list with related attachment.  It works partially, since I cannot see the attachment associated with each record.

[xuyinaoyixue1 · Accepted solution]

Please see below how I create the flow to try to add the attachment in the list. 

What I want: Added the attachment into individual records. 

This is where the attachment was originally stored

Project Optimus Prime\Documents\APP\Microsoft Forms\Test - RR IT Service Request

This is how I set the flow in power automate

Select Output Previous Steps:

json(outputs('Get_response_details')?['body/r11f847be23074ad4b0428cd0794ecfc7'])

Get File Content

Site Address: ( Project Optimus Prime)

File Identifier: Project Optimus Prime\Documents\APP\Microsoft Forms\Test - RR IT Service Request

BUT it seems to request for a file not folder path....Any thoughts? I guess that might be the reason I failed. If that's the case, what I should do if i know the folder path that connects to attachment. 

Thanks!

[ManishSolanki]

Hi @xuyinaoyixue1 

Pls replace "Get file content" action with "Get file content using path". Pass the folder path where all form's attachments are stored in document library along with the file name in "File Path" parameter. We will write an expression to get the file name uploaded from the MS form:

Expression used to get the file name:

item()?['name']

Pls remember to replace the actual folder path with the '/Shared Documents/Apps/Microsoft Forms/Untitled form/Question/'.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[xuyinaoyixue1]

@ManishSolanki  Thanks. Let me check your solution and keep you posted. Thank you so much!