Skip to content

1. Scenarios

Adam Wójcik edited this page Aug 2, 2025 · 11 revisions

1. React to an email and resubmit the Power Automate flow

In this use case, the MCP server reads current user emails and, based on the content from the specified emails, it performs the correct action. In this case, it found the Power Automate flow mentioned in the email and resubmitted the last run.

outlook-and-power-automate.mp4

2. Get SharePoint sites usage report and generate a HTML report based on the reponse

In this use case, the MCP server generates a HTML report with SharePoint sites usage data

sharepoint-usage-html-report.mp4

3. Get Outlook total number of user mailboxes from last month and generate a PowerShell script

In this use case, the MCP server gets the total number of active user mailboxes from last month. Then it generates a PowerShell script that uses CLI for Microsoft 365 commands to do this task and generates a bat file to schedule the script.

outlook-report-and-generate-script.mp4

4. Create a sample SharePoint document library with files and folders

In this use case, the MCP server creates a document library with content types enabled and versioning turned on. Then it adds a few sample folders and files to it.

sharepoint-sample-documentlibrary-data.mp4

5. Support in creating a dev site for our SharePoint Framework project, deploying and installing the web part and adding it to a page

In this use case, the MCP server creates a new SharePoint site with a site-level app catalog. Then it deploys the SPFx project to the app catalog and installs it to the site. Then it adds a new page with a single empty section and adds the web part to this page

spfx-adds-dev-site.mp4

6. Manange Entra ID

In this use case, the MCP server is used to update user properties, assign it to be a member of a different group, and reset the user password. Then it was used to do a small clean up, removing the not used app regs. This is just an example of a few of many tasks it may perform with ease on Entra ID.

entra-id.mp4

7 Manage Microsoft Teams - add a new Team with members and additional channel and custom tab

In this use case, the MCP server is used to create a new team in Teams. It adds a welcoming post in the general channel. It adds an additional channel with a custom tab. It adds two members to this team and updates the team settings not to allow team members to create channels.

teams.mp4

8. Create a Report of Power Automate Flows That Failed in the Last 24 Hours

In this use case, the MCP server is used to retrieve a list of flows stored in the default environment. Then it gathers all failed runs from the last 24 hours, along with detailed information about the cause of each error. Additionally, the solution provides recommendations on how to resolve the errors.

473600038-b10bd2ee-1544-4a61-9836-9062c014c7c8.mp4