cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Lookup, Split, Concat

Hi all,

Struggling noob.

 

I can get an e-mail address to display if I use:

LookUp(MyCollection,'Title'=Gallery4.Selected.Title,Email)

 

The output of this is jimbo@emailaddress.com.

What I want to do that i'm struggling with is split and only retain jimbo and inject it here and display a clickable link

 

https://mywebsite/GroupManagement.aspx?Group=jimbo&Operation=join

 

I've been trying to add split to my lookup for the last 2 hours unsuccessfully 😞 and I haven't even gotten to start on trying the concat part yet.

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Lookup, Split, Concat

@russrimm 

 

Give this a try...

"https://mywebsite/GroupManagement.aspx?Group=" & 
First(Split(LookUp(MyCollection,'Title'=Gallery4.Selected.Title,Email), "@")).Result &
"&Operation=join"

This will put it all together for you.

 

I hope that helps you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Lookup, Split, Concat

I'm getting close.

I just tried this:

Left(LookUp(MyCollection,'Title'=Gallery4.Selected.Title,Email),Find("@",LookUp(MyCollection,'Title'=Gallery4.Selected.Title,Email)))

 

And my output is jimbo@

Now just gotta trim that @ and figure out how to concat the beginning and end of the URL and make it a URL 🙂

Highlighted
Super User III
Super User III

Re: Lookup, Split, Concat

@russrimm 

 

Give this a try...

"https://mywebsite/GroupManagement.aspx?Group=" & 
First(Split(LookUp(MyCollection,'Title'=Gallery4.Selected.Title,Email), "@")).Result &
"&Operation=join"

This will put it all together for you.

 

I hope that helps you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Lookup, Split, Concat

You make it look so easy!  🙂  THANK YOU!  That worked.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,107)