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