Allow book a desk only

(0) Share

Report

Posted on by kinghnvn

Hi all,

I have a desk map and currently I'm able to book multiple desks with different slot time (startTime to endTime)

I want to set up to allow book a desk only. Could you please help?

DeskBooking SharePoint list: Title (text), StartDateTime (mm/dd/yyyy hh:mm:ss), EndDateTime (mm/dd/yyyy hh:mm:ss)

My Book Button

DisplayMode

If(
!IsBlank(
LookUp(
DeskBooking,
(startTime >= StartDateTime && endTime <= EndDateTime ||
startTime <= StartDateTime && endTime >= EndDateTime ||
endTime > StartDateTime && endTime < EndDateTime||
startTime > StartDateTime && startTime < EndDateTime) &&
Title = MainGallery.Selected.Title
)
),
DisplayMode.Disabled,
DisplayMode.Edit
)

@StalinPonnusamy

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @kinghnvn

Are you expecting to allow the user to book for a single time slot for a given day?

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

No. User can book at any time of the day if it doesn't conflict, but can only book a desk

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @kinghnvn :

Do you want to restrict users to only book one desk at a time?

Could you please show me how did the user book the desk? What is the code?Can you please introduce your APP in detail?

Best Regards,

Bof

Was this reply helpful? Yes No