Unanswered

How to check for conflict booking

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

Can anyone advise how to check for conflict booking? This is for a room booking calendar, I want to filter the room if no booking yet for the selected date and time

I power apps, I have selection for start date and end date as well as selection for start time and end time.
Since I'm capturing the date and time, I set startTime and endTime as below:
Set(startTime, sDate_2.SelectedDate, DateTimeFormat.ShortDate) &" "& TimeValue(Text(sTime_2.Selected.Value)));
Set(endTime, eDate_2.SelectedDate, DateTimeFormat.ShortDate) &" "& TimeValue(Text(eTime_2.Selected.Value)));

I want to be able to filter the available rooms based from the startTime and endTime. I'm using this formula so far:

Filter(
Rooms,
Not(
Title in Filter(
'SharePointCal',
StartDateTime > startTime && EndDateTime < endTime
|| StartDateTime > startTime && EndDateTime > startTime
|| StartDateTime >= startTime && EndDateTime > startTime
|| StartDateTime < endTime && EndDateTime < endTime
).Rooms))

This allows me to books but not check for conflict. Any idea how to fix this, please? Thanks!

Best regards,
Vanessa

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

PaulD1 2,914 on at

Like (0)

Report
Copy link

Link copied!

How many bookings might you hold in your list. I don't think your formula is going to delegate, so even if you can work out your filters, they will stop working correctly once you reach the delegation limit (max of 2000).

You might want to try using the 'Book a room' template in the Power Apps gallery which uses Outlook calendars rather than SharePoint lists. I think this approach will likely be superior for your needs.

Was this reply helpful? Yes No
Vanessasec 23 on at

Like (0)

Report
Copy link

Link copied!

Hi Paul,

I have a flow the deletes old booking so I make sure it's within the delegation threshold. I prefer using SharePoint list. Hopefully someone can help me find a solution to check for conflict booking. Thanks!

Best regards,
Vanessa

Was this reply helpful? Yes No