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
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