getting specific items with attachments from library and sending email based on sharepoint list

(0) Share

Report

Posted on by BianceBee

102

Hi there,

I have built a flow where it gets attachments based on certain IDs.

I have a list and a document library where the files are stored.

The list is used to get the APAC IDs and email of who should get what file.

The flow is working but what i am having issues with is that if there is no file attachment in the library for a APAC ID then it should skip. The below flow will still send an email to the person regardless if it has a file or not. Have tried to add the condition if no attachment do nothing but no luck

Below are the columns of the sharepoint list

Library of where the files are stored

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (1)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: getting specific items with attachments from library and sending email based on sharepoint list

Hi @BianceBee

Pls try to add a condition action before sending email which will check if list item contains an attachment or not. If yes, then send an email in the "Yes" section:

You can locate the "Has attachments" property of the current iterated item from the Dynamic content window.

Use expression for the right-hand operand. Expressions are entered in the expression window as highlighted below:

Expression used in above screenshot:

true

If the condition is true, then send the email to the required recipients.

If this helps & solves the problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report

Re: getting specific items with attachments from library and sending email based on sharepoint list

Hi @ManishSolanki unfortunately this will not work as the list does not contain the attachment it is in the library document. I created a array so it gets the attachment from the library by the name (same as apac id) and then filter the array so that from the list it sends the email to the correct person using the APAC ID.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: getting specific items with attachments from library and sending email based on sharepoint list

Hi @BianceBee

I catch the issue now. You need to check if the "Filter array" action returns any record or not. If records are returned, then we will send an email to the required user:

You need to add "Condition" action after "Filter array 2" action and check the length of the array returned by filter action. If the length is greater than one, then send an email. For checking the length of an array, you need to write an expression using length() function. Expressions are added in the separate expression window as highlighted in the below screenshot:

Expression used for calculating the length of an array:

length(body('Filter_array_2'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
BianceBee 102 on at

Like (0)

Report

Re: getting specific items with attachments from library and sending email based on sharepoint list

You are a legend @ManishSolanki thank you 🙂

Was this reply helpful? Yes No