Dynamics CRM Field Service Journey 3 – Get Records Counts using List Records action in Flow

When field service IoT Alert automation we create work order automatically using MS Flow without coding. In that record creation implement mechanism to set work order number (number should be unique) by Flow. We retrieve existing work orders list based on filter criteria and generate work order number based on the number of records retrieved by list action.

Follow following steps to get count of records using List records control

Note: User can change filter condition to meet requirement otherwise flow will become less performance if retrieve all the work order records

Use Length function on lookup records body values then add 1 to get next number

“add(length(body('Get_Last_Work_Order_Number')?['value']),1)”

How to automate IoT Alert to work order will be posted in next blog post