cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
york
Helper II
Helper II

how to convert the data from list to mail

Hi Experts:

  I have a list in the below picture, I want to send the mail to my team and tell them how many are in PVT stage or how many are Yes in PCN Implementation column, just like the below data, but I'm curious how to get the number through Power Automate.

Product stage:

  PVT:2

  NPI:2

  MP:1

york_0-1653376267540.png

 

 

1 REPLY 1
Rhiassuring
Super User
Super User

Hi there, 

 

Will it only ever be the 3 types? MP, PVT, NPI?

 

One for each Product Stage:

 

Get Items w/ Filter Query: (Product Stage eq 'PVT') and (PCN Implementation eq 'Yes')

 

Under each, use a Compose action with the expression length(outputs('Get_items')?['body/value'])

Then, in your email, just type in what you want, and use the appropriate Outputs. For this reason, make sure your actions are well named. Here's an example for PVT:

 

Rhiassuring_0-1653431951088.png

 

Cheers,

 

Rhia

 

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,270)