Flow Question

[RJF61]

I have a portion of a Flow as shown...

The Compose 2 results are shown as the following...

[
{
"MVehNo": "9",
"Supervisor": "Supervisor 1"
},
{
"MVehNo": "14",
"Supervisor": "Supervisor 1 Name"
},
{
"MVehNo": "21",
"Supervisor": "Supervisor 2 Name"
},
{
"MVehNo": "32",
"Supervisor": "Supervisor 3 Name"
},
{
"MVehNo": "34",
"Supervisor": "Supervisor 4 Name"
},
{
"MVehNo": "35",
"Supervisor": "Supervisor 1 Name"
},
{
"MVehNo": "52",
"Supervisor": "Supervisor 5 Name"
}

]

What I want to accomplish is send an email to each Supervisor identifying the vehicles in their responsibility.

Supervisor 1 Name

     9

   14

   35

Supervisor 2 Name

    21
Supervisor 3 Name

    32

Supervisor 4 Name

    34

Supervisor 5 Name

    52

I understand how to do the "Search for users (V2)" for the Supervisor Name; but, not with the "MVehNo" value.  Any assistance would be appreciated.  

[ManishSolanki · Accepted solution]

Hi @RJF61

Pls refer the below sample flow:

1. After compose, pls use 'Select' action to separate out Supervisor name in an array.

2. Next, iterate on the Supervisor names, the value of 'Apply to each' action will be unique name by applying union() formula on the select action output as shown below:

3. Next, inside apply to each action, using 'Filter array' action, get all the records for a supervisor:

4. Now, create a html table to be send to supervisor in the email:

5. Finally, search the user by name and then send an email as shown below:

Note: As you are searching by name so you may get multiple records while searching because name is not unique and multiple people can have same names.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[RJF61]

@ManishSolanki Thanks for your help.  Collected data is perfect!  Following is a sample HTML...

MVehNo	Supervisor
9	Supervisor 1
14	Supervisor 1
35	Supervisor 1
56	Supervisor 1
65	Supervisor 1
93	Supervisor 1
132	Supervisor 1
133	Supervisor 1
135	Supervisor 1
326	Supervisor 1
327	Supervisor 1
366	Supervisor 1
379	Supervisor 1
384	Supervisor 1
419	Supervisor 1
425	Supervisor 1
430	Supervisor 1
471	Supervisor 1
481	Supervisor 1
505	Supervisor 1
530	Supervisor 1
554	Supervisor 1
561	Supervisor 1
591	Supervisor 1
621	Supervisor 1
642	Supervisor 1
644	Supervisor 1
672	Supervisor 1
911	Supervisor 1

Other than the process within Power Automate, I have not worked with HTML tables.  I know that I wanted to send the info grouped by Supervisor; however, from an aesthetics viewpoint, is there a way to display only the MVehNo in the HTML table?

[ManishSolanki · Accepted solution]

Hi @RJF61 

To show only the vehicle number in html table, please modify the 'Create HTML table' action as shown below:

Please remember to give a 👍 if this helps.

Thanks

[RJF61]

@ManishSolanki Perfect...thanks!