I have two SharePoint Lists
- Submissions
- Filtered submissions
I have created a PowerApps to post submissions to the submissions list.
What I need now is a power automate fix where when a new submission it searches the submission list for a match on two parameters
both text fields and if a match is found I will firstly create a item in the filters submissions list with a count column (integer)
and for every subsequent match it will simply increment the count in the filtered list.
The submission still ends up being added to the submissions list in fact its this which acts as the trigger (when an item is created).
the end result is that I have a list with a count for every item which matches both criteria
i.e. for every item with matches role (string) and department (string)
resulting in a list which effectively has a count of specific roles within a specific department
HR Administrators 10
HR Manager 5
ICT Engineers 15
ICT Manager 3
ICT Tech-Leads 2
am thinking first two actions are
When an Items is created (pointing to submissions list)
then it either a condition or a get items which searches the list for a match
Any assistance would be great many thanks.
