Get First Row from Dataverse Table in Power Automate

It is quite a common requirement to get the Dataverse Table's first row's information from the List rows in Power Automate.

This article will explain the same.

Scenario. Get the list of all contacts with an email address and show the contact's first row details (contact, full name, and email address1).

Follow the below steps to get the Dataverse first row data from List rows in Power Automate.

Step 1. Create a simple Manual flow.

Step 2. Add Dataverse -> List Rows, and get all the contact rows where Email contains data.

Table name	Contacts
Select columns	contactid,fullname,firstname,lastname,emailaddress1
Filter rows	(emailaddress1 ne null)

Step 3. Create a compose action and enter the below expression to get the first record details.

Contact Id: 
first(outputs('Get_Contact_records')?['body/value'])?['contactid']

Full Name: 
first(outputs('Get_Contact_records')?['body/value'])?['fullname']

Email: 
first(outputs('Get_Contact_records')?['body/value'])?['emailaddress1']

Step 4. Click on Test.

Step 5. Select Manually and Click on Test.

Step 6. Click on Run flow.

Step 7. Click on Done.

Output

I hope you have followed all the steps and got the Dataverse first-row details in Power Automate.

Please like and share your valuable feedback on this article.