Answered

Filing attachments in Document Library based on name using Office 365 Group Mail Connector

(0) Share

Report

Posted on by ccalaf

We are trying to build a flow using the Office 365 Group Mail connector as described here: Use our new Office 365 Groups Mail Connector! | Power Automate Blog (microsoft.com)

It works as expected however we would like to have the attachments filed in certain folders based on the name. For instance, if the attachment name had FLA in the first 3 characters, it would file it in the FLA folder. If the attachment didn't match any defined pattern/expression, it would file it in a "catch-all" folder we specify.

Is this possible with this connector? I know it is not GA yet.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @ccalaf ,

It is possible that you check the name of attachment and based on that put conditions to create the folder, in the post that you have linked, there is Apply to Each action under which there is Create file action to save attachments to SharePoint, just before this Create file action, you can put condition to check name of attachment and under Yes and No branches of condition, you can create the folder and put the create file action under it.

Let me know if you anything is unclear or you need more details.

Was this reply helpful? Yes No
ccalaf 17 on at

Like (0)

Report
Copy link

Link copied!

I appreciate the help. Yes, using an additional condition does work but how do you recommend handling multiple conditions? We expect to have multiple folders so would need to account for multiple file names?

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
There are two options one is you can write multiple condition actions and if you dont want to use multiple condition actions, you can use set variable, and expression in set variable like below, which checks if FileName starts with FLA then variable value will be "FLA" otherwise variable value will be "NoFLA"

if(startsWith(variables('FileName'),'FLA'),'FLA','NOFLA')

This way you can use multiple set variables and use same variable across all set variable actions. Then use switch action and use that variable in switch action with different cases of value you want to check. Let me know if its unclear, example screenshots of flow added below:
Check FLA value in filenameCheck ABC value in filenameSwitch condition

Was this reply helpful? Yes No
ccalaf 17 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the tip. I understand the concept, but I may be applying it incorrectly:
I initialized the variable before my first loop
and after the last loop, I added the Set Variable section:
But when I test the flow using an attachment that starts with FLA, it does not meet the condition

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You also need to set FileName variable using Set Variable action, are you doing that?

Was this reply helpful? Yes No
ccalaf 17 on at

Like (0)

Report
Copy link

Link copied!

Can you explain where I would set this variable? Would it before or after the varConditionResults variable?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You need to set this variable before the varConditionResults variable

Was this reply helpful? Yes No
ccalaf 17 on at

Like (0)

Report
Copy link

Link copied!

I am setting the variable "FileName" using the Attachment Name from the previous action.
But it still fails to match the condition.
Is there something wrong with my expression for varConditionResults?

Was this reply helpful? Yes No
ccalaf 17 on at

Like (0)

Report
Copy link

Link copied!

I see what I did. I typed the expression in the value window and not the Expression dialog box. It now works but I think I will need a dynamic variable using substring. I want the variable to be set based on the "startsWith". Is that possible while still using the variable named "FileName"?

Was this reply helpful? Yes No
ccalaf 17 on at

Like (1)

Report
Copy link

Link copied!

I figured it out. I just needed to change the varConditionResults value to the following expression:

substring(variables('FileName'),0,3)

Was this reply helpful? Yes No