Inconsistency on Attachments in Approval Flow - Sometimes doesn't have attachment but still sends the approval request

[ebco-swh]

Hi Everyone,

I've been looking for answers to this issue but can't find one.

I have this flow with a sharepoint list which requires an approval. Each line item may have multiple attachment based on what is attached in sharepoint list.

Here is the attachment flow for your reference:

Here it is in the Approval part.

Unfortunately the problem is most of the time. it works. but sometimes it sends the approval but without attachment. Here is the sample scenario. I tried to check the actual flow and it picks up the attachments. however, it is not attached to the approval

Not sure if the file name has something to do with this? Here are the file names in this flow any special characters that is not allowed? (Covered part is are just letters) I'm sure its not the file size because approval wont be sent if file size exceeds the limit.

Appreciate any help. Thank you!

[ekarim2020]

To send attachments along with a flow requires a different format as compared to sending attachments in Outlook.

{
    "name": @{items('Apply_to_each')?['name']
    },
    "content": {
        "$content-type": @{items('Apply_to_each')?['contentType']},
        "$content": @{items('Apply_to_each')?['contentBytes']}
    }
}

Ellis

[ebco-swh]

Thanks @ekarim2020 for the response

The Append array variable. is giving me this result.

the reason the flow fails

I tried to change @{items('Apply_to_each')?['name'] with a dynamic content "Display Name" @{items('Apply_to_each')?['DisplayName']} which worked

however was not able to find Content Type and ContentBytes. it still gives me a null result. is this expected?

[ebco-swh]

@ekarim2020 sorry I just realized the attachment in your screenshot is coming from an outlook. mine is coming from a sharepoint list item.

[ekarim2020]

As long as we satisfy how the Approval expects us to send it attachments, the source of attachment doesn't matter.

This the body of the content (which you can use in the expression) :

{
    "name": outputs('Get_file_metadata')?['body/DisplayName'],
    "content": {
        "$content-type": body('Get_attachment_content')['body']['$content-type'],
        "$content": body('Get_attachment_content')['body']['$content']
    }
}

 The content of varAttachment:

This should also work for you.

Ellis

[ebco-swh]

I've added "Get file metadata" and used the codes you have provided. Unfortunately, it says that it is not a valid json. I cant seem to show content type and content as a dynamic content.

[ekarim2020]

The JSON value in Append to Array variable needs to be entered as Dynamic content:

So your Append to array variable step should look like this, including the blue boxes (place-holder values):

Ellis

[ebco-swh]

I think that's where I'm having an issue. "Attachment Content Type" is not available on my dynamic content list. not sure why.

Instead, i tried to use "MediaType" from the "Get File Metadata" action.

Unfortunately, I cant open the file still

Here's the raw inputs from the flow. i've seen that its creating another line for content-type

just to share and not sure if it has to something to do with this. "Split on" is enabled in my trigger too.

[ebco-swh · Accepted solution]

@ekarim2020 for some reason below code worked for me by simply copying it to the array. not sure what's the difference with the initial code you gave. but thank you so much for answering my questions. Feel free to let me know what went wrong with this so I will note moving forward. Thank you so much again!

{
"Name": "@{items('Apply_to_each')?['DisplayName']}",
"content": {
"$content-type": "@{body('Get_attachment_content')['$content-type']}",
"$content": "@{body('Get_attachment_content')['$content']}"
}
}

[ekarim2020 · Accepted solution]

It's actually the same code. The code can be entered manually along with Dynamic content:

You can also copy and past the above code, as you see in the yellow rectangle below:

The issue with code is that it was taken from my flow and it's possible that the code may not work in your flow without changes. This can be due to a number of reasons such as I am using different variable names, my Apply to each loop has a different name to yours, the copy-paste contains extra characters that may need to be removed in some situations e.g.  @{items('Apply_to_each')?['name']} modified to items('Apply_to_each')?['name'].

Using Dynamic content will ensure you are using the correct content which is taken from your flow.

Ellis