Can you make a career? Possibly, in the right company. Is that your only skill though in IT? If the company you work for transitions to another a product or something better replaces it - you can find yourself out of a job with no prospects. I think within 5 years many of the things Power Automate does will be handled by AI creating the automations.
IT is a fast changing world and no matter how ubiquitous, you either become a niche dinosaur handling one or two things that are left to do a couple very specific tasks - or you transition to the new.
