Forum Discussion
SharePoint List - how to leverage Column Totals?
I have a SharePoint List where owners can see/edit all items, but members can only see items that they have created. Therefore, Column Count (Totals) is different for owners and members. Owners...
So you can't really use the security model, but what you can do is just utilize the created by column to get the counts for each user. And then filter without that column to get total counts in power automate.
You can utilize the Get Items action and use odata filter part of the action to apply the same filters you would have in a view. Then use a length() expression to get the count of the get items / body/values for those filters. You can enclose this in a Apply to Each condition with an array or query list of users from the users connector etc. Then inside that for each user you can insert the user in the odata filter where CreatedBy.Email eq 'theuseremailvalue' for the get items action and then get the length() of that, then a condition that uses that length and act off that value.
You can utilize the Get Items action and use odata filter part of the action to apply the same filters you would have in a view. Then use a length() expression to get the count of the get items / body/values for those filters. You can enclose this in a Apply to Each condition with an array or query list of users from the users connector etc. Then inside that for each user you can insert the user in the odata filter where CreatedBy.Email eq 'theuseremailvalue' for the get items action and then get the length() of that, then a condition that uses that length and act off that value.