Unanswered

Filter using contains

(0) Share

Report

Posted on by Taylope1

So here is my current items line.

SortByColumns(Filter([@'SAM Catalogue'], 'BU Approved'.Value="RRR", TextSearchBox1.Text in Description||TextSearchBox1.Text in Application),"Title", If(SortDescending1, Descending, Ascending))

I want to add something like this so the above only filters is the UserPrincipal name contains XYZ.

If(Office365Users.MyProfile().UserPrincipalName contains "XYZ"

Thx

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

SimonPiquer 255 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I believe what you are looking for is the IsMatch function. So something along the lines of the following should do the trick:

SortByColumns(Filter([@'SAM Catalogue'], IsMatch(Office365Users.MyProfile().UserPrincipalName,"XYZ",MatchOptions.Contains), 'BU Approved'.Value="RRR", TextSearchBox1.Text in Description||TextSearchBox1.Text in Application),"Title", If(SortDescending1, Descending, Ascending))
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Taylope1

What relationship does UserPrincipalName have to your datasource. Where can we find it? What column?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Taylope1 60 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney

UserPrincipalName is effectively looking at the current user.

If they in domain XXX i want to filter the list using filter A. If their domain is not containing XXX then use another filter on the items.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Taylope1
Right. But what I am asking is: where is that information stored in your datasource? What column? If UserPrinicpleName is not found there you cannot filter by it. I could be wrong on this, but I checked and SharePoint does not store UserPrincipalName in a People column.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."