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
You could check its empty and pass a space or do this check under the SQL Stored procedure.
Thanks
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
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