Power Automate Fundamentals # 50: Get Record Count for a List  in Power Automate

Introduction:

In few scenarios when working on List of records for a given entity it is needed 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.

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.

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.

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.

Step 5:

After Step 4, save and run the test and you should see record count

 as shown in the below figure.

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 length function on list action to get record count easily.

One thought on “Power Automate Fundamentals # 50: Get Record Count for a List  in Power Automate

  1. Pingback: Rewind January 2022 – Common Man Tips for Power Platform, Dynamics CRM,Azure

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s