Power Platform Community Forum Thread Details

Hi,

1. Trigger

Manual trigger or Scheduled trigger (daily/weekly)

Or When a file is created in the target folder

2. Get Files from Folder

Action: List files in folder (SharePoint)

Site Address: Your SharePoint site

Folder Path: Path to your target folder

Include Nested Files: Yes (if you want subfolders)

3. Parse Filename and Route Files

Action: Apply to each (Loop through files)

Inside the loop:

A. Extract User Identifier from Filename

Action: Compose

Inputs: split(items('Apply_to_each')?['Name'], '_')[0]

This extracts the part before the first underscore as user identifier

B. User Mapping (Choose Method)

Method 1: Using Switch/Condition

Switch on: outputs('Compose')
Case 'john': john.doe@company.com
Case 'mary': mary.smith@company.com
Case 'admin': admin@company.com
Default: manager@company.com

Method 2: Using Compose with Complex Expression

if(equals(outputs('Compose'), 'john'), 'john.doe@company.com',
if(equals(outputs('Compose'), 'mary'), 'mary.smith@company.com',
if(equals(outputs('Compose'), 'admin'), 'admin@company.com', 'manager@company.com')))

Method 3: Using SharePoint List (Recommended)

Create a SharePoint list with columns: UserCode, EmailAddress, FullName

Use "Get items" action to retrieve mapping

Filter by UserCode equals to extracted identifier

C. Get File Content

Action: Get file content (SharePoint)

Site Address: Same as above

File Identifier: items('Apply_to_each')?['Identifier']

D. Send Email with Attachment

Action: Send an email (V2)

To: Result from user mapping

Subject: File for you: @{items('Apply_to_each')?['Name']}

Body: Custom message

Attachments:
- Name: items('Apply_to_each')?['Name']
- Content: body('Get_file_content')

Example Implementation

Filename Patterns

john_report_2024.xlsx → sends to john.doe@company.com

mary_invoice_001.pdf → sends to mary.smith@company.com

admin_backup_data.zip → sends to admin@company.com

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Community site session details

READING A LIST OF FILES FROM A FOLDER AND SEND FILES TO PARTICULAR USERS DEPENDING ON NAME OF FILE

1. Trigger

2. Get Files from Folder

3. Parse Filename and Route Files

A. Extract User Identifier from Filename

B. User Mapping (Choose Method)

C. Get File Content

D. Send Email with Attachment

Example Implementation

Filename Patterns

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

READING A LIST OF FILES FROM A FOLDER AND SEND FILES TO PARTICULAR USERS DEPENDING ON NAME OF FILE

1. Trigger

2. Get Files from Folder

3. Parse Filename and Route Files

A. Extract User Identifier from Filename

B. User Mapping (Choose Method)

C. Get File Content

D. Send Email with Attachment

Example Implementation

Filename Patterns

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates