Filter results based on criteria from user

After stumbling into this post, I decide to try integrating it to my app so user can filter data based on criteria they specified. I want the user to specify a start date, end date and the system has there user email. With this criteria filter the table "Expenses" to see which points fit that criteria. But I cant seem to make the formula work. This is what I have so far: 

 

 

FILTER("Expenses",  
  AND(
    OR(  ISBLANK([_THISROW].[Employee ID Input])   ,  CONTAINS (Expenses[Employee ID],[_THISROW].[Employee ID Input])),
    OR(  ISBLANK([_THISROW].[Start Date])   ,   [Date] >= [_THISROW].[Start Date]  ),
    OR(  ISBLANK([_THISROW].[End Date])   ,   [Date] <= [_THISROW].[End Date]  )
  )
)

 

 

While it does filter correctly for start and end date, it doesn't filter for Email. 

Gab0c_0-1719848982040.pngGab0c_1-1719849075505.png

As you can see the email says Amanda but I'm Gabriel.  Any help to make this work by filtering the email correctly will be appreciated.

 

Solved Solved
1 7 372
1 ACCEPTED SOLUTION

If you want to filter with the app user, would that part be then just as simple as..
[Employee ID]=USEREMAIL()?

View solution in original post

7 REPLIES 7
Top Labels in this Space