Unanswered

Adding in date / time selection into my form but stopping double bookings

(0) Share

Report

Posted on by AB21

So I have used

length(body('Get_items')?['value'])

In a condition which stops more than 3 people (or how many) booking the room. How would I include the date and time within this condition to stop say 3 people booking on that particular date / time.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

eyau 109 on at

Like (1)

Report

Hello,

You can add another condition with the "Add" option below your expression to check if there are multiple people booking on that specific date/time. If there is only one date/time to check, then 1 condition would work. However, if you want to check multiple date/times at once, then you have to run an 'Apply to each' for your People values within an 'Apply to each' for your datetime values, running a condition that will check for duplicates. In my experience this process is tedious for Power Automate to process as well as being prone to timing out.

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

Hi @eyau How would this look?

Was this reply helpful? Yes No
eyau 109 on at

Like (0)

Report

Hi @AB21,

So I don't exactly know what your full flow looks like or where you are referencing your data values, but I created a simple set up based on some assumptions I made from your initial post.
Here's a screenshot of the flow. Basically it's an 'Apply to each' for SharePoint People values within an 'Apply to each' for particular date values (DateArray). This means that for every date, it checks every person's booking date to see if it matches.

With this condition, I increment an integer variable by 1 if the dates match. By doing so, you can check if that number is over 3, meaning that 3 or more people booked that same day.

Now for this flow, I'm not sure where you are referencing these "particular date / times," but just replace my DateArray variable with that content and it should work fine.

Hope this helps!

Was this reply helpful? Yes No