Name from list in Gallery, On button press remove name

(0) Share

Report

Posted on by AndyPowerAppNew

519

Heloo, Wondering if you can help,

I have a gallery list which is built up from a list on sharepoint; when i press 'signout' button on another screen, i would like it to update the list which the checkout time and date which is does, but also remove the name from the gallery list, as this list is like a evac list register so know who is in the building.

This is the visitor list, without checkout filled in, see below

We then go to a 'signout' screen, as below

Then the 'Sign Out' button is pressed, it then fills in the checkout column (this is what i want it to do), please see below;

Please note that the 'checkout' column is filled in, this action was done on the button press.

This is another screen, which is the 'evacuation list'

So as the 'checkout' column as been filled in on the sharepoint list, i would like this record not to show in this list, because the user has 'signout' the name should not show in this list because they are not in the bulding. however the sharepoint would still need to show the complete record.

I think, i would need a column on the visitor list something like "signedOut" then when the 'SignOut' is pressed it will update this column with 'Yes' then it will update update the 'Checkout' column has it already does, but also remove or strike through the name on the Evacuation list, but the full record would still need to show on the sharelist list, as below

Extra info: This is my gallery items:

Thank you very much, i really value everyones help.

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AndyPowerAppNew,

When signing out, the previously empty field 'CheckOut' will be filled in with the date. In this case you could filter your visitor list to only show the records with a blank CheckOut field.

To fill the CheckOut field, It looks like the signout button is part of a gallery so you will have to update that record (OnSelect of the button):
Patch(ListName, ThisItem, {CheckOut: Now()}) //Alternatively Patch(ListName, LookUp(ListName, ThisItem.ID = ID), {CheckOut: Now()})
Adjust the ListName and column name where needed.

To only show the visitors that are not signed out yet, you could use:
Filter(VisitorEntryList, CheckOut = Blank())

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @LaurensM , thank you , where would I put these formulas? Would the go on the list box , it’s if user signout in doesn’t show on the listbox , sorry about my understanding

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@AndyPowerAppNew, the Patch() statement will have to be added to the OnSelect of the Sign Out button.
The Filter() would be added to the Items property of the gallery that needs to show only the visitors that are still signed in.

I hope this helps!

Was this reply helpful? Yes No
AndyPowerAppNew 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM ,
I have sorted most, its just the gallery searchbox i need to do.

Thank you

Was this reply helpful? Yes No