cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cholst
Advocate III
Advocate III

Dataverse Search Rows Action results

With the search rows action can one use a compose step after to get the ID out of the Json? Specifically if you limit the row count to 1? I know I perform this compose action with a list rows action and it works great. For the List rows i'm using the following expression in a compose step to get the ID of the record found. 

 

body('List_Cases')['Value'][0]['incidentid']

 

Any help on what the expression might be to get the objectid out of the search rows results would be appreciated.  

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @cholst,

 

As far as I know the search results has the objectid property.

 

In an expression that would be something like:

body('Search_rows_(preview)')['Value'][0]['objectid']

 



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


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @cholst,

 

As far as I know the search results has the objectid property.

 

In an expression that would be something like:

body('Search_rows_(preview)')['Value'][0]['objectid']

 



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


Thanks for that advice. Only change i needed to make was the attribute. Below is what worked for me. 

body('Search_rows_(preview)')['Value'][0]['@search.objectid']

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,352)