Take one email with two attachments and save each attachment into a different folder

[adrianstensrud]

EDIT: This post has been solved and has a two part solution. One from @annajhaveri and one where I added more details as to why it did not work for me specifically.

I used to get an email with one attachment and save it to a sharepoint/onedrive folder through Power Automate. The condition was that it had an attachment, then part of the subject and the sender email address. However, now I get two attachments in the same email, with different attachment names (the vendor will not send these separately). Now I have been trying multiple ways of moving these two attachments into separate sharepoint/onedrive folders.. without success.

What I have now is below (not working). I am trying to check what the name of the attachment is, and based on that, move it to a specific folder. The difference between this and what I had when there was only one attachment, is the "Get Attachment (V2)" step and the Condition. However, when I try to run it, the first and second condition returns "false".. although the name does contain exactly what I have written as the condition..

Any suggestions? What am I missing?

[annajhaveri]

@adrianstensrud which condition is not working for you, could you please share the flow run screenshot and example names of the attachments.

[adrianstensrud]

Hi @annajhaveri . Neither the condition "Attachments Name > contains > Phone_Contacts" or "Attachments Name > contains > Working_Hours" works. It evaluates as "false". There are two screenshots attached in the original post with the full flow.

The full attachment name would be for example: "ACD_Phone_Contacts_11072022_014023_wLpC4m.xls".

As for the output when testing the flow:

[annajhaveri · Accepted solution]

@adrianstensrud i did test your scenario and the conditions work for me, so looks like there is something more to attachment name in your case, can you assign value of attachment name in compose action and take screenshot of compose action from the flow run and share the screenshot. Also please double check comparison value in the condition, that it doesnt have any space after it. 

[adrianstensrud]

Hi, strange. It is the full name of the attachment, although everything after "ACD_Phone_Contacts_xxxxx" changes every day. I don't get why "contains" condition is failing, as it literally contains what I am defining, it should not need to match. I also now tried adding the "ACD_" part of the name, in case the rule cannot for some reason start in the middle of the name (even though it should, as it contains) without luck. I also tried to send the email to myself directly, instead of forwarding it, to make sure it was not due to some metadata regarding the email being forwarded confusing the flow.

Did you try with one file named "ACD_Phone_Contacts_" and "ACD_Working_Hours_xxxxx", or just one file? Everything works fine when I have just one file, and it is only an issue when having two files. What has been working when the email used to only have one file:

[annajhaveri]

@adrianstensrud yes i did try with two files. See my screenshots below, so this usually works, not sure why it isnt working for you, did you double check the condition values for Phone_Contacts and Working_Hours, and ensured that it doesnt have any trailing spaces?

[adrianstensrud]

Hi. Indeed, no trailing spaces. I write them manually. I see you have a Compose step.. could you share that? Also, when I look at my result in the test, I only have one entry/page in the apply to each step. Shouldn't I get two since there are two attachments?

[annajhaveri]

@adrianstensrud  i added compose action just to show the file name, you can also add compose action, so that you know the exact file name that is being checked in the flow, assign the Attachment Name dynamic content within the compose action. When you have one file, the apply to each will have one step, when you have two files apply to each should show two steps. For further troubleshooting is it possible for you to export and share the flow? Otherwise, atleast add the compose action with attachments name value, within apply to each, to see whats happening there in the apply to each action.

[adrianstensrud]

Sorry for the late response. I tested and tested again, and now added the compose action and got "smime.p7m" as the in- and output. Googled it and it seems it is because my email is encrypted. So I updated it now again with some adjustments that should work (and for some reason I had gotten "apply to each" instead of "apply to each attachment" in the apply-to-each step. So I will check tomorrow morning when the email from the original source arrives to see if it works and see what the output is then, if it does not work still.

Thank you for your support so far!

[adrianstensrud · Accepted solution]

It worked eventually. I think the main issue I had was that when sending the email to myself as a test, it did not work because I am sending my emails digitally signed and encrypted, and got "smime.p7m" as the in- and output.  The original sender does not. So here is my final flow that works now: