Skip to main content
Nintex Community Menu Bar

365 query list with variable in filter not working

  • March 16, 2018
  • 2 replies
  • 4 views
  • Translate
I

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?

    Did this topic help you find an answer to your question?

    2 replies

    R
    Forum|alt.badge.img+7
    • ranjca
    • 52 replies
    • March 16, 2018

    Ho Ingeborg,

    Try like this, hope it will work 

    ' +{Variable:vOwnerRole}+ '

    Regards

    Ranjith

    Translate
    Ranjith
    B
    Forum|alt.badge.img+7
    • bstori
    • Novice
    • 91 replies
    • March 18, 2018

    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,

     

    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings