cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
antc2
Frequent Visitor

first() not working

When I create Power Automate flows for the List Rows Dataverse connector and I know I will only get 1 row returned I have always used a compose action then such as:

 

first(outputs('List_rows')?['body/value'])?['regardingobjectidname']
 
I seem to be now getting numerous errors when flows are edited or new such as expecting an array and received object.
 
I then tested returning multiple rows and it doesn't error it just remains empty.
I added a compose to prove there is a values returned which there is.
 
Any ideas?
1 REPLY 1
Expiscornovus
Super User
Super User

Hi @antc2,

 

Just to double check. Are you looking for the name of the entity which is used in the regarding field, or the name of the record itself?

 

Have you tried either (Regarding object entity name):

first(outputs('List_rows')?['body/value'])?['_regardingobjectid_value@Microsoft.Dynamics.CRM.lookuplogicalname']

 

or (Regarding object record name)

first(outputs('List_rows')?['body/value'])?['_regardingobjectid_value@OData.Community.Display.V1.FormattedValue']

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,865)