Forum Discussion
Retrieved SharePoint list items count
I have a flow which retrieves list items from a SharePoint list by passing a odata filter query (for eg Status eq 'Draft'). Is there a way to identify the count of the retrieved items and then use it in the next step ? I see that the correct values are being retrieved when I see the flow execution log.
There seems no way to get the count of items though !!
2 Replies
yes. if the SharePoint action you are using is Get Items, let's say you name it "GetMyItems", you can store the following Logic App (WDL) code @length(body('GetMyItems')?['value']). You can read my blog post https://sergeluca.wordpress.com/2017/04/26/using-the-azure-logic-apps-workflow-definition-language-in-microsoft-flow-part-1/ (see the last part).
Store "@length(body('GetMyItems')?['value'])" in a Compose action and reuse the compose action output where you want (don't forget the double quotes around the whle expression)
Hope this helps.
Cheers
Serge Luca
Yes I was using the Get items action. Thanks it worked :)
This has just given me a pointer to explore Logic app-WDL code more and how to use it in Flow !!
Cheers
