Visitors App- Auto sign out after 12am (next day)

(0) Share

Report

Posted on by AH1231

Hi, I'm new to Power Apps. I've created a Visitors App, which uses a SharePoint form in the background.

When a user 'signs in' they will appear on the list enabled to 'sign out'.

When they 'sign out' they are removed from the list so the next person doesnt see their name.

However I need to add a function if someone forgets to sign out, that will automatically sign them out either after 12 hours or just the next day.

Any help is appretiated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AH1231

A simple way to do this would be to call the RemoveIf function to delete the expired rows from the SharePoint list. You could call this in the OnStart of your app or the OnVisible of the screen.

RemoveIf( YourSharePointList, SignInColumn < DateAdd(Now(), -12, Hours) );

Was this reply helpful? Yes No
AH1231 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, that's really helpful thanks- will that fully remove their information from the SharePoint list?

I may need the information from the list at a later date to see who has signed in/out

Thanks

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AH1231

Yes, that will fully remove the information from the SharePoint list. If you want to retain the information and you have a 'sign out' column, you can call the UpdateIf function to update that column rather than remove it.

UpdateIf( YourSharePointList, SignInColumn < DateAdd(Now(), -12, Hours), {SignOutColumn: Now()} );

Was this reply helpful? Yes No
AH1231 5 on at

Like
a
(0)

Report
Copy link

Link copied!

So currently there is a formula on the drop down menu:
Filter('Test Visitors Log AH', Status.Value="Signed In")

This shows anyone with the Status 'signed in' you click your name and it changes you to 'signed out'.

Ive tried adapting your formula to fit the names of my columns and got
UpdateIf( 'Test Visitors Log AH', Status.Value="Signed In"(Now()-12,Hours)
but that doesnt work.

I also tried your formula as
UpdateIf( 'Test Visitors Log AH', Status< DateAdd(Now(), -12, Hours), {Status: Signed Out()});

but that also doesnt work

Was this reply helpful? Yes No