Flow condition depending on multiple email attachment types

[Bubulover]

Hi all,

I've made a flow that starts from "when a new email arrives", and wondering if a solution exists for the below idea.

If there is no attachment, do "AAA", else check attachment name,

Then if attachment name contains .xls or contains .xlsx, do "BBB", else do "CCC".

The problem #1 is that the pictures inserted in email bodies are considered as attachments in the flow.

The problem #2 is that the check on attachment names is made for every single attachment.

For instance if an email arrives with an Excel file AND some pictures in the email body, I would like the flow to do "BBB" only.

But right now the flow does "BBB" and "CCC" depending each single attachment.

Any idea to make that happen please?

[v-dezhili-msft]

Hi @Bubulover ,

Do you want to only execute 'BBB' operation when there is' xlsx 'or' xls' file in the attachment?
You can create a string to store the suffix of all attachments and then determine whether the string contains' xlsx 'or' xls' to decide which operation to perform.

split(items('Apply_to_each')?['name'],'.')[1]
or(contains(variables('A'),'xlsx'),contains(variables('A'),'xls'))

Best Regards,

Dezhi

[Bubulover]

Dear @v-dezhili-msft ,

Thanks for taking a look to my request.

I think that I've sucessfully duplicated your logic but unfortunately it doesn't fit exactly what I need.

The issue remains on scenarios with emails sent with multiple attachments.

When there is only one attachment, or when there is no attachment, the flow works as expected.

Multiple attachment example #1:

If an email is sent with two .xlsx files, I would need to execute the outcome "BBB" twice, one per file.

Multiple attachment example #2:

If an email is sent with one .xlsx and one .docx, I would need to execute the outcome "BBB" once (for the .xlsx file) and that's it, no outcome "CCC" at all.

Do you think there is a way ?

Thank you !

[v-dezhili-msft · Accepted solution]

Hi @Bubulover ,

Do you want to execute 'BBB' as many times as there are Excel files?
You can use the Switch action to save the file information with the suffix 'xlsx' or 'xls' into an array, and then determine the length of the array. If the length is greater than 0, the array will be cycled to execute' BBB '. Similarly, you can handle image attachments in the same way to execute' CCC '

Best Regards,

Dezhi

[Bubulover]

Hi @v-dezhili-msft ,

Again, a big thank you.

My testing flow is working as expected now!

I did testing with multiple scenarios.

I've just moved the Condition #2 within the Switch part of the flow.

Hereunder are printscreens of this flow, could you please take a look and let me know if you identify anything odd?

(I've translated to english all text changeable)

I'm not 100% confident of my own understanding.

Thank you very much!