cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DenisBalakirevV
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @DenisBalakirevV 

Please notice the single quotes here.

vLilyWmsft_2-1631086458822.png

Best Regards

View solution in original post

5 REPLIES 5
v-LilyW-msft
Community Support
Community Support

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.

 

 

 

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

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

 

 

Hi @DenisBalakirevV 

Please notice the single quotes here.

vLilyWmsft_2-1631086458822.png

Best Regards

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!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,817)