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 Automate - Building Flows
Unanswered

Send emails with specific attachment stored on onedrive, on specific date listed in MS list

(0) ShareShare
ReportReport
Posted on by 34

Hi Community, 

 

Please see an example below:

Need a flow to automate sending an email with attachments on 3/31 for Alex, 4/3 for Ben, and 4/17 for Calvin.

eddiecheng_0-1710930227627.png

 

The attachments are already stored previously on OneDrive. For each name, I would like the flow to go to the corresponding folder and grab all the files as attachments:

eddiecheng_2-1710930511191.png

 

eddiecheng_3-1710930615087.png

 

Is it possible? Your instructions are much appreciated!

 

 

I have the same question (0)
  • v-mengmli-msft Profile Picture
    on at
    Re: Send emails with specific attachment stored on onedrive, on specific date listed in MS list

    Hi @eddiecheng ,

     

    You can create a flow runs daily which check if processdate equals today.

    Here is my test for your reference.

     

    vmengmlimsft_0-1710935334205.png

     

     

     

    Best regards,

    Rimmon

     

     

  • eddiecheng Profile Picture
    34 on at
    Re: Send emails with specific attachment stored on onedrive, on specific date listed in MS list

    Hi @v-mengmli-msft ,

     

    Thank you for your reply.

    I encountered this error, which I believe is about "time" within MS list:

     

    "The expression "To_x0020_HR_x002d_3 eq 2024-03-21" is not valid. Creating query failed."

     

    Here are some facts that I am not sure if they caused the error above:

    1. Actual column name is not "processdate", but "To_x0020_HR_x002d_3" (based on the name shown in the URL in sharepoint)

    2. I am based in UTC+8

    3. Column "To_x0020_HR_x002d_3" is a calculated column (= date from another column minus 1)

  • v-mengmli-msft Profile Picture
    on at
    Re: Send emails with specific attachment stored on onedrive, on specific date listed in MS list

    Hi @eddiecheng ,

     

    Unfortunately, Filter Query doesn't support Calculate Column, so you'll need to use Filter Array to do the filtering.

    Then, the value of "Get items" should be replaced by body of "Filter array". For the "Title" dynamic content, you can use item()?['Title'] to replace it.

     

    Best regards,

    Rimmon

  • eddiecheng Profile Picture
    34 on at
    Re: Send emails with specific attachment stored on onedrive, on specific date listed in MS list

    @v-mengmli-msft Thank you very much for your response but could you please provide the flow in diagram again? I am new to this app and not familiar with Filter Array functions... Thanks!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard