Consolidating the count with respect to assignee in email content of power automated flow

[jeyeline]

Hello Team,

   We have a power-automated flow that would send email alerts to the participants with the content of filtered work items from Azure DevOps. Now we would like to change the email content where it would specify the list of work items assigned to it with the count of work items.

For Example 

user 1: 10 Work Items
user 2: 15 Work Items

How can it be done by modifying our existing flow? Sharing the SS of the flow.

[v-yueyun-msft]

Hi, @jeyeline 

According to your description, you want to get the count of items in your array based on the "AssignedTo" field.

This is my test array which is used to simulate your "Create csv table" output:

And this is my flow and my flow result :

(1)The "Select" and "Compose 2", "initialize variable" actions:

The Compose action is the similar output with your "Create csv table" outputs.

item()?['AssignedTo']

union(body('Select'),body('Select'))

(2)The "Apply to each" action:

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,

Yueyun Zhang

[jeyeline]

Hello @v-yueyun-msft ,

Thanks for your reply. My flow is related to the 

1. Get query results - filter the work items with a specific query

2. Create an HTML Table - from the above results

3. Compose - Table Structure

4. Send an email - outputs from the above two steps

The flow Screenshot is attached

We are looking to modify the existing flow to display the Assignee names and the count of work items assigned to them above the table in the email. Despite the provided guidance, I encountered challenges in making modifications to the current flow. I would appreciate suggestions on how to effectively adjust the flow to incorporate this additional information.

Regards,

Jeyeline

[v-yueyun-msft]

Hi , @jeyeline 

Thanks for your quick response! You can add the action after your "Get query results DOA".

The other actions is the same in my above first reply,like this:

If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,

Yueyun Zhang

[jeyeline]

Hello @v-yueyun-msft 

Thank you for your assistance thus far in helping us create the desired flow. However, we've encountered a challenge in providing the expression or condition for the flow, and unfortunately, the information provided hasn't fully addressed our concerns.

To facilitate better understanding and to ensure we can proceed effectively, would it be possible for you to provide additional support by including images along with their corresponding code separately?

We appreciate your ongoing support and look forward to your guidance in resolving this matter.