Extract specific numbers from email body

(0) Share

Report

Posted on by CU20011312-0

Hi,

I have issue, how better extract specific email body? Tried different options, but all failed. Maybe someone can help?

I receive email with specific email body, there are some text on top, then Link:........, but at the end I have numbers, which start with SHI.... one by one, in email these numbers SHI... can be different quantity, in one email can be 5 these numbers, in other email maybe 8 or 10 numbers.

I want to get from this email these numbers like SHI000006408, SHI000006410, SHI0000006411 and sort these numbers.

In output I want to receive one line with sorted numbers --> SHI000006408, SHI000006409, SHI000006410, SHI000006411

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@UshaJyothiKasibhotla Since there is no function match() in PA workflow expressions this does not work.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You could enhance this approach: https://community.powerplatform.com/forums/thread/details/?commentid=76f0a4bd-5bae-f011-bbd3-0022483138bd

Simply change the mapping of the Select to also allow the letters "S", "H" and "I", and add conditions to the Filter so that the result items begin with "SHI".

Then sort the resulting array and join it.

Was this reply helpful? Yes No