Insight needed: Teacher trying to build "house points" system and district CTO hostility
Large(ish) ISD. School admin wants a "house points" system with a lot of hesitancy about how to do it and a lot of faculty hesitation.
I (Computer Science (among other things) teacher) build a series of Sharepoint Lists and PowerAutomate flows to make a points system work (List X talks to List Y when Form Z is submitted). Nothing spectacular or particularly interesting.
While building, I realize that my own personal M365's tenant account (not personal as in outside the tenant, but my work account from within the tenant) might hit a 6k PPR/day ceiling, so I request either a service account for transparency/"bus" factor or insight into how I might get a higher rate limit if that's not possible.
CTO goes into red alert. In a private meeting from which I am excluded, mentions me "reverse engineering" the Ron Clark House Points app (lol what? It's literally get/append/update flows), how Sharepoint Lists aren't as "secure" as other parts of our Azure tenant, and how not even student email should be stored in Sharepoint due to security concerns.
I feel like I'm being gaslit, but I'm hoping those with experience can help me get some insight.