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
Share Button added to the Toolbar!
HotCakeX in Discussions on
13 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
Date format in Stream
Dave Pyett in Microsoft Stream Forum on
3 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Sharing an excel sheet public link
shunde3 in Microsoft Teams on
6 Replies