How to detect overlapping period of time in the Sharepoint list

(2) Share

Report

Posted on by ocin33

104

Hi,

I have created a Sharepoint list to book cars in my company but I cannot figure it out how to warn user that he has chosen the dates that are already chosen by someone else. I was thinking about some flow but do not have any idea hot to build the IF statement to check this. Can somebody help me?

List looks like this (date + time):

Thank you in advance,

Mateusz

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ocin33 104 on at

Like (0)

Report

I have finally figured it out. I have filtered data with all possible variants of interference. Than I have checked it for particular car and gave the condition of the length of array (more that one means that there is an interference of dates)

It works like a charm :)

Was this reply helpful? Yes No
DD-13011806-0 2 on at

Like (0)

Report

what did you put for your outputs in the filter query?

Was this reply helpful? Yes No