If conditions in the get items of filter query

(0) Share

Report

Posted on by Danny_Dicaprio

Hi every one

Is there is any wany to use if condition in the get items filter query?

In my get items I want to filter Top_x0020_IT_x0020_risks/Riskname eq'@{outputs('Compose_2')}'

If the above condition is not meT I want to filter Title eq 'Central Risk Team'

can we add both conditions in the get items filter query ?

(Top_x0020_IT_x0020_risks/Riskname eq '@{outputs('Compose_2')}' or Title eq 'Central Risk Team')

i tried the above formula but it is only filtering Title eq 'Central Risk Team.'

could anyone please help mem to fix it

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Hi @Danny_Dicaprio ,

What is type of Top_x0020_IT_x0020_risks/Riskname ? Are you using _x0020_ to replace spaces in column name?

If it is text type, I recommend you delete spaces in column name and try below expression.

TopITrisks/Riskname eq '@{outputs('Compose_2')}' or Title eq 'Central Risk Team'

Best regards,

Rimmon

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Hi @v-mengmli-msft

thanks for the reponse

Basically Topi Risk is a vlook up column , thats why I have taken the field name of the column name

I have tried this , but the issue is have already values in central Risk Team so instead of checking the first condition it is directly filering the values in the Title column

if the first condition is not met only then I need to filter the title column name with value central risk Team

Can that be done ? any help would be much appreciated
opITrisks/Riskname eq '@{outputs('Compose_2')}' or Title eq 'Central Risk Team'

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

Like (0)

Report
Hi @Danny_Dicaprio ,

Sorry. Another question.

Does "if the first condition is not met only then I need to filter the title column name with value central risk Team " mean the same as "filter out records that meet either of the criteria"?

Theoretically, this is the corresponding filter expression.

opITrisks/Riskname eq '@{outputs('Compose_2')}' or Title eq 'Central Risk Team'

Best regards,

Rimmon

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
@v-mengmli-msft

"I'm trying to filtering records based on specific criteria within my SharePoint list. Specifically, I aim to filter records where either of the following conditions is met:

TopITrisks/Riskname equals the value obtained from the 'Compose_2' action output.
Title equals 'Central Risk Team'.
The issue arises when both conditions are met, as the filtering prioritizes the 'Title' condition over the 'TopITrisks/Riskname' condition. In such cases, I require the filter to prioritize the 'TopITrisks/Riskname' condition and retrieve its corresponding value instead of that of 'Central Risk Team'."

Can u please help me on this

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

Like (0)

Report

Hi @Danny_Dicaprio ,

I wonder how you learned about this order of processing. I think I'll learn a lot and attempt to figure out a solution.

Best regards,

Rimmon

Was this reply helpful? Yes No