Unanswered

How to make time slots not available or remove from the list once selected by an end user?

(0) Share

Report

Posted on by MRamadan90

I have created a Power App from a SharePoint online list that list has available time slots to reserve each 4 mins and I was wondering how can I make these time slots not available once reserved or selected?

Power App 2.JPG Power App.JPG

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@MRamadan90

You're going to need to record in your list that the time is taken. From your image of the list, there does not appear to be any status or indicator that the time is taken.

If you have that in your list, then you can then just filter out the items that are taken.

I hope this is helpful for you.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@MRamadan90
I guess "Reservation Time" is either a choice or lookup field. Could you confirm?

So when somebod selects a Date in "Reservation Date" you need to get all items in your list which have this Date set. Based on that we know which timeslots are already used.

Was this reply helpful? Yes No
MRamadan90 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerRanger it's a choice field, so is there away to make it disappear from the choice list once selected?

Was this reply helpful? Yes No
MRamadan90 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes could you please tell me how will I automatically record that a field is taken once an end user select it? can you please explain more? Thanks in advance.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MRamadan90 ,

Please try and:

1. Set OnChange of the 'Reserve Date' DatePicker with below to create a collection with reserved time based on the selected date:

ClearCollect(colResTime,AddColumns(Filter('Online Flu Sign up', 'Reservation Date' = ReservationDateDataCardValue.SelectedDate).'Reservation Time'),"ResTime",'Reservation Time'.Value).ResTime)

2. Set Items of the Combo box to:

Filter(Choices('Online Flu Sign up'.'Reservation Time'), !(Value in colResTime))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
MRamadan90 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Randy, thanks in advance for your help.
I have added a choice column to my sharepoint list with the values (Available /Booked), the other fields are, Staff name: Text, reservation date: date field, reservation time: choice field, locations choice field.
What conditional Syntax can be used to show Available when time slot is not selected and booked when it's selected and how can I filter it out?

Was this reply helpful? Yes No