Sharepoint List attachments Not showing in Email in PowerAutomate Flow

[kflow12]

Hi

I have used many peoples suggestions to eventually created a flow that does not have an error message. However, this is not attaching any documents. 

We have created a sharepoint list which has attachments on occassion. 

When the new item is created we send out an email to IT and Creator with the full list details and attachments.

All of the variables from the list create successfully in email format and there are no errors in the flow. The flow runs but does not attach anything. For the test of the flow I added a new item with 2 attachments that are .jpg

I really do not know what could be wrong. 

These were the steps followed

Get Item

Get Attachments

Initialise variable array

Apply to Each

Get attachment content

Append to array  

Send an email - array used in attachment block

I did not add a condition for has attachment yet as I am only testing on an item with 2 attachments but I assume that should be added to prevent failure of flows without attachments.

[ekarim2020]

Hi @kflow12 ,

Please take a look at the append to array action below. It should be formatted as shown:

The content can be selected from Dynamic content:

 

After saving the flow and re-opening your flow , your ContentBytes may look different to the screenshot above, but dont worry - they both refer to the same content. Example:

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[kflow12]

Hi Ellis

It does not look like it matters to the flow if you use the dynamic or code mix - I had to add the [ ] to get it to work. Problem with the dynamic content solution if I do a code peek it does not contain the .$content which results in this error:

No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.
clientRequestId: 36aaa968-ddcb-4990-85c1-3e0f44328110

This is the code peek sample: 

"ContentBytes": "@body('Get_attachment_content')"

From what I understand from community responses is that the .$content fixes the error and it does but I still do not get an attachment.

P.S I also tried using the code in an expression and that did not fix it either.

I am going to try adding a microsoft document and see if it is the content format maybe.

[ekarim2020]

Hi @kflow12 ,

This is the runtime output of my working demo flow that reads two list item attachments:

Using the following append to array action:

And this is the sample runtime output of the Outlook email:

 

Please can you show your Send Mail action, due to the following error message:

Please provide required input parameters 'To', 'Subject' and 'Body'.
clientRequestId: 36aaa968-ddcb-4990-85c1-3e0f44328110

This is the Send Email action in my demo flow:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

[kflow12]

Hi Ellis

This is the revised array and error message

This is the raw input:

{

    "method": "post",

    "path": "/v2/Mail",

    "host": {

        "api": {

            "runtimeUrl": "https://europe-002.azure-apim.net/apim/office365"

        },

        "connection": {

            "name": "/providers/Microsoft.PowerApps/apis/shared_office365/connections/shared-office365-XXXXXXXXXXXXXXXXXXXXXXXX"

        }

    },

    "authentication": {

        "scheme": "Key",

        "parameter": "*sanitized*",

        "type": "Raw"

    },

    "body": {

        "To": "XXXXXXXXXXXXXXXXXX",

        "Subject": "New IT Request Form from XXXXXXXXXXX for ccccccccccccccccc",

        "Body": "<p>An IT Request Form for ccccccccccccccccc has been created with the Following Details:<br>\n<br>\n<strong>ListID:</strong> 16<br>\n<strong>New User:</strong> ccccccccccccccccc<br>\n<strong>Cell:</strong> cccccccccccccccccc<br>\n<strong>Job Title:</strong> cccccccccccccccc<br>\n<strong>Company Access:</strong> XXXXXXXXXXXXXX;XXXXXXXXXXXXXXX<br>\n<strong>Perm/Temp:</strong> Permanent<br>\n<strong>Department:</strong> Finance;Warehouse<br>\n<strong>Region:</strong> JHB<br>\n<strong>Distribution Lists:</strong> Venues (Venue Booking Team);Finance (Finance Team)<br>\n<strong>Due By:</strong> 2022-04-14<br>\n<strong>Hardware:</strong> Backpack (R350)<br>\n<strong>Programs:</strong> Server (R30pm);Promoforce<br>\n<strong>Additional Comments: </strong>ccccccccccccccccccccc&nbsp;<br>\n</p>",

        "Cc": "XXXXXXXXXXXXXXXXX",

        "Attachments": [

            {

                "Name": "List Conditional Formatting for View.docx",

                "ContentBytes": [

                    {

                        "Id": "%252fLists%252fIT%2bRequest%2bForm%252fAttachments%252f16%252fList%2bConditional%2bFormatting%2bfor%2bView.docx",

                        "AbsoluteUri": "https://XXXXXXXXXX.sharepoint.com/Lists/IT Request Form/Attachments/16/List Conditional Formatting for View.docx",

                        "DisplayName": "List Conditional Formatting for View.docx",

                        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListItemAttachment"

                    },

                    {

                        "Id": "%252fLists%252fIT%2bRequest%2bForm%252fAttachments%252f16%252fPayment%2bRequisitions.xlsx",

                        "AbsoluteUri": "https://XXXXXXXXXXXXXX.sharepoint.com/Lists/IT Request Form/Attachments/16/Payment Requisitions.xlsx",

                        "DisplayName": "Payment Requisitions.xlsx",

                        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListItemAttachment"

                    }

                ]

            },

            {

                "Name": "Payment Requisitions.xlsx",

                "ContentBytes": [

                    {

                        "Id": "%252fLists%252fIT%2bRequest%2bForm%252fAttachments%252f16%252fList%2bConditional%2bFormatting%2bfor%2bView.docx",

                        "AbsoluteUri": "https://XXXXXXXXXXXXXXXX.sharepoint.com/Lists/IT Request Form/Attachments/16/List Conditional Formatting for View.docx",

                        "DisplayName": "List Conditional Formatting for View.docx",

                        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListItemAttachment"

                    },

                    {

                        "Id": "%252fLists%252fIT%2bRequest%2bForm%252fAttachments%252f16%252fPayment%2bRequisitions.xlsx",

                        "AbsoluteUri": "https://XXXXXXXXXXXXXXXX.sharepoint.com/Lists/IT Request Form/Attachments/16/Payment Requisitions.xlsx",

                        "DisplayName": "Payment Requisitions.xlsx",

                        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListItemAttachment"

                    }

                ]

            }

        ]

    }

}

This is outputs 

{

    "statusCode": 400,

    "headers": {

        "Pragma": "no-cache",

        "x-ms-request-id": "963f9cdf-d3df-4259-9d42-4524afcc85d8",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "Cache-Control": "no-store, no-cache",

        "Set-Cookie": "ARRAffinity=1f3ee080fbb92f73fdfa1cff379924fa4aef82b8d0dfc7a016a6ca841d410e46;Path=/;HttpOnly;Secure;Domain=office365-we.azconn-we-003.p.azurewebsites.net,ARRAffinitySameSite=1f3ee080fbb92f73fdfa1cff379924fa4aef82b8d0dfc7a016a6ca841d410e46;Path=/;HttpOnly;SameSite=None;Secure;Domain=office365-we.azconn-we-003.p.azurewebsites.net",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "false",

        "x-ms-apihub-obo": "true",

        "Date": "Thu, 14 Apr 2022 09:34:36 GMT",

        "Content-Length": "394",

        "Content-Type": "application/json",

        "Expires": "-1"

    },

    "body": {

        "status": 400,

        "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: 963f9cdf-d3df-4259-9d42-4524afcc85d8",

        "error": {

            "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'."

        },

        "source": "office365-we.azconn-we-003.p.azurewebsites.net"

    }

}

Body Message:

{

  "status": 400,

  "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: 963f9cdf-d3df-4259-9d42-4524afcc85d8",

  "error": {

    "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'."

  },

  "source": "office365-we.azconn-we-003.p.azurewebsites.net"

}

[kflow12 · Accepted solution]

Hi

I got something to work. From the example it looked as if it was trying to attach all attachments for every ID.

I added the following in Append:

I added the body('Get_attachmment_content').$content as an expression which then converted the expression to the sharepoint $content you see.

The flow now works.

[v-jefferni]

Hi @kflow12 ,

Please consider Accept your reply as the solution to help the other members find it.

Best regards,

Community Support Team _ Jeffer Ni