Exclude some file types or file sizes when copying email attachments to OneDrive

[Banana-Man]

Hi, I am using a flow which copies attachments from incoming emails into a OneDrive Folder. But, I need to exclude some file types or file sizes from the flow. For example, some incoming emails have embedded images in the signature (.png graphics files for phone or address) which I do not want to copy.

I am new to Power Automate, so would appreciate some advice.

Derek

[Expiscornovus · Accepted solution]

Hi @Banana-Man,

This would be possible via a trigger condition expression. Below is an example.

I am using the endswith function together with the file name property of the trigger action. I am using a not function to exclude it in this expression.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#e...

@not(endsWith(triggerOutputs()?['body/attachments']?[0]?['name'], '.png'))

You can add that expression via the settings of the trigger action in your flow.

 

For file size you can use the size column of the triggerOutputs btw. Below is an expression for a size which is less than 1024 bytes.

@less(triggerOutputs()?['body/attachments']?[0]?['size'], 1024)

[Banana-Man]

@Expiscornovus  Thank you. I will give that a go.

Many thanks.