Hello All
I have an integration with Integromat (that pulls NOAA Weather Zone Alerts).

When Integromat fires off a response… in the alert body an array is presented with zone or multiple zones:

"UGC": [
 "CAZ070",
 "CAZ071",
 ]

Now. Here is the issue:
I then want to search in my NWZ Zone table to get the record ID for each Zone

How do I make a formula to search through the array and iterate through the zone name Id’s?

Thanks

Josh