Answered

Get items from different list and filter query

(0) Share

Report

Posted on by mirtiza

Hello,

I have two list "Test" having column "Location" which is a Lookup column from "Present Location" and "Location Based Engineer" having column "Present Location". My flow trigger when created item in "Test". I want to Get Items from "location Based Engineer" and filter query if "Present Location" equal to " Location".

but i am having the error"

{

"status": 400,

"message": "The expression \"Present Location eq'test'\" is not valid. Creating query Failed

Kindly ASAP.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

JohnAageAnderse 1,986 on at

Like (0)

Report
Copy link

Link copied!

Hello @mirtiza

In your Filter query field, you have to use the internal name for your column - meaning a name without spaces.
Check what you internal name is and use that.
Kind regards, John

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mirtiza ,

Please try to run Get items without configuring Filter Query and check the Body of it.

Get the display name of the column and configure it to Filter Query.

And please add a space between ' and eq.

Besides, if the Location is the lookup column to Location based engineer list, you could use Get item action to get the item in Location based engineer list.

You just need to fill Location Id in the ID field of Get item action.

Please take a try and feel free to let us know if you have any other questions.

Best Regards,

Was this reply helpful? Yes No
mirtiza 21 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bacao-msft ,

Thanks for the reply. Basically i want to filter query Present location eq Location value. And the error is "message": "The expression \"Present Location eq'test'\" is not valid. Creating query Failed. May be it didnt Get value of Present Location. Any solution?

And i had to make some changes in my list. Now i have list "Helpdesk Onecare" which have a column "Location" type= choice.
My second list is test HD Location" having column "Location" type= single line of text

It was working fine untill my "Location" column of list " Helpdesk Onecare" having type=lookup but I have to change the type to choice. To change the type i had to delete the column and create a new column with same name "Location " with type =choice. When I changed the type=choice it doesnt working. I am having the same error.

I tried your solution but it didnt work.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mirtiza ,

I have mentioned in my previous reply, please check it again. You need to get the display name in the Body of Get items action without configuring Filter Query. We can’t add space between the name of a column.

Besides, we could not fill Lookup column and choice column in Filter Query.

Before configuring Filter Query or other filters each time, we can first observe the body of the specified action and then determine what conditions we need to configure. The field name displayed in the Body may be different from the field name displayed in the list, and the field name existing in the body needs to be used.

Hope that makes sense.

Best Regards,

Was this reply helpful? Yes No