SOLVED
Home

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
lukem1100
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
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies