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.

All responses (3)

Answers (0)

abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: Sync Sharepoint list with SQL Stored Procedure

Hi @dflemming

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

Thanks
dflemming 85 on at

Like (0)

Report

Re: Sync Sharepoint list with SQL Stored Procedure

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?
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: Sync Sharepoint list with SQL Stored Procedure

Hi @dflemming

This post could help.

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

Thanks