You’re offline. This is a read only version of the page.
I am running into this issue in my Filter query:
Share
Report')' or ',' expected at position 26 in 'contains(cr079_name,'Lowe's Companies Inc')'.
I am trying to get rows based on this filter query: "contains(cr079_name,'@{items('For_each_Report_Details')?['cr079_entityname']}')"
I also have this action wrapped with an "apply for each" action. The overall aim is to filter that list so I can do something with it.
Any helps?
Looks a bit crazy, but this should do it:
All responses (
Answers (
(contains(cr079_name,' @{replace(if(equals(items('For_each_Report_Details')?['cr079_entityname'], null), '', items('For_each_Report_Details')?['cr079_entityname']),'''','''''')}' )) OR (cr079_ticketsymbol eq '@{replace(if(equals(items('For_each_Report_Details')?['cr079_ticketsymbol'], null), '', items('For_each_Report_Details')?['cr079_ticketsymbol']),'''','''''')}')
This is what it looks like now
(contains(cr079_name,' @{replace(items('For_each_Report_Details')?['cr079_entityname'],'''','''''')}' )) OR (cr079_ticketsymbol eq '@{replace(items('For_each_Report_Details')?['cr079_ticketsymbol'],'''','''''')}')It seems to work. thank you but now I am running into the problem:
One or more fields provided is of type 'Null', a different type is expected.
What do you mean? Replace the contain function with the replace function?
It would appear that the "Entity" name contains a single quote which is being interpreted in the filter query, and therefore making the syntax incorrect.
I'm not sure of the solution, you might have to URLEncode the single quote or replace it with \' or perhaps double quotes. But that is what is causing your problem.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
