web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery with Co...

Power Apps

Unanswered

Filter Gallery with Concat

(0) Share

Report

Report

Posted on by Paulinfo

15

Hello, I have a SharePoint List in a Gallery,

I want to show only the Items that the User is assigned to.

I used this filter, but it doesn't work.

Filter(List_Name; Concat(ThisItem.AssignedTo; DisplayName) = User().FullName)

The code alone works, but not in a filter.

Concat(ThisItem.AssignedTo; DisplayName)
User().FullName)

What am I doing wrong?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Paulinfo ,

You can try as below:

Filter(List_Name; AssignedTo.Email = User().Email)

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Paulinfo - if all you're trying to do is filter the Gallery by the current user based on your people field, is there a specific reason you need to use Concat?

You could alternatively use:

Filter(List_Name, AssignedTo.Email=varEmail)

You can set varEmail onto the OnStart property of your app. E.g.

Set(varEmail, User().Email);

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry @theapurva - all yours

Was this reply helpful? Yes No

Join the conversation