cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to filter when 2 result are empty?

When typing in a username in the searchbox it display the information as expected.

 

I have a gallery containing as 'Item': 

If (txtInputEmployee.Text<>"", Filter(Office365Users.SearchUser({searchTerm:txtInputEmployee.Text,top:10}),AccountEnabled=true))

 

I have 4 labels in the gallery:

 

DisplayName

JobDescription

Mail

MobileNumber

 

Basicly the App works good but showing too many result, I would like to add in the same filter as above that when DisplayName AND MobileNumber is empty to not show it as a result in the gallery..... But I can't get this thing working...

 

Any ideas?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,216)