SOLVED

Count Items in SharePoint List based on created by and date range, then send alert

%3CLINGO-SUB%20id%3D%22lingo-sub-922388%22%20slang%3D%22en-US%22%3ECount%20Items%20in%20SharePoint%20List%20based%20on%20created%20by%20and%20date%20range%2C%20then%20send%20alert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922388%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20creating%20a%20way%20to%20count%20the%20number%20of%20items%20in%20a%20SharePoint%20list%20that%20have%20been%20created%20by%20the%20same%20user%2C%20within%20a%20date%20rage%2C%20and%20then%20send%20an%20alert%20in%20flow%20based%20on%20that%20number%20being%20above%20a%20certain%20amount.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20able%20to%20count%20all%20items%20using%20flow%20and%20send%20an%20email%20alert%20containing%20that%20overall%20count%2C%20but%20haven't%20been%20able%20to%20figure%20out%20how%20to%20count%20based%20on%20created%20by%20and%20date%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20would%20be%20greatly%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-922388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-924520%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20Items%20in%20SharePoint%20List%20based%20on%20created%20by%20and%20date%20range%2C%20then%20send%20alert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-924520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426586%22%20target%3D%22_blank%22%3E%40lukem1100%3C%2FA%3E%26nbsp%3BWhy%20Flow%3F%20Try%20PowerShell.%20PS%20is%20object%20oriented%20and%20you%20can%20do%20much%20more%20and%20in%20a%20lot%20less%20time.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20Flow%2C%20you%20will%20have%20to%20query%20the%20list%20using%20Rest%20API%20for%20a%20specific%20date%20range%2C%20run%20a%20loop%20on%20allitems%20output%20to%20find%20unique%20users%2C%20their%20individual%20overall%20count.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi All,

 

I'm working on creating a way to count the number of items in a SharePoint list that have been created by the same user, within a date rage, and then send an alert in flow based on that number being above a certain amount.

 

I've been able to count all items using flow and send an email alert containing that overall count, but haven't been able to figure out how to count based on created by and date range.

 

Any ideas would be greatly appreciated!!

1 Reply
Best Response confirmed by lukem1100 (New Contributor)
Solution

@lukem1100 Why Flow? Try PowerShell. PS is object oriented and you can do much more and in a lot less time. 

With Flow, you will have to query the list using Rest API for a specific date range, run a loop on allitems output to find unique users, their individual overall count.