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

%3CLINGO-SUB%20id%3D%22lingo-sub-1802924%22%20slang%3D%22en-US%22%3EList%20Restriction%20for%20Same%20Date%20and%20count%20the%20text%20reacurence%20in%20another%20coumn%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1802924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20have%20validated%20for%20submission%20or%20use%20Microsoft%20Flow%20to%20achieve%20the%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%204%20columns%20in%20the%20List%20%22%20Office%2C%20Date%2C%20Department%20%26amp%3B%20Employee%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20achieve%20if%20the%20user%20selects%20the%20same%20date%20for%20Example%20%2220%2F10%2F2020%22%20and%20the%20same%20office%20%22XYZ%22%20the%20total%20count%20of%20submission%20should%20not%20go%20above%2030.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilar%20Office%20%22ABC%22%20has%20a%20count%20restriction%20of%20%2224%22%20and%20%22DEF%22%20office%20has%20a%20count%20restriction%20of%20%2233%22%20on%20a%20specific%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1802924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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