web
You’re offline. This is a read only version of the page.
close
Skip to main content
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:
I have the same question (0)
  • v-yetonggu-msft Profile Picture
    on at
    Re: Sending emails to multiple recipients based on an excel sheet with attachments extracted from different onedrive folders

    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
    Re: Sending emails to multiple recipients based on an excel sheet with attachments extracted from different onedrive folders

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

  • v-yetonggu-msft Profile Picture
    on at
    Re: Sending emails to multiple recipients based on an excel sheet with attachments extracted from different onedrive folders

    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
    Re: Sending emails to multiple recipients based on an excel sheet with attachments extracted from different onedrive folders

    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

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard