Get Items Filter by Array?

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Business Process Flows

All responses (2)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Re: Get Items Filter by Array?

@takolota You're a legend! I knew it was staring me right in the face, for some reason I just didnt think to switch the fields in the Filter Array and check for the array containing the Get Items field. Thank you!
Verified answer

takolota1 4,896 Super User 2025 Season 1 on at

Like (1)

Report

Re: Get Items Filter by Array?

@Anonymous

As long as each code is unique, I’d think you could just use a Filter array action to get all the SP items where the array of codes contains that row’s code.