Gallery Filter Shows empty

[venka91]

Hi there,

I am trying to Filter by Gallery based on a Textbox. When i enter ID, i would like to show the filtered result in gallery. If the textbox is empty, gallery will show all the records.

I am writing the below, though i do not see any errors, when i do a search, Gallery item comes blank. Any ideas.

Filter(MyHelpDesk,'Created By'.Email = User().Email || ID = Value(txtsearch.Text))

[cwebb365]

If you type just MyHelpDesk in Items of the gallery do you get results?

[venka91]

Yes, I get it.

If my Formula is as below :

Filter(MyHelpDesk,'Created By'.Email = User().Email || ID = Value(txtsearch.Text) )

If i use && i see Gallery Blank.

[Himanshu_90677]

Try 'Or' function instead of &&

[cwebb365]

You have to be careful using User().Email because if at any point your primary e-mail is different than you're domain login then it won't match since Powerapps User().Email is actually the FQDN of your login and not your e-mail address. My guess is this might be the case here when using &&. 

Create a label and put in Text Field User().Email and then another label Lookup(MyHelpDesk,ID = OneofYourWorkOrderIDs).'Created By'.Email

 This will let you compare the two. 

If those seem to match, case sensitivity could be the mismatch too. I always wrap Lower(User().Email) and Lower('Created By'.Email) to make sure of match. I can't remember thou if doing that causes delegation warning so keep an eye on that.  

[venka91]

Ok, i tried and altered the formula as below.

Filter(MyHelpDesk,'Created By'.Email = User().Email && IsBlank(txtsearch)|| ID = Value(txtsearch.Text) )

Now i get all the tickets raised by me and also i do a search on the text box it showing.

But one weird thing, even i enter the ticket number raised by other, Gallery is showing the ticket which should not be the case.

Filter(MyHelpDesk,'Created By'.Email = User().Email && IsBlank(txtsearch)|| ID = Value(txtsearch.Text) )

The email id which i am logged in the same ID which i use to raise the ticket. I am clear in this part.

You can see my ticket is getting filter correctly.

But when i type 4 in the text box Gallery is also showing the ticket which is not raised by me.

[cwebb365]

Ignore this. Obviously you're email is matching or you wouldn't see those 3 records in the screenshot. I didn't see this before typing that reply. So when you click the 1 in the gallery, what is it's Text set too on that label? ThisItem.ID? Or is it possibly using a different column?  The formula you are using should work with && no problem. Make sure to triple check the name of the search textbox that it's the one in the filter formula and not another from somewhere else in the app. 

1. Check textbox name. 

2. Check Items make sure it matches. 

[cwebb365 · Accepted solution]

Wrap your Or's in Parenthensis like so: 

Filter(MyHelpDesk,'Created By'.Email = User().Email && (IsBlank(txtsearch)|| ID = Value(txtsearch.Text)) )

[venka91]

oops. a parenthesis changed whole logic. Thanks. It worked.