Skip to main content

Notifications

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

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.

codevenkat_0-1646573333933.png

 

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.

codevenkat_1-1646573344540.png

 

 

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.

codevenkat_2-1646573354126.png

 

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.

codevenkat_3-1646573362942.png

 

 

Step 5:

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

 as shown in the below figure.

codevenkat_4-1646573368199.png

 

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.

Comments

*This post is locked for comments