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

Need help with a filter

Hi- I have a simple timesheet table.  ClockIN, Clockout, teammate, date.

 

I have a form with a data table that displays only people who clocked in today -if they forgot to clock out from another day, they need to talk to the manager.  This filter solved that fine...

 

Filter(tSheets, Text(ClockIn, DateTimeFormat.ShortDate) = Text(Today(), DateTimeFormat.ShortDate))

 

I am having trouble figuring out the syntax on how to add to that filter condition .  I  only want the data table to show people who have NOT clocked out.

 

ClockedOut is a date time field, standard, not friendly format.

 

Thanks for help on this 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @MrAutomate 

 

You should be able to return people who have not clocked out by filtering on empty ClockedOut values.

This is how the formula would look:

Filter(tSheets,
       IsBlank(ClockOut)
)

View solution in original post

5 REPLIES 5
Highlighted
Frequent Visitor

sharepoint backend, sorry I forgot that piece..

Highlighted
Frequent Visitor

attaching jpg also

Highlighted
Super User III
Super User III

Hi @MrAutomate 

 

You should be able to return people who have not clocked out by filtering on empty ClockedOut values.

This is how the formula would look:

Filter(tSheets,
       IsBlank(ClockOut)
)

View solution in original post

Highlighted
Frequent Visitor

timl - thanks, that does work, but how do I use both filters.  So, imagine a user did not clock out yesterday, I have the original filter that prevents them from clocking out from a previous day.

 

how do I use

 

Filter(tSheets,
       IsBlank(ClockOut)
)

and 

 

Filter(tSheets, Text(ClockIn, DateTimeFormat.ShortDate) = Text(Today(), DateTimeFormat.ShortDate))

 

tnx!

Highlighted
Frequent Visitor

got it :

 


Filter(tSheets, Text(ClockIn, DateTimeFormat.ShortDate) = Text(Today(), DateTimeFormat.ShortDate),IsBlank(ClockOut))

 

 

thanks !

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,298)