Get Record Count For A List In Power Automate

Introduction

In a few scenarios when working on a List of records for a given entity you may need to find out the count of total records present in that table to perform certain manipulations. Here length function in power automate can be used to get record count for a given list. As an example, contact table was considered.

Step 1

Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the left-hand side as shown in the below figure.

Get Record Count for a List in Power Automate Figure 1

Figure 1

Step 2

After Step 1, Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.

Get Record Count for a List in Power Automate Figure 2

Figure 2

Step 3

After Step 2, name the flow as Get Record Count – List add a new action Dataverse -> List and name it as List rows - Get Contacts and provide the following inputs

Table name : Contacts

 as shown in the below figure.

Get Record Count for a List in Power Automate Figure 3

Figure 3

Step 4

After Step 3, take another action and name it as Initialize variable - Get Record Count and provide the inputs as

Name: Record Count

Type: Integer

Value : length(outputs('List_rows_-_Get_Contacts')?['body/value'])

 as shown in the below figure.

Get Record Count for a List in Power Automate Figure 4

Figure 4

Step 5

After Step 4, save and run the test and you should see record count as shown in the below figure.

Get Record Count for a List in Power Automate Figure 5

Figure 5

Note:

  1. Make sure to save and run the flow whenever you try expressions.
  2. Best Practice is to provide odata filter for list, but as my focus area was count I have not given any filter.

Conclusion

In this way, we can use the length function on list action to get record count easily.