Answered

Get Item Filter Quer

(0) Share

Report

Posted on by Danny_Dicaprio

I have a flow triggered by a new form (MS Form) response. Within this flow,

I need to filter items from a SharePoint list based on a specific column called "Top IT risks" and the value submitted from the form.

Top IT risks Is lookup column in my SharePoint list.

I have added following formula in the filter query but it's showing some error.

Top_IT_risks/Value eq '[EOSL & vulnerabilities for Servers ]'

showing an error like this Column 'Top_IT_risks' does not exist. It may have been deleted by another user.
clientRequestI

Could anyone please help me to fix this issue?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (3)

v-yetonggu-msft on at

Like (0)

Report

Hi @Danny_Dicaprio ，

First of all, you need to make it clear that Top_IT_risks is not a selection column. There is a difference between lookup columns and ordinary single selection columns in Filter Query.

We not only need the column names of the lookup, but also the column names referenced by the lookp columns.

I did a test for your reference.

In my scenario:

My SharePoint List:

My Flow:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
HI @v-yetonggu-msft

Thanks for the response

I made the changes But still getting some error , could you please help me

My lookup column name is Risk_name( Not a Title column , its a single line text column )

I tried the following formula

Top IT risks/Risk_name eq'EOSL & Vulnerabilities for Servers'

Was this reply helpful? Yes No
Verified answer

MrGott 101 on at

Like (1)

Report

You need to use the internal Name of the Lookup Column.
To view them enter the SharePoint List Settings (Gear icon on top right corner) -> Select the LookUp Column

Inspect the URL of the site. The URL ends like "&Field=YOURFIELDNAME". Use that Fielaname in your query.

PS: You still need to use the /Value or /Title in the odata query

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

@AndiM @v-yetonggu-msft

Thanks for your response guys , I have added the filed name

&Field=Top_x0020_IT_x0020_risks

Now also some error is showing up

Top_x0020_IT_x0020_risks/Risk_name eq'EOSL & Vulnerabilities for Servers'

Could u please help me to fix this one

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (1)

Report

Hi @Danny_Dicaprio ,

Similarly, you need to enter another list to view the internal name of the Risk_name column.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

Hi
@v-yetonggu-msft @AndiM

Really appreciate your response guys
it worked.

But the values are comming on apply to each is there is any way to get rid of that

Was this reply helpful? Yes No
Verified answer

MrGott 101 on at

Like (1)

Report

get items will always give you an array.
You could use the first (or last) function to get only one item.
For handyness you could use the "Get Item" with and leverage a powerfx statement like: first(outputs('Get_Items_for_risk_manager_level...'))?['ID]

or you just live with the apply to each 😄

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

@AndiM

Tired of these apply to each 😂

Anyway thanks for the support man, really appreciate it

Was this reply helpful? Yes No