[ad_1]
It is quite common requirement to get the Dataverse Table first row’s information from the List rows in the Power Automate.
In this article, will explain about the same.
Scenario: Get the list of all contacts which has Email address and show the Contact’s first row details (contactid, fullname and emailaddress1).
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, 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:...
[ad_2]
Source link