Power Platform Community Forum Thread Details

Hi there,

I have two SharePoint lists, A list of registrations to tutor different courses (List has Tutor name, course selected, other details)A new row is created each time someone signs up to mentor and the fields are filled from the form. The second is the course list (Course name, course contact, etc).

In the course list, I would like to be able to create a live or close to live count for the number of mentors who have registered for each course (something we previously did with a Countif function in Google Sheets.

It looked like this functionality used to be available directly in SharePoint lists as part of the lookup function in the old UI however, has been lost in the new UI. We have just migrated from Google, so our institution only allows access to the new UI.

I’m wondering if there is a Flow I could build to do this, either which is triggered by a new registration being submitted via the Registration Microsoft Form or on a timer which runs a Flow ever half day or so.

I was playing with the idea of:

Start: Recurrence trigger

-> Get items (Course list)

-> Get items (Registration list)

-> Condition (If Course column (Course list)=Course column (Registration list))

-> if Yes -> Update item (Course list) – Registration Count column field = (equivalent of a Countif expression)

However, I couldn’t find if there was an expression for this.

Any help or advice would be hugely appreciated.

Categories:

Building flows