Flow emails

[NichelleGunby]

Hello All,

Hoping anyone can help! I have two lists within Sharepoint that I need to add a flow trigger. So once the list get to a certain number say 150 items in the list. I will need a special email sent to everyone that adds an item to the list after 150. Is there a trigger out there or is there a way for this to be done? I hope I explained this coherently! lol Any help or advice would be great appreciated. Thanks in advance!

[RobElliott]

Hi @NichelleGunby, yes you can count the number of items returned from a Get Items action as in the images below. One thing you must do though is that in the 3 dots at the top right of the Get Items action, in the settings make sure you turn on pagination and set the maximum number of items, otherwise the Get items will only return 100 items so the count won't work above 100.

1. the trigger will be "When an item is created"
2. add a Get items action.  In this example I've renamed it to GetList.
3. add a Compose Control and in the Inputs box add length(body('GetList')?['value'])
4. add a Condition control and select the output from the Compose at 3 above - is greater than - 150
5. In the If yes green channel add a send an email action. Leave the If No red channel empty.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.