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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send email based on fi...
Power Automate
Unanswered

Send email based on file name

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hello Everyone and thank you for your time,

I've been trying to create this flow for a while now but with no luck, I'm still learning about Power Automate. I already went through some similar posts but I always encounter a roadblock, I believe it is fairly simple.

We put a list of files in a OneDrive Folder with the following name structure:

Michael64_0-1619541584467.png


Is there a way to send each of those files attached to a specific email based on the first 9 numbers of the file? We have a list in an excel file stored in OneDrive as well that looks like this:

Michael64_0-1619541983318.png

 

Thank you so much for your help,

Categories:
Building flows
I have the same question (0)
  • Paulie78 Profile Picture
    Paulie78 8,424 Moderator on at

    Certainly possible. Personally I think the data the customer number/email address would be better in a SharePoint list but either is fine.

     

    Basically you want to build a flow that goes something like this:

     

    1. Read your Excel file which contains the endCustomerNumber and email address data.
    2. List your files.
      1. Go into an apply to each loop based off your file list.
      2. Split the filename based on a space character and take the first element of that split
      3. Filter the list of customer/email addresses based on the customernumber found, and take the first (and only result).
      4. Send the email

    Done

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Paulie,

    Thank you so much for your response! Sorry, I'm super new to Power Automate and even thought I can interpret some of the steps that you mentioned, It seems like I have some trouble understanding some of those.

    Could you provide like a similar flow screenshot or maybe another post where I could get additional information?

    Sorry for the inconvenience and thank you again for your time!

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans