Not sure If Copilot Studio can do this

Yes, this can be built in Microsoft Copilot Studio. Copilot Studio would act as the conversational layer, while Azure APIs, Power Automate agent flows, or custom connectors retrieve the required data.

A possible design would be:

• User authentication: Configure Microsoft Entra ID authentication so the user signs in through the agent. The agent can then access Azure using the signed-in user’s permissions instead of asking them to manually log in to the Azure portal.
• List Azure subscriptions: Create an agent tool or flow that calls the Azure Resource Manager API to retrieve the subscriptions the user can access. The agent can display them using an Adaptive Card or selection list.
• Select a subscription: Store the selected subscription ID in a Copilot Studio variable so it can be passed to the other tools during the conversation.
• Get current charges: Use the Azure Cost Management API through an agent flow or custom connector to return month-to-date cost, forecasted cost, or cost grouped by resource group or service. The user must have permission to view cost information.
• List Advisor recommendations: Call the Azure Advisor API or query Azure Resource Graph to retrieve recommendations related to cost, security, reliability, performance, and operational excellence.
• Find resources with errors or warnings: Combine Azure Resource Health, Azure Monitor alerts, and Activity Log data. This allows the agent to show unhealthy resources, active alerts, failed deployments, and recent management errors.
• List resources created in the past 24 hours: Query Azure Resource Graph Change Analysis and filter for resources with a "Create" change during the previous 24 hours.
• Present a summary: The agent can use generative orchestration to combine the results into a single environment overview and allow users to ask follow-up questions such as “show only critical alerts” or “which resources cost the most?”

For a low-code solution, each operation can be implemented as a separate Power Automate agent flow. For a more scalable production solution, the Azure operations could be exposed through an Azure Function or API Management service and added to Copilot Studio as custom tools.