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.
Solved! Go to Solution.
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']
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']
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']
User | Count |
---|---|
27 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
43 | |
30 | |
28 | |
24 | |
23 |