Unanswered

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

(0) Share

Report

Posted on by DenisBalakirevV

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.png Screenshot 2021-09-07 at 22.49.23.png Screenshot 2021-09-07 at 22.53.23.png

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

v-LilyW-msft on at

Like (0)

Report

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.
Flow in details:
After Flow runs, Lily and Li will receive reminder emails separately.
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.

Was this reply helpful? Yes No
DenisBalakirevV 12 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

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=’.
Best Regards

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @DenisBalakirevV
Please notice the single quotes here.
Best Regards

Was this reply helpful? Yes No
DenisBalakirevV 12 on at

Like (0)

Report

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!

Was this reply helpful? Yes No