Share
ReportHey there -
Like many companies, my own has moved to a hybrid working arrangement where people can reserve a desk (a "hotdesk") and come in.
We're currently using Microsoft Bookings for this - I've created a bunch of Shared Inboxes to represent the various desks you can book (as Services). Users can reserve their desks online through the Bookings app.
I've previously built a Flow where every day at 8:00 AM, our Admin Team gets a daily overview email.
I'm looking for guidance/ideas on building two further Flows:
Limit Capacity
Our office has 32 desks available to be booked, but we're looking to limit that to 22 (maximum occupancy according to current rules). Obviously the easiest solution would be to turn off the other 10 (ha!), but that's not quite what my company is looking for.
In the meantime, I think the best solution I can come up with is to set up a Flow to trigger an email to our Admin Team (or whoever) when 22 Bookings for a day are reached.
FYI that we have one multi-day Service available (i.e. someone can reserve for 5 consecutive days), but it's only recognized as a booking on Day 1, not on Day 2-5.
Cancel Bookings
The other Flow would be to cancel a booking if someone doesn't show up. I'm not sure if there's a way to trigger an email to the user? For instance, they get an automatic "Approve"-style email 10 minutes after their booking time, and they MUST "check in" (i.e. approve) to maintain the booking. Otherwise the booking is cancelled.
I think this one is achievable in Power Automate by pulling a few things together. But regardless, I want to double-check that these two Flow ideas aren't just pie-in-the-sky ideas 🙂
Thanks for any insights on how to start going about these two!
Best,
Nick
All responses (
Answers (
592
