Answered

Power Automate Error on SQL Stored Procedure JSON Parse

(0) Share

Report

Posted on by IncursioML1

Hi Everyone

In trying to create process that moves the results of a SQL Stored Procedure (On premise) into a SharePoint List, I'm running into a problem during the 'Apply to Each' process. I see here that all other steps have passed but get that Table1 error of Type 'Null'. Is there something I'm missing here after parsing the JSON Object?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

Hi @IncursioML1 ,

Have a look at this post when trying to parse JSON.

Thanks

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (1)

Report
Copy link

Link copied!
Thanks, I definitely knew it had to do with the SQL stored procedure coming up with some extra syntax to put into the JSON Schema. Below is a screenshot of the flow for any others pulling their hair out.
It really isn't intuitive as it should be on the flow there, but it is what it is.
I am curious though why on the first compose statement, couldn't I theoretically bypass this by going directly into the table to get the array instead of doing that additional substring logic?
i.e. The 'ResultSet' expression is this

outputs('Execute_stored_procedure_(V2)')?['body/resultsets']

but couldn't I just use this instead of all that parsing logic?

outputs['Execute_stored_procedure_(V2)')?['body/resultsets/Table1']

In any case, thanks very much!

Was this reply helpful? Yes No
LeightonG 25 on at

Like (0)

Report
Copy link

Link copied!

Thank you IncursioML1!
Your method works a treat!

Was this reply helpful? Yes No