cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rados
Helper I
Helper I

How to get clear phone number from Office 365 User Profile using Business Phones Item option

Hi all,

We have made a flow to get data from Office 365 user profile. When we use dynamic content "Business Phones Item" to get a phone number in an e-mail, we get the phone number surounded by square brackets and qutoes. But, when we use Mobile Phone option we get a regular form of number. Is it possible to remove all other values, and leave just the phone number, when we use "Business Phones Item" option? Using replace expression, or any other way?

Screenshot_1.pngScreenshot_2.png

Screenshot_3.png

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User II
Super User II

Hi @Rados,

 

The reason why the fields are behaving differently is because the Mobile Phone field can only contain one value and the Business Phones field can contain multiple phone numbers (Array).

 

If you want to collect the first item without quotes you can use the following expression:

outputs('Get_user_profile_(V2)')?['body/businessPhones'][0]

 

View solution in original post

2 REPLIES 2
Expiscornovus
Super User II
Super User II

Hi @Rados,

 

The reason why the fields are behaving differently is because the Mobile Phone field can only contain one value and the Business Phones field can contain multiple phone numbers (Array).

 

If you want to collect the first item without quotes you can use the following expression:

outputs('Get_user_profile_(V2)')?['body/businessPhones'][0]

 

View solution in original post

@Expiscornovus ,

That's it! Thank you!

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (47,056)