Answered

Create a flow that can pick characters from shared mailbox and send a message in Teams group

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

Can someone please help me to create a flow that can pick up the names from the email received in the shared mailbox and then send a customized message in a team's group chat?

Requirements:

- The message includes the names.

- Names are known so we can put the names and flow can check for that names in the email and if match then picks up.

Thanks in Advance.

Regards,

Viv

Categories:

Using connectors

I have the same question (0)

All responses (14)

Answers (1)

Sort by

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

What you want is if the name appears in the email, the Teams message will include this name?

Based on your description, I have made a simple test for your reference.

This is my flow:
If it does not contain a substring, the IndexOf function will return -1.

Email for test:
Result:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Habsburg,

Thank you for initiating this, The flow is working but it is not giving the right results. When the flow runs it is not picking the names in the email it is picking other names. I have nearly 10 names. I believe may be I'm putting something wrong in 'Append to array variable' part.

Please assist.

Is it also possible to pick if we can match emails address cc'd or send to with the shared mailbox.

Regards,

viv

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The formula in "Append to array variable" is item()
Or you could provide screenshots of the test and flow you have built, which will help me analyze the problem.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please find the flow above and the result below.
Email sent
Message recieved
Hope this helps😊.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Another issue I just picked out is that even if the name is not there in the email, it is still sending messages with the names.

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Change to "is not equal to" in "Condition" action:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I used multiple names nearly 3-4 names ( have a list of 10-15 names to match) but it is only picking 2 names. how do we add more variables in the message send to Teams

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I just demonstrate the situation of two names in the test. Even if you have many names, they are all placed in the variable "arr", you can put the whole array into the Teams action.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

When there is no name in the flow then it says the flow has failed. Instead of returning null and making flow fail. Can we just add another Post message thing that can just message 'There is an email for you to look at'?

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

We can concatenate them into a string, if there is no name, it will be blank.
join(variables('arr'),', ')

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No