Loop through a list to find matching values

I have a query into a webflow collection that brings back all the items. I have another query that goes to Salesforce to get all the products. I want to loop through both lists and find instances where I have the product in webflow and in salesforce so that I can align IDs.

I would like to query each system once, loop through the lists and then product one table output. Any guidance appreciated.

Hello @Peeyoosh_Chandra. Welcome to the Community.

Follow the steps:

  • You need to aggregate Salesforce query in to an array (if not already in array).
  • Iterate through Webflow collection and use map function to find the corresponding id from Salesforce.

Don’t hesitate to contact us if you require further assistance.



And you may wish to check out the array operations post.

1 Like

Thanks everyone for the suggestions. Managed to figure it out.

1 Like

Do you mind sharing a screenshot of your solution or whether the suggestions here reflect the actual solution? What you described here is similar to another use case I’m dealing with.

Also the table generation post.

1 Like