I have created a flow to facilitate taking data from a SharePoint Document Library, writing it to an excel document table with the headers based on a document's columns in the library, and then send that excel document in an email to specific stakeholders.
The flow currently parses that data successfully, as I can view this data in the raw code on the apply to each stage, and creates both the excel document and table within the document with the appropriate headers. Where the flow is failing as at an Apply to Each step with Add row to Table within it to occur on each current item. The flow is pictured below; any assistance would be appreciated.
Ive searched around on the community for people with the same issue, and the solutions from their end do not apply. Here are a few things I have tried:
- Delete and readd the Apply to Each and Add row segment
- Confirm no column header has special characters
Spoiler (Highlight to read)
{
"status": 400,
"message": "A value must be provided for item.\r\nclientRequestId: d53b5f22-acca-4418-a57c-fa6521fe0518",
"error": {
"message": "A value must be provided for item."
},
"source": "excelonline-wus.azconn-wus-001.p.azurewebsites.net"
}
{ "status": 400, "message": "A value must be provided for item.\r\nclientRequestId: d53b5f22-acca-4418-a57c-fa6521fe0518", "error": { "message": "A value must be provided for item." }, "source": "excelonline-wus.azconn-wus-001.p.azurewebsites.net"}
