Answered

Empty field keeps failing to update

(0) Share

Report

Posted on by Community Power Pla...

I'm using power Automate to populate SharePoint List from MS Forms.

Depending on answers of the user, some fields maybe empty. So, when these fields are empty, I get the following error in the step where SharePoint list is updated.

"The 'inputs.parameters' of workflow operation 'Create_item_in_SharePoint_List' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Expected_x0020_efficiency_x0020_' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'."

What I tried to do in order to update the field is to create "Compose" action and in the SharePoint Item update I used this function (as I've seen in this post )

if(empty(outputs('Compose')),null,outputs('Compose'))

Still I'm getting same error message. Here's snapshot of my Workflow

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

The number column should contain a valid number when you append dynamic content in it. Or it will report the error you show.

As a workaround, you could create a condition action before the Create item action, check if the field contains a value, if yes, update it with the value, or no append anything into it, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks, but why the function I used didn't work?
Also, the field I'm checking if it's empty or not is long text field not numeric.

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report
Hi @Anonymous,

OK, please share an instance of how you configure it, no matter it is a long text field or numeric, it should work.

Or how about you use the length() function to check if the length is 0, if it is empty, length will be 0:

length(string(outputs('Get_response_details')?['body/QuestionID']))

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No