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?