Unanswered

Office 365 Filter & Search box with IF Statements

(0) Share

Report

Posted on by dazroo

Hi,

I've created a User Directory which pulls their location from a SharePoint list with a People column linked to O365 to match the user up with their photo. I'd like to link the Gallery to a Search and a Filter, I've written the following... but I get a Boolean error on the below code...

Filter(
AddColumns(
'People Locations',
"UserPhoto",
If(
// check if the the user has an email and a profile picture
!IsBlank(FullName.Email)
And Office365Users.UserPhotoMetadata(FullName.Email).HasPhoto,
// get the profile picture
Office365Users.UserPhotoV2(FullName.Email)
)
),
Office365Users.SearchUser(
{
searchTerm: Trim(TextInput2.Text),
top: 999
}
),!IsBlank(City))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dazroo ,

The place I marked in red is redundant in the formula, and deleting it the error will disappear.

Best Regards,

Bof

Was this reply helpful? Yes No
dazroo 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thank you for your reply, that solves the error but doesn't help in what I am trying to achieve. Removing the code complete removes the link to the search box I am trying to get working.

I need the search box to find the users or search by location from the SharePoint list 'People Locations' and show the results complete with the users picture pulled from the users O365 profile.

Was this reply helpful? Yes No