Prepare Quick Test Data Using Power Automate

Introduction

At times we used to prepare quick test data for customers to quickly demo. During that scenario, we can easily create some test records with Power Automate. As an example, I have showed how quickly create contact records.

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 Prepare Quick Test Data Power Automate Way and under Manually trigger a flow trigger choose the type of user input as integer  and provide the following values as

Name : TotalNumberofRecords

Value : 3

  as shown in the below figure.

Step 4

After Step 3, take an initialize variable and provide the following values

Name : TotalRecords

Type : Integer

Value : @{triggerBody()['number']} [Select the input variable that was given in Step 3 ]

as shown in the below figure.

Step 5

After Step 4, take Do until action and provide the following values

Variable : variables('TotalRecords')

Condition : is less than

Value : 1

as shown in the below figure.

Step 6

After Step 5, inside Do until, after condition select an action in Dataverse and select add a new row as shown in the below figure.

Step 7

After Step 6, on add a new row select the following values as

Table name : Contacts

Last name : concat('TestRecord',variables('TotalRecords'))

shown in the below figure.

Step 8

After Step 7, click on add an action and select Decrement variable and provide the following values as

Name : TotalRecords

Value : 1

shown in the below figure.

Step 9

After Step 8, save the flow and test it and observe the result that 3 new contacts gets created as shown in the below figure.

Note:

1. Make sure to handle cautiously Do until action, otherwise it will lead into infinite loops.

Conclusion

In this way, we easily create test data without writing code using power automate.