Power Platform Community Forum Thread Details

Adding Forms responses to Excel: multiple document uploads and JSON parsing

Hi all,

Working on a Flow for a colleague which collects Forms responses in an Excel table, including two questions which require respondents to upload a file. When dealing with individual file uploads in the past, I have used the Parse JSON connector along with the following code to make the file appear as a nicely formatted SharePoint link in the Excel spreadsheet:

{
 "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"
 ]
 }
}

The final product looked similar to this:

This has worked great in the past, however I'm unsure of how to get it to work when there are multiple file upload questions. Would I need to parse each question field form the forms that has a document upload? How would I differentiate the link output from each one?

Quick Links