Exploring Agency: Integrating Intelligence and Automation in Copilot Studio