Power Apps studio includes test tools, however these are not available when you use co-authoring. So how about automated testing your Canvas Apps using Power Automate Desktop?

Another difference is that the web version of Excel supports Office Scripts but doesn’t support macros. Office Scripts can use Power Automate, while macros cannot; Power Automate allows you to ...