Unanswered

Sharepoint 400 error - new item created in list

(1) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (9)

Answers (0)

telu Microsoft Employee on at

Like (0)

Report

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

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

Like (0)

Report

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.

Was this reply helpful? Yes No
telu Microsoft Employee on at

Like (0)

Report

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

Thanks

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

Like (0)

Report

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

Was this reply helpful? Yes No
seanmchugh 3 on at

Like (0)

Report
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" ]
}

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

Like (0)

Report

Yes the field is linked to another list in ours as well.

Was this reply helpful? Yes No
em_sc 55 on at

Like (0)

Report

Nobody ever responded or solved this? I have the same issue.

Was this reply helpful? Yes No
MarceloAP 16 on at

Like (0)

Report

Same problem here. Any answers out there?

Was this reply helpful? Yes No
em_sc 55 on at

Like (0)

Report

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

Was this reply helpful? Yes No