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 / Sending emails to mult...
Power Automate
Unanswered

Sending emails to multiple recipients based on an excel sheet with attachments extracted from different onedrive folders

(0) ShareShare
ReportReport
Posted on by 16

Hi Community, this is a follow up post from a previous post using sharepoint folders:

Sending emails to multiple recipients based on an ... - Power Platform Community (microsoft.com)

 

Based from an advice from a fellow community member, I have created the following flow:

josiahgoh_1_0-1717375990191.png

josiahgoh_1_1-1717376074040.png

josiahgoh_1_2-1717376123372.pngjosiahgoh_1_3-1717376158944.pngjosiahgoh_1_4-1717376180394.pngjosiahgoh_1_5-1717376220375.png

 

The excel sheet input is as follows:

josiahgoh_1_6-1717376407024.png

 

I face the following issue where i inputted a dynamic file path in the 'List files in folder' action and it resulted in an error:

josiahgoh_1_7-1717376686051.png

 

Error is as follows:

josiahgoh_1_8-1717376751698.png

 

However, i am able to get the flow to work if i were to select the file folder directly:

josiahgoh_1_10-1717376917012.png

josiahgoh_1_11-1717376957109.png

 

it seems that the flow will convert the folder path into an ID, usable by the flow, by the direct method.

 

Expected result:

josiahgoh_1_12-1717377117751.png

 

 

Kindly seek your advice on how I can input a dynamic file path, to get the flow working. Thanks in advance

Categories:
  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @josiahgoh_1 ,

    Could you please show the following link content of your folder?

    I want to extract the folder name from the folder link and insert it into the Folder path of list files in folder control.

     

    Best Regards,

    Sunshine Gu

     

  • josiahgoh_1 Profile Picture
    16 on at

    Hi Sunshine, can I clarify what do you mean by the link content of the folder?

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @josiahgoh_1 ,

    When you click on a folder link and jump to another page, please copy the URL in the address bar of this page.

    vyetonggumsft_0-1717379078371.png

    Best Regards,

    Sunshine Gu

  • josiahgoh_1 Profile Picture
    16 on at

    Hi Sunshine,

     

    Oh thank you for clarification. I don't think i can post the link in the forum here due to privacy concerns. 

     

    Can i ask how do we extract the folder name from the folder link and insert it into the Folder path of list files in folder control? 

     

    Would you mind sharing screenshots of such flows? Thank you

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard