Unanswered

Extracting Key data from SQL Query

(0) Share

Report

Posted on by Community Power Pla...

Hi Guys,

I'm trying to grab some information from my SQL Database to be used in a later part of the flow. The issue is that when I run the query I keep getting junk such as brackets and it causes the flow to fail: here is a screen shot:

flow picture1.JPG

I subseqently make the result of that query a variable and use it in a later part of the flow, but it fails as I just need the IdentityProviderUserID.

Is there a way to only select the result of the identityprovideruserid?

Thanks guys!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @Anonymous ,

Please try using Parse JSON to get the value of the specified property.

Generate the schema by using the contents of Query Results as the sample payload.

Then, Body returned by Execute a SQL query action is filled in Parse JSON action as Content.

This way you could directly reference the properties in result.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bacao-msft that solution worked perfectly, thanks a lot for your help!

Was this reply helpful? Yes No