Power Automate - Attachment does not have the actual name of the file

Question

In a flow that creates an email, I'm attaching an attachment to the mail.

The problem is that the file name is renamed.

%Attachment% has the value: https://company.sharepoint.com/sites/Nord/Default/Company information gathering - Excel.xlsx

Becomes an attachment with the name: Company%20information%20gathering%20-%20Excel.xlsx

I need the actual file name to be used, so without %20, without URL encode.

Company information gathering -Excel.xlsx

Answer 1

This is how I did it..

Get the file metadata from sharepoint, the info is saved in %GetFileMetadataResponse%

Then get file content using Get file content using path using the Path value from metadata %GetFileMetadataResponse.Path% and store it in %GetFileContentByPathResponse%

Then create a temp file by converting the binary data from the file content in %GetFileContentByPathResponse% using 'Convert binary to file' action, getting the name from metadata %GetFileMetadataResponse.Name%.

Then assign variable %attachment% to temp file path C:\temp\%GetFileMetadataResponse.Name%

and then use attachment as you usually would in send email.

The scenario is covered in the sharepoint documentation