I would start off by reading up on Microsoft 365 development to get an idea of the modern ecosystem - then perhaps one may be able to answer ones own question.

 

As mentioned, PowerApps, Microsoft Graph, Cloud services and the Office SDK are all options - which technology is best and what effort is  required really comes down to what one wants to do. Hence my suggestion is to learn about the ecosystem in order to discover what can be done first.