Class Introduction
This was a Team Academy training session focused on Microsoft Copilot for PowerApps, Power Automate, OneDrive, and SharePoint. The trainer demonstrated how to use these tools to solve business problems, starting with creating a HR training management portal based on Saravanan's request. The session covered three main methods: creating apps directly through PowerApps, using AI agents in Microsoft 365 Copilot, and converting existing Excel sheets to SharePoint lists. The trainer showed step-by-step how to define business requirements using Copilot's plan creation feature, which automatically generates solutions including data tables, workflows, and apps. Several participants experienced technical difficulties accessing the required platforms, but the trainer provided alternative methods and troubleshooting guidance. The session concluded with a demonstration of how to import Excel data into SharePoint lists and set up automated workflows with reminders and approvals.
Microsoft Copilot Power Platform Training
The training session focused on exploring Microsoft Copilot for Power Platform tools including PowerApps, Power Automate, OneDrive, and SharePoint. Dinesh explained how these tools can be used together to solve business problems, using a practical example from Saravanan who requested creating an HR training management portal. The session demonstrated how to use Power Platform's AI-powered agents to automatically generate detailed requirements, processes, and data models from simple business problem descriptions. Participants were guided through logging into make.powerapps.com using Team Academy credentials, and the trainer showed how to create a training management application from scratch using the platform's plan canvas approach.
PowerApps Platform Access Issues
The team discussed access and technical issues with the PowerApps platform for students at TeamAcademy. iPhoneangrla reported persistent problems accessing the full TeamAcademy Learning Management System portal, while others experienced difficulties creating plans and generating user requirements due to potential security restrictions with company accounts. Team Academy Training provided troubleshooting guidance, including using incognito windows and specific URLs, and offered to create alternative student accounts for those still experiencing issues.
Microsoft 365 Copilot App Development
The team discussed creating apps and solutions using Microsoft 365 Copilot. The trainer demonstrated how to go from defining a business problem to creating a plan, which automatically generates solutions containing tables and workflows. They showed how to navigate to the Solutions section, select the Smart Training Hub, and create an app based on existing tables like Training Invitation and Training Request. The trainer also introduced the App Builder feature in Microsoft 365 Copilot as an alternative method for creating apps.
Related Offerings
Microsoft App Builder Access Issues
The team discussed accessing and using Microsoft's App Builder and Power Automate features. Team Academy Training explained that while App Builder is available in Enterprise plans, it may not be accessible in personal accounts due to permission restrictions. Emad and Saravanan encountered permission issues when trying to access and create apps, with Emad receiving a message about needing administrator permission to access certain records.
Microsoft 365 Copilot Training Session
The training session focused on demonstrating Microsoft 365 Copilot and Power Apps functionality, with Team Academy Training guiding participants through creating apps using App Builder. Angela successfully accessed the system using an incognito window and expressed appreciation for the training, while Illias encountered some difficulties navigating the interface but received step-by-step guidance on creating apps within specific tables. The session included a brief explanation of how Power Apps can be used to create online trackers and automate business processes, with the trainer noting that the full app creation process typically takes 10-15 minutes to complete.
Microsoft 365 Copilot Application Review
The team reviewed a Microsoft 365 Copilot Agent-created HR training portal app, demonstrating its capabilities including training management, request tracking, and departmental insights. Emad suggested creating a project management tool using the platform, which was confirmed as possible by the trainer. The session then moved to explaining a third method of creating applications using Excel sheets, where a simple project management example was demonstrated with task tracking fields including task name, due date, assigned person, and completion status.
Excel to SharePoint Conversion Training
The training demonstrated how to convert an Excel sheet into a SharePoint list using the Control-T (Ctrl-T) command to create a table format, which enables integration with Power Automate, PowerApps, and Power BI. The presenter showed the step-by-step process of importing an Excel file to create a Project Management Tracker SharePoint list, including configuring columns for title, date, task assignee, and department. The training also covered how to set up automated workflows for reminders and approval processes, and explained how Microsoft 365 Copilot AI Agents can enhance SharePoint lists by providing AI-powered analysis and notifications through Teams and email.
Excel to SharePoint Conversion Training
The training session focused on converting Excel sheets into SharePoint lists using MS365 co-pilot, with specific emphasis on creating tables using Ctrl-T functionality. Team Academy Training demonstrated how to import Excel data, create new lists from templates, and set up workflows including Power Automate and approval processes. Saravanan raised questions about date formatting issues in email notifications, which were addressed by suggesting converting text-based month entries to proper date columns. The session concluded with an announcement that the next meeting would cover AI agent creation and continue the program roadmap discussion.
Ready to turn business processes into smart, automated solutions?
