Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

How to include attachment to email from the row in sharepoint list

(0) ShareShare
ReportReport
Posted on by 12

Hello everyone! 

 

I have a SharePoint list with "Expiring date" column. When expiring date = current date flow will triggered and a user will receive a notification with some info and an attachment from row belongs to this user.

 

Everything working except one thing. Notification email includes all the attachment from every row, not only from one that contains expiring date. 

 

I guess I should take needed item from array but google doesn't gives me an answer how.

Maybe some one could help me. Thanks. 

 

Screenshot 2021-09-07 at 22.48.28.pngScreenshot 2021-09-07 at 22.48.42.pngScreenshot 2021-09-07 at 22.49.23.pngScreenshot 2021-09-07 at 22.53.23.pngScreenshot 2021-09-07 at 22.49.32.png

  • DenisBalakirevV Profile Picture
    12 on at
    Re: How to include attachment to email from the row in sharepoint list

    Lily,

     

    Thank you! It works perfectly!

     

    I just using a little bit different date formula - 

    addDays(utcNow(),1,'yyyy-MM-dd') To have a possibility to sent the notification before week or month of expiring date.

    Many thanks!

  • Verified answer
    v-LilyW-msft Profile Picture
    on at
    Re: How to include attachment to email from the row in sharepoint list

    Hi @DenisBalakirevV 

    Please notice the single quotes here.

    vLilyWmsft_2-1631086458822.png

    Best Regards

  • v-LilyW-msft Profile Picture
    on at
    Re: How to include attachment to email from the row in sharepoint list

    Hi @DenisBalakirevV 

    Yes, you need to manually enter the internal name of the date column.

    You can find column internal name via List settings -> Click on the column name -> It’s at the end of the URL on the Edit column page, after ‘Field=’.

    vLilyWmsft_1-1631086087584.png

    Best Regards

     

     

  • DenisBalakirevV Profile Picture
    12 on at
    Re: How to include attachment to email from the row in sharepoint list

    Hello Lily!

     

    I tried to implement your solution but faced an issue with "Filter Query".

    Dynamic content is not available for this row. Should I insert column name manually here?

    Screenshot 2021-09-08 at 10.17.24.png

  • v-LilyW-msft Profile Picture
    on at
    Re: How to include attachment to email from the row in sharepoint list

    Hi @DenisBalakirevV 

    I recreated a Flow based on the information you provided.

    You can take a try with the following screenshots.

    This is my test list.

    vLilyWmsft_0-1631063552812.png

    Flow in details:

    vLilyWmsft_1-1631063783954.png

    vLilyWmsft_2-1631063797235.png

    vLilyWmsft_4-1631064042630.png

    vLilyWmsft_5-1631064084875.png

    vLilyWmsft_6-1631064107131.png

    After Flow runs, Lily and Li will receive reminder emails separately.

    vLilyWmsft_7-1631064283328.pngvLilyWmsft_8-1631064300286.png

    Hope the content above may help you.

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow