Automated Multi-Language Translation Using AI Builder in a Power Apps Canvas App
The Challenge
The requirement is to maintain English and French values for text fields within a Power Apps Canvas App. Users could enter data in either language based on preference or region.
However, this approach introduced several challenges:
- Users often populated only one language field
- Manual translation was time-consuming
- Inconsistent translations affected data quality
- Power Automate-based solutions introduced latency
- Risk of overwriting user-entered dataThere was no out-of-the-box capability in Canvas Apps to automatically synchronize language fields in real time.
The Solution
To address this requirement, we implemented an AI-powered multi-language translation solution directly inside the Power Apps Canvas App using AI Builder prompt-based translation.
Instead of relying on Power Automate, the AI Builder model was added directly via the Data panel in the Canvas App. This allowed the app to call the AI model synchronously using Power Fx.
A custom AI Builder prompt was designed to:
- Detect the source language automatically
- Translate the text into the opposite language (English ↔ French)
- Return only the translated text without formatting
The Canvas App logic determined which field the user populated and triggered the translation only when the opposite field was empty, ensuring that user-entered data was never overwritten.
Other Features
- AI Builder was used directly inside the Canvas App (no Power Automate)
- Translation worked bi-directionally (English → French and French → English)
- Conditional logic prevented unnecessary AI calls
- Real-time translation provided a seamless user experience
- Fully aligned with Power Platform governance and security
Result
This is how we successfully maintain consistent multi-language data with minimal user effort.
- Improved data accuracy and consistency
- Eliminated manual translation effort
- Faster data entry for users
- Seamless real-time translation experience
- Scalable solution reusable across screens and forms
The solution significantly enhanced the user experience while ensuring reliable and accurate multi-language data within the Canvas App.
Before
Before implementing the solution:
- Users had to manually translate and populate both language fields
- Incomplete records were common
- Translation quality varied by user
- Data inconsistencies affected downstream processes
- Additional user effort slowed data entry
After
After implementing the solution:
- Users enter text in only one language
- The corresponding language field is auto-populated
- Consistent and accurate translations
- No manual translation effort
- Faster and more intuitive data entry experience
