Power Automate Flow - SharePoint List 'Choice count

[Mandarin]

Hello All

Could somebody assist me with a Power Automate Flow? I have a SharePoint list updated via a Power APP. My 'List has a column named 'Employee with 'Choice values for our 'Employees. I want to create a flow so that when the 'Choice count reaches seven, it automatically emails our HR email address.

I appreciate any help you can provide.

[Expiscornovus]

Hi @Mandarin,

You could use the RenderListDataAsStream method to retrieve that view with the grouping in a Send an HTTP request. In the response body of the request you should be able to find a FieldName.COUNT.group property which lists the Count value.

Below is an example

In this example the Group By Field is Course, you need to replace it by your field Employee

_api/web/lists/getbytitle('@{variables('ListName')}')/RenderListDataAsStream?View=@{variables('ViewID')}

I have shared more about this approach in one of my blogs:

https://www.expiscornovus.com/2021/10/07/how-to-get-a-group-by-subtotal/

[Mandarin]

Hello, and thank you for sharing the 'Flow. The 'Send HTTP request outputs the desired 'Employee.COUNT.group total, which is what we are looking for.

Can you assist with our final step? We need to add to the Flow so when the 'Employee.COUNT.group total reaches 4; it automatically emails to our HR department.

I appreciate any help you can provide.

[Expiscornovus · Accepted solution]

Hi @Mandarin,

You could use a Filter Array with a check if the Employee.COUNT.group field of an item is equal to 7. After that  check you can use a condition to check if the outputs of that Filter Array is not empty.  If it is not empty you can send an email.

Below is an example

1. Filter Array

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['Listdata']['Row']

@equals(int(item()?['Employee.COUNT.group']), 7)

2. Condition

length(body('Filter_array'))

is greater than 0