Get items issue

(0) Share

Report

Posted on by RJF61

1,252

I am having an issue with the following Filter query syntax...

Any assistance would be appreciated

Categories:

Business Process Flows

I have the same question (0)

All responses (7)

Answers (1)

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Get items issue

The value you are trying to match needs to be inside single quotes. Its a text value in the choice column, not a number.

Was this reply helpful? Yes No
RJF61 1,252 on at

Like (0)

Report

Re: Get items issue

@Pstork1
Thanks for the response. For whatever reason, I am receiving regardless of the single quotes...

Vehicle_x0020_Number eq '@{triggerOutputs()?['body/Vehicle_x0020_Number/Value']}'
or
'Vehicle_x0020_Number' eq @{triggerOutputs()?['body/Vehicle_x0020_Number/Value']}

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Get items issue

What trigger are you using? If you are using one of the SharePoint triggers then why do Get Items? You could just do Get Item using the ID.

Was this reply helpful? Yes No
RJF61 1,252 on at

Like (0)

Report

Re: Get items issue

I am using the "When an item is created or modified". There are multiple Vehicle_x0020_Number values so I need to pull the Highest/Max value based on the Vehicle_x0020_Number. As below...

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report
Re: Get items issue

Ok, I tested that scenario on one of my lists and it works with the following code.

Vehicle_x0020_Number eq 'triggerOutputs()?['body/Vehicle_x0020_Number/Value']'

Power Automate will add the @{} around the value if you type it in the expression tab the way I've listed it.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

Re: Get items issue

@RJF61 If you just write VehNo eq VehNo Value.

I set up a copy of your solution before so it should work.

Was this reply helpful? Yes No
Verified answer

RJF61 1,252 on at

Like (0)

Report

Re: Get items issue

Thanks for your help

Was this reply helpful? Yes No