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]])
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]]) Read More