TOON with Dynamics 365 & Power Apps: Optimizing AI Integration for Enterprise
Introduction
As enterprises increasingly integrate artificial intelligence and Large Language Models (LLMs) into their business processes, the cost of data transmission to AI services becomes a critical concern. Organizations using Microsoft Dynamics 365 and Power Apps are discovering that traditional data formats—while reliable—aren’t optimized for LLM interactions.
Enter TOON (Token-Oriented Object Notation), a revolutionary data format designed specifically for AI workloads. When combined with Dynamics 365 and Power Apps, TOON can dramatically reduce API costs while maintaining data integrity and improving response times.
In this technical guide, we’ll explore how TOON transforms your Microsoft Power Platform investments and why it matters for your business.
Understanding TOON: The Token-Efficient Alternative
What Is TOON?
TOON stands for Token-Oriented Object Notation—a modern, lightweight data format engineered specifically for LLM optimization. Unlike JSON, which relies on verbose punctuation (braces, brackets, quotes), TOON uses indentation and tabular structures to represent the same data with significantly fewer tokens.
Think of it this way: Every character in JSON—including {}, [], and “” —consumes tokens when sent to an LLM. With large datasets or frequent API calls, this overhead compounds rapidly, inflating your operational costs.
Why Token Efficiency Matters
When organizations call LLM services like OpenAI’s GPT models or Azure OpenAI, they’re charged per token consumed. A typical enterprise processing thousands of records daily can burn through unnecessary tokens simply due to data format inefficiency.
Real-world impact:
- JSON representation of a user dataset: 150 tokens
- Same data in TOON format: 82 tokens
- Cost savings: 45%
Multiply this across thousands of queries monthly, and the financial impact becomes substantial.
TOON vs. JSON: A Side-by-Side Comparison
Example: User Data
JSON Format:

Token count: 68 tokens
TOON Format:

Token count: 28 tokens
Savings: 59% reduction in tokens
Integrating TOON with Dynamics 365 & Power Apps
Use Case 1: Optimizing Customer Data Queries
In Dynamics 365, customer records frequently flow through Power Automate workflows to AI services. When a cloud flow retrieves 50 customer records to generate personalized communications via an LLM, the JSON payload becomes bloated.
Implementation:
- Extract customer data from Dynamics 365 (ID, name, email, status)
- Convert to TOON format before sending to Azure OpenAI
- Reduce token consumption by 40-60%
- Generate insights faster and more economically
Code integration example:

Use Case 2: Power Apps with AI-Driven Workflows
Power Apps applications often require real-time AI analysis of business data. Consider a mobile app that processes product inventory recommendations:
Traditional approach (JSON): Send full inventory JSON → High token cost → Slower response
TOON approach: Send compact TOON-formatted inventory → Lower token cost → Faster AI response
Benefits for users:
- Mobile apps respond instantly
- AI recommendations are cost-effective at scale
- User experience significantly improves
Use Case 3: Power Automate Optimization
Power Automate cloud flows regularly transform data before sending to external services. Adding a TOON conversion step optimizes costs:

When to Use TOON: Best Practices
Ideal for TOON Implementation
- Flat, tabular datasets: User lists, product catalogs, customer records
- Prompt templates: Structured inputs to AI models
- High-volume queries: Enterprise systems processing thousands of records
- Cost-sensitive operations: Where token reduction directly impacts ROI
- Mobile applications: Where bandwidth and latency matter
When to Avoid TOON
- Deeply nested hierarchies: Complex relational structures (may increase token count)
- Loosely structured data: When object schemas vary frequently
- Legacy system integration: Where JSON compatibility is critical
Measuring ROI: Token Efficiency Analysis
Cost Breakdown Example
Scenario: Mid-sized enterprise with 5,000 daily Dynamics 365 → LLM queries
Monthly JSON costs (at typical LLM pricing):
- Average query tokens: 200
- Daily tokens: 1,000,000
- Monthly tokens: 30,000,000
- Cost (at $0.50 per 1M tokens): $15/month per model
- Annualized: $180
Monthly TOON costs (with 50% reduction):
- Average query tokens: 100
- Daily tokens: 500,000
- Monthly tokens: 15,000,000
- Cost: $7.50/month per model
- Annualized: $90
Annual savings: $90 per model
For enterprises with multiple models and workflows, savings scale significantly.
Implementation Roadmap: Getting Started with TOON
Phase 1: Evaluation (Week 1-2)
- Identify high-volume data flows in your Dynamics 365 environment
- Audit current JSON payloads and token consumption
- Calculate potential savings
- Benchmark TOON performance in your specific use cases
Phase 2: Pilot (Week 3-4)
- Deploy TOON conversion in a non-critical Power Automate flow
- Compare JSON vs. TOON results
- Measure response times and token usage
- Document performance gains
Phase 3: Rollout (Week 5+)
- Implement TOON in production Power Automate workflows
- Update Power Apps to send TOON-formatted data
- Monitor and optimize further
- Scale across the organization
Technical Integration: Code Examples
Example 1: Power Automate Custom Connector

Example 2: Power App Canvas App Integration
Within a Power App, you can call a cloud flow to convert data:

Challenges & Considerations
Challenge 1: Tool Maturity
TOON is emerging technology. Unlike JSON, tooling support isn’t ubiquitous yet. Vaden Consultancy recommends validating TOON libraries within your technical stack before production rollout.
Challenge 2: Team Training
Your development and automation teams need understanding of TOON syntax and best practices. Budget time for training and documentation.
Challenge 3: Debugging Complexity
TOON’s compact format can make debugging less intuitive than JSON. Implement proper logging and validation layers.
Mitigation Strategies
- Start with pilot projects in non-critical areas
- Maintain hybrid JSON+TOON approach during transition
- Invest in monitoring and observability
- Partner with consultants experienced in TOON implementation
The Vaden Advantage: Expert Implementation
At Vaden Consultancy, we specialize in optimizing Microsoft Dynamics 365 and Power Apps environments. Our team has extensive experience with emerging technologies like TOON and can help you:
✓ Assess current data flow inefficiencies ✓ Design TOON integration strategies aligned with your architecture ✓ Implement production-ready solutions with minimal risk ✓ Optimize ongoing performance and cost management
Conclusion: Future-Proof Your AI Integration
As AI becomes central to business operations, optimizing data transmission and LLM interaction costs isn’t optional—it’s essential. TOON represents a practical, immediate way to reduce costs while accelerating AI-powered insights in your Dynamics 365 and Power Apps ecosystem.
The question isn’t whether to adopt token-efficient formats, but when. Organizations that move early gain both cost advantages and operational efficiency.
Ready to optimize your AI integration? Contact Vaden Consultancy to explore how TOON and other emerging technologies can transform your Power Platform investments into competitive advantages.
