List Restriction for Same Date and count the text reacurence in another coumn

Occasional Visitor

Hi,

 

I want to have validated for submission or use Microsoft Flow to achieve the below.

 

There are 4 columns in the List " Office, Date, Department & Employee" 

 

I want to achieve if the user selects the same date for Example "20/10/2020" and the same office "XYZ" the total count of submission should not go above 30.

 

Similar Office "ABC" has a count restriction of "24" and "DEF" office has a count restriction of "33" on a specific date.

 

0 Replies