I have a survey where a selection within a repeat triggers power automate to generate a report and email it to the user.
the survey in question is a tree survey and the parent survey records general site details, weather etc, and then the repeat is for each tree. If an individual tree is recorded with a certain criteria from a select one question, i need a report generating for that tree.
When using power automate, the trigger generates an "apply to each" section, this seems to be generating a report for each instance of a tree being selected, the issue is, my report also takes this into account. If one tree is identified by this criteria, i get one report generated with that tree and one email, if two trees are identified, i get two emails (one for each tree) but the reports are identical containing both trees (as the report cycles through the repeat)
I would be eternally grateful for any ideas as to how i should be setting this up so that i get a single email and report containing all the trees in one, or vice versa, single emails with a report per tree
@IsmaelChivite @JamesTedrick
