+4I have a Query List in a workflow that needs to fetch the Status (Choice Column with Available and Not Available) as a choice. I am trying to filter out those that are set to available?? I have tried this method:
I have tried setting a variable and then changing the is equal to, to the new variable, but it fails to return any results:
Is there a way to effectively accomplish this step?
Thanks in advance
Best answer by jamvan
Thanks for that, I just realized that I had a spelling error in the Choice field of Available, it was reading Availabile. Thank you again for your response.
The first method should work. But don't use the quotation marks in the Query builder like that. So not
“Available”
but
Available
Another possibility could be the variable type of your output variable. If multiple items satisfy the filter requirements (and there is no item limit equal to 1), you need to use collection variables to write the output to. Other variable types only work if the List Query returns a single item.
+4Thanks for that, I just realized that I had a spelling error in the Choice field of Available, it was reading Availabile. Thank you again for your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.