Pick dynamic Excel Data to SharePoint Data

[mithushalk]

Hi team, 

Need help in building  a flow.

Once a file is uploaded in the SharePoint document library, open the excel file & copy paste the data into the SharePoint list.

Note - File uploaded in the document library is always dynamic. I mean, it's always a different file so we need to identify the file based on the ID which we have in our database.

I did try building the flow using 

Trigger - When a file is created

Get file properties

Get file content

List rows in a table 

Flow isn't able to find the table or the file.

Thanks in advance!!! 

[Koen5]

Dear M,

Without the exact details/error of your flow, it is unlikely that anybody can help you.

Please include the screenshot of your flow and please do not describe the error, but include the literal error in the message. 

Happy flowing,

Koen

[mithushalk]

Hi @Koen5 , at the moment I'm seeing the below error. Can you please help me to solve it 

The template language expression 'outputs('filedNames')[34]' cannot be evaluated because array index '34' is outside bounds (0, 33) of array.

[Koen5]

Dear M,

Again, without the flow it is stabbing in the dark ... just on the generic ... you define that the flow should look at array index number 34 ... but your array only has 33 items. Take note that array index starts counting at 0, not 1.

Happy flowing,

Koen

[mithushalk]

Error message for the flow with Parse JSON

[

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].ItemInternalId",

    "schemaId": "#/items/properties/ItemInternalId",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Advertiser_CID",

    "schemaId": "#/items/properties/Advertiser_CID",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Advertiser_Name",

    "schemaId": "#/items/properties/Advertiser_Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Campaign_Name",

    "schemaId": "#/items/properties/Campaign_Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Campaign_ID",

    "schemaId": "#/items/properties/Campaign_ID",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Creator Name']",

    "schemaId": "#/items/properties/Creator Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['First Name']",

    "schemaId": "#/items/properties/First Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Last Name']",

    "schemaId": "#/items/properties/Last Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Primary URL']",

    "schemaId": "#/items/properties/Primary URL",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Email ID']",

    "schemaId": "#/items/properties/Email ID",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Country",

    "schemaId": "#/items/properties/Country",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Status",

    "schemaId": "#/items/properties/Status",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Tier",

    "schemaId": "#/items/properties/Tier",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].Verified",

    "schemaId": "#/items/properties/Verified",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Required Posts Number']",

    "schemaId": "#/items/properties/Required Posts Number",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Publisher ID']",

    "schemaId": "#/items/properties/Publisher ID",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID1",

    "schemaId": "#/items/properties/PID1",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID2",

    "schemaId": "#/items/properties/PID2",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID3",

    "schemaId": "#/items/properties/PID3",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID4",

    "schemaId": "#/items/properties/PID4",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID5",

    "schemaId": "#/items/properties/PID5",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID6",

    "schemaId": "#/items/properties/PID6",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID7",

    "schemaId": "#/items/properties/PID7",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9].PID8",

    "schemaId": "#/items/properties/PID8",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Primary Contact Name']",

    "schemaId": "#/items/properties/Primary Contact Name",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Primary Contact Email']",

    "schemaId": "#/items/properties/Primary Contact Email",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[9]['Creator ID']",

    "schemaId": "#/items/properties/Creator ID",

    "errorType": "type",

    "childErrors": []

  }

]

Adding the snaps of the flow below