Error: Flow save failed with code 'OpenApiOperationParameterValidationFailed'

[LauraleeG]

I have a flow that is set up to take data from a MS Form and put it into a SharePoint list. The form has a number of multiple select fields, so far I have set up 14 fields that transfer the multi-selected items to the SharePoint list. I have now gone to add some additional fields in exactly the same way and keep getting this error "Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '" "' in path 'item/REOCs' with type/format 'String' is not convertible to type/format 'Array'.'."

The field "REOCs" is set up the same way as all of the other fields that I have done this for but it won't work. I have checked everything I can think of and I can't get the error to be fixed.

[ManishSolanki]

Hi @LauraleeG 

You need to create a single line of text from array field. For that, pls try using expression with join function. Here is an example:

Expression needs to be added in expression box as highlighted in above screenshot. 

join(outputs('Get_response_details')?['body/r84f6be80c1a2416ea3f638959fbf8c1d'],', ')

Pls replace the field id with actual one in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[LauraleeG]

Thanks @ManishSolanki for your response, is this in order to fix the issue with the REOCs field? I have previously set up the title field in the same way for many other power automate flows and it hasn't been an issue?

[ManishSolanki]

Hi @LauraleeG 

It looks like flow is reading the choice field value as an array. 

[LauraleeG]

@ManishSolanki So I set up each of the multiselect fields with the format below, so that I can have a null if there is a field that doesn't have a selection? Is that where it needs to be changed or is it in the SharePoint list settings?

coalesce(json(outputs('Get_response_details')?['body/r074ca83344824548bb3fddf36f19261a']), createarray(null))

[ManishSolanki]

Hi @LauraleeG 

Pls try the below expression to convert array to single line of text:

join(coalesce(json(outputs('Get_response_details')?['body/r074ca83344824548bb3fddf36f19261a']), ''),', ')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[LauraleeG]

Thanks @ManishSolanki I tried that but still got this error "Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '" "' in path 'item/REOCs' with type/format 'String' is not convertible to type/format 'Array'.'."

[ManishSolanki]

Hi @LauraleeG 

Pls share:

1. The data type of REOCs columns in SharePoint list.

2. Input values of MS field from the previous failed flow instance

3. Expression used for setting REOCs column in SharePoint list or used in create item action.

[LauraleeG · Accepted solution]

So I worked out that the issue was a space " " in the create item field for the REOCs column in SharePoint 😒