Outlook Dynamic Content Contact Fields

[emilia]

Hi Everyone

I'm new to power automate and I've basically been trying to automate an email filing system. My current flow is:

When a new email arrives (inbox) ->

Export email (message id) ->

Create file:

• Folder path: ***
• File name: concat(triggerOutputs()?['body/subject'],'.eml')
• File content: body

This works perfectly fine, but I'm wondering if I can get a specific folder path.

Essentially I want to create a folder using dynamic content based on the contact's organisation field. The closest thing I get is to/from/cc, but this gives me virtually no organisational options and if anything actually makes it harder to locate files since it only categorises based on sender/recipient (as opposed to the organisations as a whole which those people work for).

I am doing this because my organisation receives a large number of emails that need to be easily accessed at any moment. We currently have a very comprehensive file system on our hard drive that works great to retrieve emails but takes a long time to individually file each email. Is this something I can even achieve using power automate?

I know this is a really complicated question and I'm not quite sure how to word the issue I'm having as I have little tech experience, but I'm taking it here since it's the only option for non-premium members.

tl;dr -- Is there a dynamic content field for an Outlook contact's work organisation?

[fchopo · Accepted solution]

Hi @emilia 

No, there no dynamic content field for an Outlook contact's work organization. Instead of that, I would work with the organization domain name: e.g test@mycompany.com would get mycompany as organization Id.

Therefore, you could use the "From" field and use the following expression to get the domain:

split(split(triggerOutputs()?['body/from'],'@')[1],'.')[0]

Then you can create a folder name for each domain and store there the emails.

Hope it helps!

Ferran

[emilia]

Thanks so much! This is super helpful.