Filter out text in one Text Label using another Text Label

(0) Share

Report

Posted on by VictorTek

127

Hi!

I have a Text Label ("Pod Members") that is pulling through a text list of names from SharePoint:

Bob Harris

Jo Wright

Sally Kilmer

Thomas Redmond

The Text Property is: LookUp('PSMC Cover Pod Members', Title = LookUp('PSMC Cover Pods', Name.DisplayName= User().FullName, Title)
, 'Pod Members2')

I want to be able to match the User().FullName up to the text in "Pod Members" and just show the remaining names.

IE:

User().FullName = Bob Harris

"Pod Members" =

Jo Wright

Sally Kilmer

Thomas Redmond

I have tried a few things but no luck yet. Can anyone help?

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@VictorTek ,

Just a thought:

Substitute( LookUp('PSMC Cover Pod Members', Title = LookUp('PSMC Cover Pods', Name.DisplayName= User().FullName, Title), 'Pod Members2' ), User().FullName, "" )

Hope it helps !
VictorTek 127 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked! but it leave a gap in my list. Is there a way to close up the gap. If Jo Wright is the User, the above returns

Bob Harris

Sally Kilmer
Thomas Redmond
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@VictorTek

!IsBlank( Substitute( LookUp('PSMC Cover Pod Members', Title = LookUp('PSMC Cover Pods', Name.DisplayName= User().FullName, Title), 'Pod Members2' ), User().FullName, "" ) )
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Also as a thought. I guess we need to replace a double appearance of carriage return char and a new line char with only one.

So:

Substitute( Substitute( LookUp('PSMC Cover Pod Members', Title = LookUp('PSMC Cover Pods', Name.DisplayName= User().FullName, Title), 'Pod Members2' ), User().FullName, "" ), Char(13)&Char(10)&Char(13)&Char(10), Char(13)&Char(10) )

If it not working this way, maybe you need to replace the:

Char(13)&Char(10)&Char(13)&Char(10)

with:

Char(13)&Char(13)

because I'm not sure how the string is build.
VictorTek 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Drrickryp - however that returns "True" as the value in the Text Label
VictorTek 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Drrickryp - however that returns "True" as the value in the Text Label
VictorTek 127 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @gabibalaban I am still getting the space:

Bob Harris

Sally Kilmer
Thomas Redmond