I am having an issue with the following Filter query syntax...
Any assistance would be appreciated
The value you are trying to match needs to be inside single quotes. Its a text value in the choice column, not a number.
@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']}
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.
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...
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.
@RJF61 If you just write VehNo eq VehNo Value.
I set up a copy of your solution before so it should work.
Thanks for your help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 462 Super User 2025 Season 2
Tomac 456 Moderator
abm abm 243 Most Valuable Professional
