Power Platform Community Forum Thread Details

Hello All,

I hope this is the right sport for this. I am fairly new to power apps and I`m stuck on two things.

I have a scheduling APP I have built for my techs which is working good but I would like to add an email button to send to my PM's to check over there scheduled Jobs.

I can get this to work via the office365 connector but it is sending a email for each individual job to the PM... I would like to clean this up and have 1 email send to my PM's with the data of all there scheduled jobs.

I have had success and collecting the information but I'm not sure how to separate the items and match them to the PM's.. This is what I have so far.

In my APP I have a button that that kicks off a flow. The button creates a collections from a gallery and then it collects my information and sends it to the flow.

Button:
EmailPreLim-Dev'.Run(JSON(ColJobReady2,JSONFormat.IncludeBinaryData),SelectedDate,SelectedDate);
Clear(ColJobReady2)

This is my current flow:

and below is my JSON format. The question that I have is how do I separate all my items and then group them under each PM(Or is there a better way). I would imagine an array would be built for each PM.. Then once this is complete I would send a email to each PM email Address with the body of there array list only there jobs in the collection that was created from the button in power apps..

Thanks,

{

"type": "array",

"items": {

"type": "object",

"properties": {

"Customer": {

"type": "string"

"Customer Engineer": {

"type": "string"

"Docs Needed": {

"type": "string"