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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send email to certain ...
Power Automate
Unanswered

Send email to certain people based on file name from one drive folder

(0) ShareShare
ReportReport
Posted on by 8

Hi

 

I am a newbie in Power Automate and hope to use this for my monthly housekeeping checks....

I have a folder in my one drive eg. Housekeeping which I will update monthly based on the housekeeping checks. 

The folder will contain many files based on the each PIC's name.    How can I achieve this by having power automate to auto get the relevant file from that folder and send email to each PIC and cc to my manager?

 

Eg. File with "Housekeepingdate - Tan.xlsx" added to the one drive folder.   I am able to send that file to the Tan's email address and cc to my manager and sequentially to send the next file "Housekeepingdate - Ong.xlsx to that Ong's email and cc to my manager... so on.

 

Any advise is much appreciated.

Thank you in advance.  

Joanna

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,501 on at

    Hey @simplyjojo76 

    • You can store the fine name in a compose.
    • After that use two compose statements.
    • First Compose Formula: split(outputs('Compose'),' ')
    • This will split the file name, where ever it finds a space and convert it to an array. If we see your above example: Housekeepingdate - Tan.xlsx, then we will get: "Housekeepingdate", "-", "Tan.xlsx"
    • Now the Seond Compose. Formula: split(outputs('Compose_2')[2],'.')
    • This will take Tax.xlsx and remove the dot and make an array again of Tax and xlsx.

    Sundeep_Malik_4-1663654456738.png

     

    After this just use condition and match it to the appropriate case and send email.

    Outputs Formula: outputs('Compose_3')[0]

    Sundeep_Malik_5-1663654472855.png

     

     

    I hope this helps.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 419

#2
Vish WR Profile Picture

Vish WR 314

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard