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

Occasional Visitor



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