Afternoon,

I’ve got a sharepoint list and I’m trying to count the number of individual items in a choice column so it can be used a part of a formula. I.e for for test 1 in the table the count would be 4 & for test 2 it would be 1Table with multiple choice column

I’ve found various posts with approaches using a power automate flow but none of them are quite right for what i’ve got.

If anyone has any ideas for how best to achieve this I’d really appreciate it. I had thought i’d be able to do this with a formula but it seems more complicated and is starting to drive me a bit nuts now!

Various posts showing how to sum up the values which didn’t quite work