Need help with a filter

(0) Share

Report

Posted on by MrAutomate

206

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

Categories:

Building Power Apps

clockout.PNG

I have the same question (0)

All responses (5)

Answers (1)

MrAutomate 206 on at

Like (0)

Report

sharepoint backend, sorry I forgot that piece..

Was this reply helpful? Yes No
MrAutomate 206 on at

Like (0)

Report

attaching jpg also

clockout.JPG

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
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) )

Was this reply helpful? Yes No
MrAutomate 206 on at

Like (0)

Report
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!

Was this reply helpful? Yes No
MrAutomate 206 on at

Like (0)

Report

got it :

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

thanks !

Was this reply helpful? Yes No