cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danfoxley
Frequent Visitor

SharePoint Modify Flow Error

Can you help with the following.

 

Using an existing SharePoint list with a SharePoint "wehn an existing item is modified" I get the following error:

 

 

 

Manage your flows | Microsoft Flow
{ "status": 400, "message": "The query to field 'Site/LinkTitleNoMenu' is not valid.", "source": "https://mydomain.sharepoint.com/sites/networkoperations/_api/web/lists/getbytitle('TXW%20NOC%20Tickets')/Items?$expand=Site,Market,R_x003a_Impairment,Shipment_x0020_Number,Author,Editor&$select=*,Site/LinkTitleNoMenu,Market/Title,R_x003a_Impairment/Title,Shipment_x0020_Number/ID,Author/Name,Editor/Name,Site/Site_x0020_Name,R_x003a_Impairment/Impairment_x0020_Percentage,Site/Market_x0020__x002d__x0020_text&$filter=(((Modified%20eq%20'2016-10-01T01:45:12Z')%20and%20(ID%20gt%20'0'))%20or%20((Modified%20gt%20'2016-10-01T01:45:12Z')%20and%20(Modified%20lt%20'2016-10-01T01:54:19Z')))&$orderby=Modified%20asc&$top=100", "errors": [ "-1" ] }
 
11 REPLIES 11
telu
Microsoft
Microsoft

Hi @danfoxley, I have tried the sharepoint -when a list is modified as trigger, it works for me.

sharepoint-email.png

Could you give the flow url like this: https://flow.microsoft.com/manage/flows/3aeb7a4b-b38d-487d-9f0f-37f691ef3a37 for further investigation?

Thanks

danfoxley
Frequent Visitor

HI Telu,

 

Could you repeat what the ask is? I'm not clear on next steps.

@danfoxley, After you creating the flow and clicking to reedit it, the url showing in the browser is the flow url. in the format like this: https://flow.microsoft.com/manage/flows/3aeb7a4b-b38d-487d-9f0f-37f691ef3a37

 

Thanks

danfoxley
Frequent Visitor

@danfoxley, Does Shipment_Details in the sharepoint list is not a string type? I was trying the similiar contain condition, if the type is not same, it would lead to the failure, could you check the flow run to see it's the error?

sharepoint_fail.png

Thanks

danfoxley
Frequent Visitor

The error is in SharePoint not the condition part (as your screen shot shows).

 

Isn't this my Issue, not the condition?

 

Body
{ "status": 400, "message": "The query to field 'Site/LinkTitleNoMenu' is not valid.", "source":

 

Hi danfoxley,

 

I have exactly the same error while using the sharepoint condition "when a new item is created" and am trying to fix it. Were you able to fix the error?

 

In my case, the exact error message is

{ "status": 400, "message": "The query to field 'Project_x0020_Name/LinkTitleNoMenu' is not valid."

 

and it appears to be pointing to a field in this list which is a "lookup" to another sharepoint list.

 

Kind regards

sbmp

Anonymous
Not applicable

I am having the same issue you are. My workflow is failing due to three fields within the list that have the "Lookup" type.

Did you ever find any sloultions to this error?

Anonymous
Not applicable

I recently had the same issue and solved it by following the steps in my blog post at www.SharePointLibrarian.com. I hope it fixes it for you too! Good luck

Having the same issue. Unfortunately using the workaround posted www.SharePointLibrarian.com won't work for us as we're using a (Count Related) lookup column that we need for that list. Any other solution that doesn't require us to change the column type?  

 

Error: 

{
  "status"400,
  "message""The query to field '<Field Name>' is not valid.\r\nclientRequestId: 77a0adbe-2320-45e7-bf84-7a60d6b06982",
  "source""<URL>/_api/SP.APIHubConnector.GetNewListItems",
  "errors": [
    "-1",
    "Microsoft.SharePoint.SPException"
  ]
}

Anonymous
Not applicable

Your column type can still be lookup. It's a column setting for that lookup column, though, that simply changes the presentation of it to plain data instead of hyperlinked data. Would that affect your process?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,010)