Forum Discussion

lukem1100's avatar
lukem1100
Copper Contributor
Oct 21, 2019
Solved

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

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!!

Microsoft Flow
sharepoint
  • mrehmat's avatar
    mrehmat
    Oct 21, 2019

    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.

  • mrehmat's avatar
    mrehmat
    Brass Contributor
    Oct 21, 2019

    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.

Resources