In the ever-evolving landscape of low-code development, Microsoft continues to push boundaries with AI-assisted features. Today, I want to highlight one of the most impressive implementations I’ve seen recently: using Microsoft Copilot to create complex data tables in Power Apps.
The Space Debris Monitoring System Experiment
To test the capabilities of this feature, I decided to challenge Copilot with a unique scenario: building a space debris monitoring system. Rather than creating standard CRM or inventory tables, I wanted to see how Copilot would handle specialized technical requirements.
I prompted Copilot with the following request:
“I need tables for tracking orbital space debris, including size classification, trajectory data, collision risk assessments, and cleanup mission planning. Each debris object should have tracking history and potential satellite impact zones.”
What Happened Next Was Impressive
Within seconds, Copilot not only understood the request but generated a comprehensive data model with related tables:
- Orbital Space Debris – The primary table including fields for size classification and trajectory data
- Impact Zone – A related table mapping potential satellite collision areas
- Tracking History – A historical record of debris movement and observations
The system automatically established appropriate relationships between these tables, creating one-to-many connections where the debris objects link to multiple tracking records and impact zones.
The Power of Natural Language in Database Design
What’s remarkable about this experience is how it transforms database design from a technical exercise into a conversational one. Instead of manually defining tables, fields, and relationships, Power Apps users can now describe their needs in plain language.
The implications for citizen developers are significant. Complex data modeling, traditionally requiring database expertise, becomes accessible to anyone who can articulate their business requirements. This democratizes application development and accelerates the creation process.
When to Use (and When Not to Use) This Feature
Copilot shines when:
- You’re starting a new application with undefined data structures
- You need quick prototyping for complex systems
- You have unique requirements that don’t fit existing templates
However, there are limitations. While the AI generates impressive starting points, you’ll likely need to refine the schema with additional fields, validations, and optimizations. Additionally, for applications with standard requirements, using existing templates might still be faster.
The Future of Low-Code Development
This feature represents more than just a convenient shortcut—it’s a glimpse into the future of development where AI and human creativity work in tandem. As someone who’s built numerous Power Apps solutions, I’m excited about how this will transform the development process.
By removing technical barriers to database design, Microsoft is enabling more people to bring their ideas to life without becoming database experts first. This aligns perfectly with the core promise of the Power Platform: empowering everyone to build solutions.
Have you tried using Copilot to create tables in Power Apps? I’d love to hear about your experiences in the comments below.