AnsweredAssumed Answered

365 query list with variable in filter not working

Question asked by ingeborg on Mar 15, 2018
Latest reply on Mar 18, 2018 by bstori

Hi,

I have a list with text values. I use this list in a ForEach loop and store the Title value in a variable.

I then use the 365 query list and want to filter records where a choice field equals that variable.

 

If I write out the filter value in the CAML as text, I get a result. If I use the variable instead, I get 0 results. 

 

What am I doing wrong? Note that the Owner Role is a Choice field in the list I want to filter.

 

I attach a screenshot of the CAML from Notepad++. The top CAML works fine, but the bottom CAML does not.

 

How can I post CAML code here?

Outcomes