cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

365 query list with variable in filter not working

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?

Reply
2 Replies
Workflow Hero

Re: 365 query list with variable in filter not working

Ho Ingeborg,

Try like this, hope it will work 

' +{Variable:vOwnerRole}+ '

Regards

Ranjith

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: 365 query list with variable in filter not working

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

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,

 

0 Kudos
Accept as Solution Reply