JesseL1
Design Dabbler

Workflow Issue: Multiple Selection field in Query List

Jump to solution

I'm having an issue with the Query List action in Workflow.

 

I want it to filter on a multiple selection field

To clarify: For whichever combination of choices are selected for the item the workflow is running for, I want the Query List to find all other items in the library with the same combination. Query List works if I put in a specific combination and run the workflow so I know everything else is calibrated properly. I need the workflow to work for all combinations though.

 

I've tried a few different options including:

Converting the multiple selection field to a text string along with removing commas and white space using the convert to text and regular expression actions to see if that made a difference

 

Tried using contain instead of equals as seen below

 

JesseL1_0-1618329850676.png

 

Any help is much appreciated.

 

 

0 Kudos
Reply
6 Replies
Aleximo
Forms Fledgling

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

hey,

 

when u set ur TopicText variable (Text Variable) try it like this:

 

Aleximo_0-1618401163832.png

 

after that u can lookup ur list and save the values (in my example the IDs) in a collection variable.

 

Aleximo_1-1618401277427.png

 

 

 

Reply
JesseL1
Design Dabbler

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

Thank you for the response. Unfortunately that solution doesn't seem to work for me.

 

I don't see a topic list in my query list action and if I use the library I'm searching in. It doesn't pick up any items.

 

What I'm really after is how does workflow store a multiple selection field, and how can I use it with the query list action to find items that have the same multiple selection combination as the item I'm running the workflow for.

 

Thanks,

0 Kudos
Reply
Aleximo
Forms Fledgling

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

oh... the topic list is just an example... u have to select ur list where the new item is created.

 

u have to store the multipleselection field in a TEXT VARIABLE and then u have to get the value like i did in my first screenshot.

 

set ur text variable: urvariablename

 

lookup in list --> current item -- > ur multipleselection field

 

it works in my testworkflow:

 

the first row is my CollID ... the second is the text variable TopicText .. and the last is the multipleselection value when i would choose "Topic" in my filter

 

Aleximo_0-1618488087859.png

 

Aleximo_1-1618488152538.png

 

maybe u can add some screenshots of the steps and then i can help u to find the error

 

0 Kudos
Reply
JesseL1
Design Dabbler

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

Here is the series of actions I have set up.

JesseL1_0-1618496898756.png

1) The build string takes in the "Topic" which is the multiple selection field and converts it to a string.

JesseL1_1-1618497065704.png

2) I'm having a hard time understanding what exactly I'm doing with the set variable that the build string isn't doing but I have it in there like you had in your post.

JesseL1_2-1618497163744.png

3) Then I query the library I'm working out of to find all other items with the same multiple field selection.

JesseL1_3-1618497295389.png

4) I then output the list ID in an email

JesseL1_4-1618497382530.png

 

Let me know what I'm missing to get my workflow to work. Your help is much appreciated.

 

 

 

0 Kudos
Reply
Aleximo
Forms Fledgling

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

U dont need the build string element.

 

my workflow looks like this:

 

Aleximo_1-1618557100505.png

 

 

and because the set variable and lookup in list looks fine in ur screenshots, it has to be ur variable "TopicText" .. u have to create it like this:

 

Aleximo_0-1618557007499.png

 

 

 

View solution in original post

Reply
JesseL1
Design Dabbler

Re: Workflow Issue: Multiple Selection field in Query List

Jump to solution

Thank you your help.

 

That resolved the issue.

0 Kudos
Reply