Unanswered

Save Attachement from email and rename file without date

(0) Share

Report

Posted on by Pierre_EOLEN

Hi, I am new with Power automate.

I am trying to save attachement from email into a my own folder. This parts works well if I only use the name of the file. My issue is to save this file with the another name.

The files comes with a project name follow by the date of the day. Example: 56Afnvproject_20220815.xslx. I would like to delete the date at the end of the file so other system can find the file.

My daily email only contains one file.

Thanks,

Pierre

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Re: Save Attachement from email and rename file without date

Hello @Pierre_EOLEN ,

in the number of last characters to be removed is always the same, you can follow this steps:

1. Add the "Get attachment (V2)" action:

The Message Id and Attachments Attachment Id are grabbed from the Trigger

2. Add a "Compose" action in which put the following expression:

substring(items('Apply_to_each')?['name'],0,sub(length(items('Apply_to_each')?['name']),14))

This function will remove the last 14 characters, including the extension ".xlsx"

3. Add the OneDrive "Create file" action, where put the previous Compose outputs in the "File Name" +.xlsx

Add the "Content Bytes" value, grabbed from the "Get Attachment" action, in the "File Content" field.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Was this reply helpful? Yes No
Pierre_EOLEN 7 on at

Like (1)

Report

Re: Save Attachement from email and rename file without date

Thanks a lot Marco,

If people are beginner like me, the compose and create must be inside the loop. I had to do some test before succeed it.

Pierre

Was this reply helpful? Yes No