Loop through a list to find matching values

Questions & Answers
1

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.

2

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.

//VLAD

2 Likes
3

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

1 Like
4

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

1 Like
5

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.

6

Also the table generation post.

1 Like