Flow with email body - dynamic list with bulleting from table output

[Sjbosco1]

Hi,

I am trying to build a flow where the input table might look as below:

Name	manager email	ConsumerName	Consumer Email	recomm1	recomm2	recomm3
Manager1	manager1emailID	ConsumerA	ConsumerEmail1	reco1	reco2	reco3
Manager1	manager1emailID	ConsumerB	ConsumerEmail2	reco1	reco2
Manager2	manager2emailID	ConsumerC	ConsumerEmail3	reco1	reco2	reco3

Based on the table above we need to send a single email to Manager1 who has 2 consumers with recommendations formatted as bullet and when no recomm column is empty it should not be shown ex:

Dear Manger1,

Please find your recommendations:

ConsumerA

• reco1
• reco2
• reco2

ConsumerB

• reco1
• reco2

I am unable to create a list with results grouped by ManagerEmail and dynamically list recommendation but can display it as a regular table with results. Kindly suggest.