Unanswered

Sharepoint 400 error - new item created in list

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Trying to have a flow create a post on Slack when an item is created in a Sharepoint list. I'm able to set up the flow and select the Sharepoint list. When the flow runs it throws an error through in the first step: "status": 400, "message": "The query to field 'Client/LinkTitleNoMenu' is not valid.",

Is this an issue with the list setup or with connecting to Sharepoint?

I get a similar error for catching updates to items in a list.

Categories:

Using connectors

All responses (9)

Answers (0)

Sort by

telu Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mhoff,

I have created a similiar flow, it works for me, could you send me the flow url for me to further investigate?
like this: https://tip1.flow.microsoft.com/manage/flows/6ef61db7-3e0f-4098-b467-7eae474a4b0f
Thanks,
telu
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I think the error is as a result of a field in Sharepoint, and not so much due to the Flow setup.

"The query to field 'Client/LinkTitleNoMenu' is not valid"

Client is a field on the list that is driven by a drop down menu. Need to figure out why the query isn't working.
telu Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, maybe it doesn't contain list, you can give me the flow url for further investigation.

Thanks
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Flow URL: https://flow.microsoft.com/manage/flows/410d3be9-9730-40e7-bc3e-59bff82b93e2
seanmchugh 3 on at

Like
a
(0)

Report
Copy link

Link copied!
I have the same issue ... definitely looks like an issue with linked fields ... is your field populated with data from other items in the list (or another list). Mine is and it gets the same error.

Body
{ "status": 400,
"message":
"The query to field 'Dependencies/LinkTitleNoMenu' is not valid.", "source": "https://xxxxx.sharepoint.com/sites/Global-IT/_api/web/lists/getbytitle('Application%20Inventory')/Items?$expand=Business_x0020_Owner,Dependencies,Author,Editor&$select=*,Business_x0020_Owner/Name,Dependencies/Internal_x0020_Name,Author/Name,Editor/Name,Dependencies/Internal_x0020_Name,Dependencies/LinkTitleNoMenu&$orderby=ID%20desc&$top=1",
"errors": [ "-1" ]
}
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes the field is linked to another list in ours as well.
em_sc 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Nobody ever responded or solved this? I have the same issue.
MarceloAP 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Same problem here. Any answers out there?
em_sc 55 on at

Like
a
(0)

Report
Copy link

Link copied!

I am not working on it anymore but I couldn't find anything.....