I’ve tried searching the forum, and can’t find any specific answer to my issue.
I’m trying to search an array of collections, and pull the value “date” from the array item that contains a specific string, but does not match the entire string within the value “action”. Eg, finding “Update” being contained in a string “Updated The Milestone.” with key value “action” I want to store multiple array date values as variables in the next step if possible (20 different variables) and each one is unique so there should only be one value returned for each search.
I’ve tried a lot of variations of get/map, contains, and if statements and the big kicker is that i’m trying to do this from Array to Variable modules, with no use of in-between filtering. There are usually arrays of anywhere from 50 to 500 items in each array and I can’t afford to iterate and filter hundreds of times each pull. I hope this makes sense.
Here is an example of some failed values, and how the data gets pulled. I send it through a iterator/aggregator to filter out a lot of irrelevant items (just incase I do need to fall back to a more operation intense way of doing it)
So as simply as I can describe what I need. This is how I thought the process should work, but it doesn’t
