cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sjbosco1
New Member

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

Hi,

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

Namemanager emailConsumerNameConsumer Emailrecomm1recomm2recomm3
Manager1manager1emailIDConsumerAConsumerEmail1reco1reco2reco3
Manager1manager1emailIDConsumerBConsumerEmail2reco1reco2 
Manager2manager2emailIDConsumerCConsumerEmail3reco1reco2reco3

 

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.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,483)