web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract Phone Number f...

Power Automate

Answered

Extract Phone Number from the body of a meeting invite in Office 365

(0) Share

Report

Report

Posted on by GTAJeff

8

Here are the steps I have taken

Here is the output of compose

November 13, 2024 9:30pm EST
Calendar: Woodworking Class / Workshop
Name: Jeff Ginsberg
Phone: (416) 111-2211
Email: jeff@gtawoodworks.com

Location....

These are the functions I have tried to extract JUST the phone number.

Desired Result = (416) 111-2211

Test1
trim(split(split(outputs('Compose'), 'Phone: ')[1], '\n')[0])
Result =
(416) 111-2211
Email: jeff@gtawoodworks.com

Location...

Test2
trim(first(split(split(outputs('Compose'), 'Phone: ')[1], 'Email:')[0]))
Result =
(

Test3
trim(first(split(split(outputs('Compose'), 'Phone: ')[1], '\n')))
Result =
(416) 111-2211
Email: jeff@gtawoodworks.com

Test4
trim(first(split(split(outputs('Compose'), 'Phone: ')[1], ' ')))
Result =
(416)

Any help would greatly be appreciated.

TIA

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Suggested answer

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Try the below expression:

split(split(outputs('Compose'), 'Phone: ')[1], decodeUriComponent('%0A'))[0]

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Verified answer

Chriddle 8,721 Super User 2026 Season 2 on at

Like
a
(3)

Report
Copy link

Link copied!
slice( split( outputs('Compose'), decodeUriComponent('%0A') )[3], 7 )

Was this reply helpful? Yes No
GTAJeff 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@Chriddle and @Expiscornovus both work like a charm.

What's the difference in the logic between the two expressions?

Was this reply helpful? Yes No
Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The approach I shared splits twice, once on the text Phone:, the second item of that array is used to split a second time on the new line character. Finally the first item is returned of that second split.

Criddle his approach splits on the new line character and uses the 4th item of that array and then uses a slice to get the phone value.

Both work if your structure of data always stays the same :)

Was this reply helpful? Yes No

Join the conversation