Answered

MS Teams phone numbers

(0) Share

Report

Posted on by Henryxia

Hello, I am building a power automate to send an email to people with our user's business phone number. Business phone number are not stored in office365users -> businessnumbers. They are in MS Teams (see picture below), I get this information in MS Teams Admin > Manage Users.

Is there a way where I can retrieve this phone number in powerautomate?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

DJ_Jamba 2,837 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Henryxia

Teams are just groups, so you can use the Office 365 Groups connector and select the Team.
Phone numbers will be in businessPhones which will be an array (as this field accepts multiple phone numbers)

Result:

Was this reply helpful? Yes No
Henryxia 13 on at

Like (0)

Report
Copy link

Link copied!

Got it! But now...How can I filter the phone number? I have a sharepoint list with a bunch of items, and a 'host' column with the host's email address. Then it will be sending an email to invitee with the host's business phone number.

Was this reply helpful? Yes No
Verified answer

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
email address is case sensitive so use toLower in your filter

Then to get the first (which is usually the primary number):
first(first(body('Filter_array'))?['businessPhones'])

Was this reply helpful? Yes No
Henryxia 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you @DJ_Jamba ! Everything is working as expected until I send the email. Here the screenshot
I am not sure what I am doing wrong

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Henryxia

I don't see any errors in your screenshot nor can I see what is wrong.

Would you mind creating a new post so that this other issue is not buried? It would help the community.
Hope you understand.

Also you can @mention me and I'll pick it up as soon as I can

Was this reply helpful? Yes No