You’re offline. This is a read only version of the page.
Hi All,
We have a flow that goes from a Microsoft Form - People upload a document, it creates an item in sharepoint, and then sends an email with the link to the sharepoint site.
Then it parses JSON to upload the content to OneDrive, then attaches it to Sharepoint.
The flow looks like this:
It fails under "GetFileContent" even though it's uploaded to OneDrive.
For reference - parameters are:
Share
Report{
"id": "/Apps/Microsoft Forms/Document Control Request/Submit copy of updatednew document/[{\"name\":\"NAME REDACTED.pdf\",\"link\":\"https://COMPANYNAME-my.sharepoint.com/personal/USEROFFLOW/Documents/Apps/Microsoft%20Forms/SUB%20FOLDER/YET%20ANOTHER%20SUBFOLDER/document.pdf\",\"id\":\"01TMIZTDQHVGENNA463ZCIYC2GBDSKKPLM\",\"type\":null,\"size\":44877,\"referenceId\":\"01TMIZTDVLV7ELREVDZ5FJ4QB77ZVWVMS3\",\"driveId\":\"b!6BNyt242dUuUWU5a2LoBXmH1JaC71ABOkqA17MNKW8sDK2ZjXj3eQ7Jy5tHDTEE9\",\"status\":1,\"uploadSessionUrl\":null}]",
"inferContentType": true
}
The file is coming from: /Apps/Microsoft Forms/Sub Folder/Yet another subfolder/outputs('Get_Response_Details')?['body/r8383f14cc66f4223a2b869789e2381cf']
Unfortunately this flow wasn't created by me but I have tried:
- Variables & Custom expressions
- Selecting the ID
Sadly Power Automate isnt something I'm too familiar with, how ever we need to get this resolved
Hi @NoMansLand ,
Please check this test:
First go to your SharePoint group site and check the folder path where the files uploaded by MS Form are stored.
My Folder Path:
My Flow:
{
"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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
All responses (
Answers (