web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Visible

Power Apps

Answered

Visible

(0) Share

Report

Report

Posted on by Anjac

12

Hi guys.

I have a gallery that are filtered <<Office365Users.DirectReportsV2(User().Email).value >>

Is there a way to set a icon within a gallery to visible If <<ThisItem.mail>> email address exist in a SharePoint list?

I succeed if I have the column in text format, but not when the column is People & Group.

What I want to achieve is that everyone in the gallery who is in a specific SharePoint list, should get an icon in the gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anjac ,

In case you have a text type column in your SharePoint list, you can use the below on the Visible property of the icon in the gallery:

!IsBlank( LookUp( SharePointListName, EmailColumnName = ThisItem.Mail ) )

Of course you will have to replace SharePointListName with the name of your SharePoint list and the same for EmailColumnName.

Was this reply helpful? Yes No
Anjac 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx for trying to help me !!=)
I get a error
!IsBlank(LookUp(Truckar, EMail = ThisItem.mail))
Incompatible types for comaparison, these can´t be compared: Record, Text.
My SPL is Truckar.
The my column EMail is a person & group column.
I use this when i used the column as text
ThisItem.IsSelected And !IsBlank(LookUp(Utbildare,Truck = VarUser).Truck)
and that works.

Was this reply helpful? Yes No
Anjac 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I found a solution
!IsBlank(LookUp(Truckar, EMail.Email = ThisItem.mail))

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anjac ,

In case you are using a people/group type column, indeed you need to select the Email property for this to work.

Was this reply helpful? Yes No

Join the conversation