I'm currently having an issue meeting user requirements for an approval process.
We receive reports that have data such as a list of codes separated by comma delimiters. I need to extract this list (single line text field in SP list) and use it to match to another SP list containing email addresses matched with codes, so that the Get Items action returns a list of all the email addresses that have a code matching those in the original list.
I've tried to split the comma separated values into an array but then I can't match these to the second list as the codes in that list are also single line text so I get the error that I can't compare Array to String.
It's very possible I'm code blind at this point and can't see the forest for the trees but any suggestions to make this work?
