web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get part of text string

Power Apps

Answered

Get part of text string

(0) Share

Report

Report

Posted on by JAWL

393

Dear Experts,

I am struggling to get part of text from a string in power apps.

For example, my text field is:

User1 <user1@gmail.com>; User2 <user2@yahoo.com> ; User3 <user3@hotmail.com

I would like to extract all emails (meaning texts in between "<" and ">") from the above string. Desired output: user1@gmail.com; user2@yahoo.com; user3@hotmail.com

I have tried using SPLIT and FIND functions but to no avail.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Concat( Filter( Split( Concat( Filter( Split( "User1 <user1@gmail.com>; User2 <user2@yahoo.com> ; User3 <user3@hotmail.com", ";" ), "@" in Result ), Substitute( Substitute( Result, ">", "" ), "<", "" ) ), " " ), "@" in Result ), Result & "; " )

Hi @JAWL, the above should work for your situation - there was an extra layer of splitting needed to accommodate for the potential spaces between semi colons, but I tried it with a few examples and it worked correctly.

Just replace "User1 <user1@gmail.com>; User2 <user2@yahoo.com> ; User3 <user3@hotmail.com" with LabelName.Text if you need to refer to the label that currently contains the text, otherwise point it directly to the column or source.

Cheers,

Sancho

Was this reply helpful? Yes No

Join the conversation