Retrieved SharePoint list items count

[Vipul Kelkar]

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]

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-i... (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

[#3]

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