Answered

Flow needs to only process csv attachments, sends message if email contains other files but not csv

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow built that looks at the attachments in an email and if there is a csv file it saves the file and sends a copy to an sFTP.

However, sometimes in addition to the csv there will be image files. And sometimes there will only be image files. In the case where there are only image files I want to send an email out to a group to let them know there was no csv attached.

But currently if I evaluate with the Yes No condition and say Yes process the file or No send an error message email the error message email always goes out when there are multiple files of csv and image. I need the email to only go out if the attachments were not csv.

I know I can create two flows to handle the entire situation but it seems like I should be able to do this with one, using an array. But when I tried that it errored out because I used the Attachment Name to ensure there was a csv.

How can I do this?

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hello @Anonymous ,
your condition will probably never be Yes, the 'contains' operator is designed for an array, if an array contains given value. In your case it seems you want to compare string (I guess the left side in your conditions is 'Attachments Name'), for which the operator 'ends with' will be better.
Also, the 'Apply to each' action will process all attachments in the email one by one. In case your email has 2x .png file and 1x .csv file, it'll check the 1st .png file and send an email (it's not .csv). It'll check the 2nd .png file and send an email (it's not .csv). It'll check the .csv file and upload all the files.
To check if one of the attachments is .csv and process the whole email accordingly I'd add a boolean variable and one 'Apply to each' action dedicated only to searching for the .csv file. If the variable is set to true at the end of this 'Apply to each', then there's a .csv file in the attachment. If it's still false, send the email.
Verified answer

Paulie78 8,424 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

I would change approach slightly. Simply filter the array of attachments, before you loop through them to contain only CSV files.

Here I sent myself a .csv and a .txt, but only the .csv remains in the filter array. You can then do a condition based on the length of the filter array and use that as a basis for the email to send or not. This would also be a bit faster.

Make sense? Using this method you never have to be concerned with the other non .csv attachments.