web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Save Attachement from ...

Power Automate

Answered

Save Attachement from email and rename file without date

(0) Share

Report

Report

Posted on by Pierre_EOLEN

7

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:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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
Pierre_EOLEN 7 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Join the conversation