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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,592)