Unanswered

Flow returns "columns 'false' does not exist" even though no column of that name in query

(0) Share

Report

Posted on by mentioch

When I use this expression:

and(equals(body('Get_Tasks_items')?['Checkmark'],1),equals(body('Get_Tasks_items')?['WR_x0020_Flag'],'0'),contains(body('Get_Tasks_items')?['Predecessors'],triggerBody()?['ID']))

I get this error message:

"status": 400, "message": "Column 'False' does not exist. It may have been deleted by another user.\r\nclientRequestId: a6ea03cd-d910-427b-8d10-fb95e71b8803\r\nserviceRequestId: a6ea03cd-d910-427b-8d10-fb95e71b8803"

The column I am using is 'Checkmark', not 'False'.

Any ideas on what I may be doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @mentioch

I check if your equal expression return false, true, true, your expression will look:
and(false,true,true)
To help you further on this, I would request you to share bit more details like full expression or maybe a screen capture of your FLOW.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @mentioch ,

As @DeepakS has suggested, please share a screenshot of the configuration of your flow so we could better understand your issue and provide a proper workaround for you.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MattWeston365 1,701 on at

Like (0)

Report

Hi @mentioch

Based on the error I'm guessing that you're using this within a Filter Query with SharePoint?

and(equals(body('Get_Tasks_items')?['Checkmark'],1),equals(body('Get_Tasks_items')?['WR_x0020_Flag'],'0'),contains(body('Get_Tasks_items')?['Predecessors'],triggerBody()?['ID']))

As @DeepakS pointed out, the whole expression here equates to false, and therefore when the filter query is picking up the false value it is assuming that it is part of the filter query. Therefore, since false isn't the name of a column in SharePoint, you're seeing that message.

This will obviously be confirmed once you post your screenshot, but hopefully will give you a pointer in the meantime.

Was this reply helpful? Yes No
mentioch 18 on at

Like (0)

Report

Thx for your response DeepakS. I have restructured my approach and will advise results after testing is complete.

Have a great day.

Was this reply helpful? Yes No
mentioch 18 on at

Like (0)

Report

Thx for your response v-alzhan-msft. I have restructured my approach and will advise results after testing is complete.

Have a great day.

Was this reply helpful? Yes No
mentioch 18 on at

Like (0)

Report

Thx for your response MattWeston365. I have restructured my approach and will advise results after testing is complete.

Have a great day.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @mentioch ,

Looking forward to your solution.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No