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:

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Kay_Bains1 9 on at

Like (0)

Report
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']}'

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No