Solved

Error while updating a list - Using SharePoint O365 with NWC

  • 20 September 2022
  • 2 replies
  • 304 views

Hello,

I am trying to update a list and I get the following error.  Do you have any idea what may be causing this error:

Received an error response from the connector: BadRequest: SharePoint returns exception: BadRequest, ResponseStatus: Error - The query is not valid. (CorrelationID:...). [Error Code: IO.XtensionExecute.ErrorResponse]

My connector is able to Retrieve the item with no issues.

 

icon

Best answer by Garrett 20 September 2022, 13:40

View original

2 replies

Userlevel 6
Badge +16

Hi @LoveNintex 


 



  1. You stated "My connector is able to Retrieve the item with no issues."
    Just to clarify, did you meant you can retrieve the Lists or that your can retrieve a specific item from the list.

  2. When you use SharePoint Online - Update Items action, caution is recommended as this action will act on the entire list. 

  3. You must use the Condition to filter the items in which to update. Otherwise, the entire List Items will be updated. e.g. You meant to update the status "completed" for the condition where Item ID == 5, if you omitted the condition then the Update Items action will update every item in the list with the status "completed"

  4. Your issue is probably due to a incorrect Condition. 
    Without knowing what was specified in the Update Items, its probably difficult to resolve your issue.

  5. Are you using any variables in the condition?
    I would recommend to use fixed or hard coded (not variable) to check if the Update Items will work successfully.

  6. Once the Update Items work, then replace back with your variables.
    If the variables do not work, then you need to check what is wrong with the variables using the Log action.

     


     

I was using a Condition on my SharePoint Online - Update Items action, but you were right, the variable was incorrect.  It worked with the condition hard coded, and then worked when I corrected the variable.  Thank you!

Reply