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?
I can assume you are using Nintex Forms Choice control? If you are and you have Choice1, Choice2, Choice3, and then you don't have that space in your drop down you will not get any responses back as the spaces could be throwing off your variable. Please make sure you set up your choice field like this Choice1,Choice2,Choice3.
SP Column = Nintex Choice Column input Choice1,Choice2,Choice3
Also, if you could post a screenshot of your Office 365 Query List Action that would be helpful. Something might now be right in that action as well,