Unanswered

The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'.

(0) Share

Report

Posted on by RamagopiBonda

Hi All,

We are using SQL stored procedures to get & export the data, but the flow sometimes failing with error: The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'.
And without any fixing, flow successfully running and getting the expected result. why this is happening I am not sure.

We assume, SQL Stored Procedure not responding in failed times. How to fix this, could you please help me.

In addition to the above please refer below screen shot and advise for fix on combo box list item is having empty row, how to convert that empty row into single space. in backend SQL query it is showing as space " " but in UI we couldn't achieve this. this is also one assumption for flow failure.

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,975 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RamagopiBonda

You mentioned without any fixing, flow successfully running and getting the expected result. why this is happening I am not sure. I can see flow failed here. Could you please explain what you meant by no fixing?

This error is due to Execute Stored Procedure step is returned null data. Next step Create CSV table is expecting an array of values. So to overcome this error add an IF condition to check the data is null or not after the SQL Stored procedure action step.

Thanks

Was this reply helpful? Yes No
RamagopiBonda 19 on at

Like (1)

Report
Copy link

Link copied!

Thanks @abm for your quick response,
I will try with your advise and
We found that when user selecting 'select All' or '1st blank check box' in dropdown and trying to export the data, parameters passing from UI to Stored Procedure it is querying SQL with empty, how to convert this empty to space while querying.

Thanks, in advance

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

Like (0)

Report
Copy link

Link copied!

You could check its empty and pass a space or do this check under the SQL Stored procedure.

Thanks

Was this reply helpful? Yes No