Aggregate Microsoft Forms Responses

%3CLINGO-SUB%20id%3D%22lingo-sub-2497952%22%20slang%3D%22en-US%22%3EAggregate%20Microsoft%20Forms%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2497952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20way%20using%20Power%20Automate%20to%20funnel%20multiple%20form%20responses%20into%20one%20email%20based%20on%20a%20condition%3F%20For%20instance%2C%205%20employees%20indicate%20that%20Joe%20Smith%20is%20their%20manager%20on%20the%20form.%20I%20would%20like%20to%20aggregate%20all%20of%20the%20form%20responses%20that%20indicate%20Joe%20Smith%20as%20the%20manager%20into%20one%20email%20that%20is%20then%20sent%20to%20Joe.%20I%20already%20have%20a%20flow%20set%20up%20that%20triggers%20an%20email%20to%20%22Joe%22%20when%20a%20new%20response%20is%20submitted%20but%20it%20would%20be%20helpful%20to%20aggregate%20multiple%20responses%20into%20one%20email.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2497952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Is there a way using Power Automate to funnel multiple form responses into one email based on a condition? For instance, 5 employees indicate that Joe Smith is their manager on the form. I would like to aggregate all of the form responses that indicate Joe Smith as the manager into one email that is then sent to Joe. I already have a flow set up that triggers an email to "Joe" when a new response is submitted but it would be helpful to aggregate multiple responses into one email.

0 Replies