Announcements
So I have used
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!
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
