Renaming a file based on an existing filename.

[NickFoxall]

Hi all,

This is something that sounds so simple but i've really struggled in finding an answer. 

I received weekly vehicle reports from a set email address, I have a flow set up to save the email attachments in a shared Sharepoint folder. The files come through like this (where the vehicle reg number for example is ABC123):

ABC123 - Inspection Report.pdf

I'd like to add into my flow to rename the file simply as ABC123.pdf so that I can link it in other flows and automatically email the report to the end user based on a sharepoint list reg numbers and users. 

Thanks in advance and I'm hoping this is as simple as it sounds!

Nick

[grantjenkins · Accepted solution]

If you knew that all the attachments were going to be the exact same format and all PDF, then you could do the following. Note the expression used is:

concat(slice(items('Apply_to_each')?['name'], 0, indexOf(items('Apply_to_each')?['name'], ' ')), '.pdf')

[NickFoxall]

Thanks for this, the coding used in the compose section. Has it got a name as would love to learn more about the function etc.