Hi All:
New to Power automate.
I've built a flow that queries MSGRAPH for some AD User Data. I have a select filter to limit the current MSGRAPH query to the data element i need.
What I cannot figure out is how to get the one value I need out of the results.
Here's the output I have:
{
"@odata.context": "https://graph.microsoft.com/beta/$metadata#users(employeeId)/$entity",
"employeeId": "21884",
"id": "3917a411-04b5-48c9-ae8f-0c81c728bebf"
}
I need to be able to parse this ODATA result (output) to get 21884, the employeeID.
This output comes from an HTTP call to MSGRAPH to query a single ad user to return the EmployeeID.
So what I need to do in the next step of the flow is to take that OUTPUT and get the VALUE 21884.
Is there a function to sort of 'split' the odata output into a key/value pair? If not, it would seem then that I will need to use a function to SPLIT the string manually by a comma and then split the second value ("employeeId:21884") to get at the value I need, which is 21884.
Really hoping for a tip on how to extract. Just completely new to ODATA and beginner with Power Automate. Thank you in advance.
