Forwading email from shared mailbox based on list item

[dnealy001]

I have a shared mailbox that I am monitoring with "when a new email arrives to shared mailbox" as the trigger. When the email comes in I want it to check a sharepoint list to match the "from" field on the email to the "From" field on the list and then forward that email to the "To" email from the list that corresponds to the "From" on the list.

[Cr1t]

Hello  @dnealy001

I have created a test list.

I have used a trigger When a new email arrives in a shared mailbox 


After that i have used get items, and connected to sharepoint list with the details.
In the Filter Query part i have used Title eq '@{triggerOutputs()?['body/from']}'

Title because my column name is Title, you have to enter your From eq 'From field from when email arrives'

Then i have used forward an email v2 to forward the email.

Message Id: map from When a new email arrives in a shared mailbox (V2)
To: Map from Get Items.

This is the test below, sent email to Flexibot sharedmail box.

Received forwarded email to my app dev account

Let me know if this works. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[claudiovc]

Hi @dnealy001 

try this

1.- action When a new email arrives in a shared mailbox (v2) (outlook 365)

2.-action Get items (sharepoint)

3.- action Forward an email (outlook 365)

I hope it helps you

[dnealy001]

This works but is there a way that I can add a condition where if no email was found or forwarded then I recieve an email stating no email was found. Basically the list I will be using is going to be changing and I want to know if the email was forwarded and if not I can go check it to see if I need to add the new email to my list. 

[claudiovc]

@dnealy001  Yes you can

please try this:

below get elements put an action, condition ( i dont know how it call in english)

length(outputs('Obtener_elementos')?['body/value'])

is greater than

0

Yes: put the action Forward an email (same my previous answer)

No:

action Send an email

in field body you can put the email from is not in the list

take the field "from" from  the trigger action

I hope it helps you

[dnealy001]

I get the error: 

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Array'.'.

[claudiovc · Accepted solution]

Hi @dnealy001 

I guess I was not clear

[dnealy001]

That's working. Thank you!