Forum Discussion
Need Advice
I need to count the number of times a specific transgression occurs for a specific name.
Currently:
I have a PowerAutomate flow that opens an excel sheet that has the list data in. This excel file has the complex calculation that determines the count. PowerAutomate then takes those values and updates the values into the SharePoint list column.
I want to know if there is an easier way? SharePoint lists don't seem capable to do the same kind of excel calculation that counts the number of occurrences for specific consultant:
=COUNTIFS(J:J,[@[Nr Transgression]],B:B,[@[Consultant Full Name]])
RoaldWagener you'll need to use Power Automate because SharePoint/Lists can't iterate over multiple items in the way you want.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
- Rob_ElliottBronze Contributor
RoaldWagener you'll need to use Power Automate because SharePoint/Lists can't iterate over multiple items in the way you want.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)