Unanswered

Sync Sharepoint list with SQL Stored Procedure

(0) Share

Report

Posted on by dflemming

Hello everyone,

I have no problem using 'Get Rows' to refresh a sharepoint list but results from 'Execute stored procedure' seems to be a table. When using the output of parse JSON to add items to my SP list I see the error.

'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['content']?['Table1']' is of type 'Null'. The result must be a valid array.

I've seen this brought up in the community a few times but can't see an approach that converts the table into an array. If anyone can point me to a better approach for this process I'd be very grateful.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dflemming

This post could help.

Solved: Stored Procedure - ['Table1'] is of type 'Null' - Power Platform Community (microsoft.com)

Thanks

Was this reply helpful? Yes No
dflemming 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks abm,
I've looked at that post a few times but can't understand the suggested solution: "You can try to store the content that needs to be configured in Content field in an Object variable, and then populate the variable in Content field"
I think I need a few steps exposed before I can implement that. What does populate the variable in Content field look like?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dflemming

Could you please post a screenshot of your run history of Get Rows?

Thanks

Was this reply helpful? Yes No