Unanswered

Make "clock in" appear when "Clock out" was the last button pressed

(0) Share

Report

Posted on by CodyO

391

Hello! I have posted this question before, but after a month more experience with powerapps, I want to address some issues I am having with this.

The goal is to populate a clock in button when clock out was the last button pressed OR when there is no records for the current day.

In my previous fix for this it worked intermittently. Randomly the clock in button will not work as expected, meaning it won't show up after clocking out, leaving the app, and reopening the app. I'd like to find a solution that will work consistently.

I was trying to do something like this, but it is showing that I have a table where it's expecting a Boolean. This is on the Visible property of the clock in button. Anyone have any suggestions? For context TimeTracker is a sharepoint list. Title is the users email address.

If(Filter(TimeTracker, UpdatedActivityDateTime=Today(), glbUser=Title), IsBlank('Time Out'), true, false)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

RogierE 875 Moderator on at

Like (0)

Report
Copy link

Link copied!
The output of the Filter function is a table, that is not what the If function would expect as input. It expects a boolean value (true/false). This is the outcome of an Isblank function, so you're close to the solution but not close enough 🙂
I guess your code would work better like this:
If(IsBlank(Lookup(TimeTracker, And(UpdatedActivityDateTime=Today(), glbUser=Title)),'Time Out')), true, false)

But now that you know that a Boolean is a value that is either true or false, I hope you will see this further improvement of your code (less is better). You can just fill this in your Visible property:
IsBlank(Lookup(TimeTracker, And(UpdatedActivityDateTime=Today(), glbUser=Title)),'Time Out'))

Enjoy!

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
CodyO 391 on at

Like (0)

Report
Copy link

Link copied!

@RogierE Thank you for sharing your knowledge and experience! It appears the code you provided is showing an error. I was able to get it fixed most the way on my end, however it is claiming that "Time Out" is not recognized. I am unsure why this is happening. I refreshed my data source, and verified that the column I am pulling data from matches (Capital T&O, and space between the two words). Is there another reason it wouldn't detect it that I am missing?

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report
Copy link

Link copied!

This is a SharePoint list column is it? Could it be that the name has changed from the original name? There is one very nasty thing to know about SharePoint Lists and that is that if you rename a column, the displayname changes, but the actual name stays the same. If a column name has changed, you still need to refer to the original name in PowerApps. You can check out the original column name, by going to your list in the SharePoint, then to List Settings (at the gearwheel), and click the column in that screen. You'll get to something like this:
You can see here that the new name is Changed, while the old name as shown in the address bar is Modified.
In this example the name that I would need to refer to is Modified

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
CodyO 391 on at

Like (0)

Report
Copy link

Link copied!
@RogierE This is a sharepoint list, I took a look and this is what I see
So I figured it would be "TimeOut"; I am still getting the same issue of it not being recognized
IsBlank(Lookup(TimeTracker, And(UpdatedActivityDateTime=Today(), glbUser=Title)),TimeOut))
@

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report
Copy link

Link copied!

The screen shot doesn’t show me the column name…
But you can try another approach. If you select the word Timetracker in your formula bar, you can see the actual contents of the list and how it is received by the App. Scroll right until you see the TimeOut column and double check it’s name in the list.

Was this reply helpful? Yes No
CodyO 391 on at

Like (1)

Report
Copy link

Link copied!

@RogierE I tried that other approach, and it is showing as TimeOut! Lesson learned - I can view table details in a way I didn't know

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report
Copy link

Link copied!
Good that you learnt. And I guess i had a typo in sharing the code. There is a bracket top many behind Title . Thats why you still received an error . I guess this is the right code:
IsBlank(Lookup(TimeTracker, And(UpdatedActivityDateTime=Today(), glbUser=Title),TimeOut))
Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
CodyO 391 on at

Like (0)

Report
Copy link

Link copied!

I gave it a test, and it wasn't quite working correctly, so I attempted to change the code to !IsBlank referring to TimeOut. This sorta worked, but I was left with the same problem of Clock In not appearing/dissapearing at the correct times. 1st screenshot I am posting is with your code, 2nd is with !IsBlank, 3rd is with !IsBlank after clocking in.

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report
Copy link

Link copied!
Okay, let's get back to your original requirement.
"The goal is to populate a clock in button when clock out was the last button pressed OR when there is no records for the current day."
The formula only covered the first part, and then with !IsBlank
But for the second part you should add an extra check:

Or(!IsBlank(Lookup(TimeTracker, And(UpdatedActivityDateTime=Today(), glbUser=Title),TimeOut)),CountIf(TimeTracker,And(UpdatedActivityDateTime=Today(), glbUser=Title))=0)

And then one more step: i personlly find they above code ugly and complex. There is a reason why they say that "code is poetry". And that is because you should revisit and rewrite it until it is beautifully simple. So I re-thought your requirement. You could als say as an alternative requirement "do not show as long as there is an open task for the user" which would lead to a simpler piece of code:
CountIf(TimeTracker,And(UpdatedActivityYime=Today(),blbUser=Title,IsBlank(TimeOut)))<1

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No