how to split a string with @ symbol as separator

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

This could be fairly simple , I am trying to achieve below.

I have a label that logs current user email, as an example: jorge.johnson@abcmail.com

what I want to do is, extract jorge.johnson from the label above, how can I do that, I tried split function but its erroring so not sure if its right. See below. Please help me get a solution for this, thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous
place your Formular inside First(…your Formular here)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @PowerRanger , for some reason it still errors.

Was this reply helpful? Yes No
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous Sorry. Add .Result

So First(Split(.....)).Result

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@PowerRanger that worked, thanks so much.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous Split() will return a table with one column named Result

When you highlite a formular you can see it return value.

In your case we do know that we need the first item of this Table. Thats why we are using First()
First() will Return a record with one property named "Result"

Thats why we have to add .Result add the end because that the property which value we do want to get.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No