This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello Folks,
I've a recurrence trigger followed by Execute store procedure (V2) action.
When I run that SP it will give an ID.
I'm trying retrieve the value(only value) from that Action.
I'm getting like [{"InvoiceID":"62134"}] But I want the value only. i.e. 62134
How can I achieve this? Is there any possibility to do this via expressions(fx)
Hello @Ramanarajan D ,
I hope the answer helps. Please let me know if you have any further queries.
Please accept as Yes if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.
I think you can use "Parse JSON", more info:
https://stackoverflow.com/questions/56244766/logic-app-read-property-of-json-stored-in-variable
Yes. But it looks complex. Is there any chances to achieve this via expression?
So that I can get the value in single action.
@Ramanarajan D Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.
If Stored Procedure in your workflow always return a single value then you can use the below expression to pull the InvoiceID
body('Execute_stored_procedure_(V2)')?['resultsets_InvoiceID']?[0]?['InvoiceID']
If your stored procedure returns multiple values, then as suggested by Wilko van de Velde you need to use ParseJSON and also Foreach loop to pull the InvoiceID value.
Feel free to reach back to me if you have any further questions on this.