Unanswered

ResponseSwaggerSchemaValidationFailure on Get Items action

(0) Share

Report

Posted on by Community Power Pla...

Afternoon I'm using a Flow to bring back a field on a SharePoint list which is later changed in an expression action. I've got it working on test, but as soon as I try it on a copy of the production list I get the following error: ResponseSwaggerSchemaValidationFailure. The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/0/Postcode'. I tried adding a default value to the postcode field (as suggested on a post here) but that didn't work, I get the same error. When I cut the flow back to just the Get Items action it runs fine, but as soon as I add the Compose in the For Each loop and Update Item I get that error. The test list only had 5 items, whereas the live version has 1403 items. Could that be an issue. @abm and @OliverR-82 have you ever encountered this issue?

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous can you provide the screenshot of the flow run which shows the error?

Also is the value for column Postcode is it blank for any item? and is the Postcode column set as required in SharePoint list?

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

Like (0)

Report

Hi @annajhaveri . See the error below. Yes the Postcode field is a required field, at the moment it's not empty because I've put a default value in it.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous did you test the flow after putting default values in Postcode column? Also can you please help with Get Items action screenshot configured in your flow? Do you have Filter query configured in the Get Items action?

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

Like (0)

Report

Hi @annajhaveri yes tested it before and after I put the default value in, got the same results. Here's how I have the Get Items action configured, I thought setting the Top Count to 10 might help but no luck.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous okay, the action configuration looks good, just to try out can you create another new flow with just Get Items action and see if the new flow works? If it doesnt, then please double check the list doesnt have any blank values in columns which are set as required as the error is saying that.

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

Like (0)

Report

@annajhaveri created a new Flow with just the Get Items action and it ran okay.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous if you want to continue using the old flow, then try deleting Get Items action from that flow and add it again.

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

Like (1)

Report

Thanks @annajhaveri I'll try building up the new one. I did try that before and had the issue, but I'll give it another go.

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

Like (0)

Report

Hi @annajhaveri I rebuilt the flow and got the same error. So I started taking the actions out from the bottom up. I took the Update Item action out and the flow ran through the Get Item action, but fell over at the second Compose function with the following error: InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '9639': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.
Any ideas?
@abm

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous can you please provide the screenshot of compose action configuration for me to know what is being done by compose action, are you using expression in compose action? If yes, please also provide the expression.

Was this reply helpful? Yes No