web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Save attachements from...
Power Automate
Unanswered

Save attachements from Outlook, Save to OneDrive with last month's end date at end of filename

(0) ShareShare
ReportReport
Posted on by

Hi, I'm brand spanking new to Power Automate. I played around with this for quite awhile and searched online and thought I found a solution but then got stuck. On the 1st (sometimes 2nd) of the month I get two automated emails. Each one has one attachment:

  • HRBI Prd Document Usage Since 51120.xlsx
  • HRBI Public Prd Document Usage Since 51120.xlsx

Both emails contain in the subject: "Prd Document Usage"
Ultimately what I would like to do is copy the existing files in OneDrive folder "HRBI Analysis" and affix the month end date to the filename of those copies; actually the month end date will be from two months ago from today. And then would like to take the new attachments from Outlook 365 email and overwrite whats in OneDrive.
The flow below was my first practice attempt and I was just trying to learn how to add a date to the end of the filename before proceeding with the actual solution. The example I saw online used split and it was my understanding that that returns an array but I don't think I have it down on how to properly reference an output.

Please help.

PowerAutomate1.png

PowerAutomate2.png

Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    You need to use Power Automate expressions for your split and concat functions in order for them to run, else they will be treated a simple text:

    ekarim2020_0-1625353155597.png

    The above expression: toLower(last(split(items('Apply_to_each')?['name'],'.')))
     was entered into the Expressions builder. Note the fx prefix above.

    ekarim2020_1-1625353190050.png

     

    This learning module should help you with creating and using expressions:

    Introduction to expressions in Power Automate

     

    Regards,

     

    Ellis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard