Answered

Filter an array of attachements from a sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I am trying to filter an array I have created to get the attachments from a SharePoint list.

What I am trying to do is make it so that when information is entered in the SharePoint list the flow will kick off and send the information from the list item in 3 separate emails. I have this working, the next step is to get the attachments and filter them by name to get attached to the emails. There should be two attachments to for each list item, both PDFs, one for Accounting and one for Insurance. The 3rd email is just a general email with some of the information from the list entry.

I have tried Filter Array, I cannot get it to return the results that I am looking for, it will still attached both items to the emails instead of the intended one for each email.

I followed this thread to get them both to attach to one email. https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

Any help would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello @Anonymous

You could use a switch statement, with different paths according to the first 3 letters of the file name, for example. Have a look at this sample:

According to the first 3 letters of the attachment's filename, flow goes to Accounting or insurnance branches, using the following expression:

substring(items()?['Apply_to_each']?['DisplayName'],0,3)

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@fchopoThank you for the assistance, I am encountering an error though, it says "Template validation failed: the template acction 'Switch' at line '1' and column '2810' is not vaild: "the template languages function 'items' must have at least one parameter.

Also what is in the compose function? I just put in the 'Display Name' from the Get attachment step.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
So i was able to get it to work. For the compose I used the 'DisplayName' from the 'Get Attachments' then for the switch I used
substring(outputs('Compose'),0,3)
And it is now working.

The last question I have, is there a way to make it more idiot proof? So that the capitalization of the file name would not matter?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I also was able to solve this issue by using the 'toUpper' command to change the file names to all uppercase then change the switch to all upper case.

Was this reply helpful? Yes No
DudelerDad 47 on at

Like (0)

Report
Copy link

Link copied!

I used a condition instead of a switch but your solution got me heading in the right direction.
Thanks.
Chris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This works great but if there is more than one attachment that matches the output it sends multiple emails. How would I loop each 3 letter filter so it picks up all the attachments with matching criteria so it sends only one per 3 letter switch.

example it would find the 3 rep jpgs and send then in one email then find the NHM jpg and so on

rep1.jpg
rep2.jpg
rep3.jpg
NHM.jpg
Cle.jpg

Was this reply helpful? Yes No
DudelerDad 47 on at

Like (0)

Report
Copy link

Link copied!

You could create an array variable for each case and then append to the variable as it loops through.
Then attach each variable to each email. I put this all in a Scope called 'collectattachments'.
Then I had another Scope that sends all the emails with the variables as the attachment.

So collect all the attachments in one step and then send the emails in another. Hope this helps.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks but i cant seem to get the append to variable to give me a name the box is greyed out.

Have you used initialize variable somewhere else in the flow and what type I tried string and array types but to no joy I either get no attachments or suffer the same multiple emails instead of one with all the relevant attachments.

Was this reply helpful? Yes No
DudelerDad 47 on at

Like (1)

Report
Copy link

Link copied!

Yes you have to Initialize all your variables before you can use them elsewhere in the flow. You have to do this on the top level which means a lot of time you end up with this huge list of variables at the top of your flow.
So create (initialize) the variable as an array. You should then be able to use the 'Append to array' action, select the variable and add the DisplayName and ContentBytes from the 'Get attachment content' action.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for clearing that up.

I had to change the append slightly for the ContentBytes from Body to AttachmentContent. All I was getting was the file name in the attachment section where as now I get the actual attachment now.

Was this reply helpful? Yes No