Unanswered

Group SharePoint - Get File Content and add attachment to SharePoint list

(0) Share

Report

Posted on by SapphireOdette

Hello

I'm creating a flow 'When a new response is submitted (SharePoint)' the Microsoft Form responses which is in a Group SharePoint is sent to a SharePoint list.
I have no issue sending responses (create item) to the SharePoint list, but I cannot add the attachments to the list. Is my file identifier wrong?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @SapphireOdette ,
Please post screenshots of the parameters filled in these two 'actions'.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SapphireOdette 6 on at

Like (0)

Report

I have two attachments on the Forms, and one is an optional field.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @SapphireOdette ,
There are two questions about uploading attachments in your form, one is optional and the other is mandatory. You want to upload the attachments in these two questions to a new item you just created?
If so, I did a test for your reference.
In my scenario ‘Question’ is a required attachment question and ‘Document’ is an optional attachment question.
This is my complete flow screenshot:
Please note that because there are too many similar actions, do not select the dynamic content of the above action. Be sure to select the dynamic content of the corresponding action.
The code in the ‘Parse Json’ action:

{ "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "link": { "type": "string" }, "id": { "type": "string" }, "type": {}, "size": { "type": "integer" }, "referenceId": { "type": "string" }, "driveId": { "type": "string" }, "status": { "type": "integer" }, "uploadSessionUrl": {} }, "required": [ "name", "link", "id", "type", "size", "referenceId", "driveId", "status", "uploadSessionUrl" ] } }

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SapphireOdette 6 on at

Like (0)

Report

Hello

I have tried this flow and have the same issue. Should the get file content be from SharePoint and not OneDrive as the Microsoft Forms is housed on a Teams SharePoint and not a personal OneDrive?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @SapphireOdette ，
Please try to replace the 'Get file content (OneDrive)' control with the 'Get file content using path (SharePoint)' control.

/Shared Documents/Apps/Microsoft Forms/FormName/Question/

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SapphireOdette 6 on at

Like (0)

Report

Hello
My version of Power Automate is slightly different. Is the below correct?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @SapphireOdette ,
Your 'File Path' configuration is incorrect. You have selected two less files and an extra '/' symbol.
1)This is the new designer. You can switch to the classic designer.
2)Please copy and paste my expression into ‘File Path’, and then fill in your MS form name and dynamic content ‘name’.

/Shared Documents/Apps/Microsoft Forms//Question/

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No