Composing data in stages versus using expressions
As you progress with logic apps and build up your experience over time, you will undoubtedly get to a situation quickly where you need to look for specific records from different entities where they may be related. One such example might be the contact details for a contact, where the contact details exist not as part of the Contact record but in a linked Contact Types record. Here, the temptation is to do the following:
- Make your initial List records query to obtain the contact in question.
- Create a For each block cycling through the Value field (each record in turn).
- Inside the For each block, create a List records query to obtain the contact types for that person.
As you can see, this is one call per contact type and one call per contact, which may take several...