cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BKGOUD
Helper III
Helper III

Split emailid's from collection values

Hi All, I have a collection with multiple emailid's. i want to split the emailid's by @. Can someone help on this. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

@BKGOUD  Please give me a screenshot with the error !

View solution in original post

3 REPLIES 3
gabibalaban
Dual Super User
Dual Super User

Hi @BKGOUD ,

 

You can split in two columns the email addresses using something like this:

 

AddColumns(YourCollection,"PartBefore@",Left(emailid,Find("@",emailid)-1),"PartAfter@",Right(emailid,Len(emailid)-Find("@",emailid)))

 

I add to your collection two columns one with the partbefore@ and one with the partafter@.

Is this what you want to achieve ? 

 

 

Hi @gabibalaban ,

 

Thanks for helping me. I used your code but it gives the error as expected text.

@BKGOUD  Please give me a screenshot with the error !

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,486)