Reservation System App

[abah]

Hello everyone!

I am currently working on a reservation app to reserve seats at the office.

I was wondering if it is possible to do something like an airplane seat reservation system like below in Power Apps.

One idea was to do it with buttons but it will take a lot of time and the selected seat cannot be changed.

Any ideas on how to do it?

Thank you very much in advance!

[abah]

Another idea I found was to use the DateTime from Share Point in a form but I cannot connect the Data Cards to the seats, right? I wonder if there is a way for the user to be able to choose both date and time from a list or so and to connect it to the seats... any help would be highly appreciated.

[abah]

Hello!

I have another question, is it possible to change the seat number from 01 to 02? For example have 0101 on one screen and then 0201, 0202 and so on on the next screen. I really want to use this method for my app and now I have to make 5 different areas with seats with 5 different screens and I was wondering if it is possible to do so with this code and where can I change it to have distinguishing numbers for the different screens?

[v-bofeng-msft · Accepted solution]

Hi @abah :

Yes, but you need to set these 5 gallery separately.For example:

In Gallery1

"01"&ThisItem.No

In Gallery2

"02"&ThisItem.No

In Gallery1

"03"&ThisItem.No

Best Regards,

Bof

[abah]

Thank you for your reply but where in the code should I write that?

Set(TheVar,"01");/*TheVar is my custom variable*/
Set(UserName,User().FullName);/*UserName is my custom variable*/
If(
IsBlank(
LookUp(
ReservationApp,
Title = Text("02" & ThisItem.Value) & "01" &&
((DateTimeValue(FromInput.Text) >= From && DateTimeValue(FromInput.Text) <= To) || (DateTimeValue(ToInput.Text) >= From && DateTimeValue(ToInput.Text) <= To) || (DateTimeValue(FromInput.Text) >= From && DateTimeValue(ToInput.Text) <= To))
)
),
Patch(
ReservationApp,
{
Title: Text("02" & ThisItem.Value) & TheVar,
Office: Dropdown2.SelectedText,
From: DateTimeValue(FromInput.Text),
To: DateTimeValue(ToInput.Text),
User: UserName
}
)
)

[abah]

Hello!

Thank you very much for your reply, I tried with 

"01"&ThisItem.Value

but then I had three numbers in the list. The option that worked to have a 02 like I wanted and the seat number like 01 was like the one below but then I cannot properly see the seats in the DataTable below. Any ideas where I could be wrong? Sorry for the many questions.