Filter Query in Get Items not showing columns and not Recognising the variable

(0) Share

Report

Posted on by Kay_Bains1

Two Sharepoint Lists Sharepoint List A (Purchase Order Header and Sharepoint List B (Purchase Order Details)

I have linked them using the ID from Sharepoint List A which matches the Title in Sharepoint List B

Thus have a one-to-many relationship

Created a flow where when an item is created or modified in Sharepoint List A,

Get item from Sharepoint List A where ID is set to ID

Initialise variable

The I Get items from Sharepoint List B

I have noticed two things,

the columns from Sharepoint List B are not populated in dynamic value - why

the filter query is not recognising the variable VarPONumber - why

Error The expression "Title contains 'VarPONumber'
" is not valid. Creating query failed.
clientRequestId:
serviceRequestId:

All responses (3)

Answers (0)

wskinnermctc 6,517 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Query in Get Items not showing columns and not Recognising the variable

Might have to do with it being an integer number as oppose to a string. You can try wrapping it in a string() expression.
Also, remove the @ and the start and end brackets {} if you can actually see them in your filter. (But showing us the @ and brackets {} is probably a result of you copying the entire dynamic content to paste on here.)

My guess about the reason columns don't populate in dynamic content, because it happens to me too.
When you try to use dynamic content, I think Power Automate is making assumptions about value types that are in columns and then making them available for whatever step you are currently using.
So if you are trying to use a date time field, power automate will probably only show date time columns as choices.
This doesn't always work, and is really annoying.
I usually have to make a Compose step and put the dynamic content value into the compose step. Then highlight and copy the dynamic value.
Then go into where I want to use the value and paste into the expression tab. Remove the brackets {} or @ that is sometimes included.

It's basically manually filling the field using the expression tab.
Kay_Bains1 9 on at

Like (0)

Report
Re: Filter Query in Get Items not showing columns and not Recognising the variable

Hi

Thank you for your response but I am still getting the exact same error

Title contains '@{variables('VarPONumber')}'
//Equals Title eq '@{outputs('When_an_item_is_created_or_modified')?['ID']}' //Contains Title contains '@{outputs('When_an_item_is_created_or_modified')?['ID']}'
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (1)

Report
Re: Filter Query in Get Items not showing columns and not Recognising the variable

You need to use an expression to get the value from your variable.
Title contains '@{variables('VarPONumber')}'

I probably wouldn't even have the variable, and instead just use the ID directly from your Trigger. So, the expression might look like one of the following depending on whether you want to check if equal to or just contains.
//Equals Title eq '@{outputs('When_an_item_is_created_or_modified')?['ID']}' //Contains Title contains '@{outputs('When_an_item_is_created_or_modified')?['ID']}'

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.