Answered

Multi language support with translation table in Dataverse

(0) Share

Report

Posted on by MSchd

I have an app that I want to set up with multi language support. Most of the translations need to be added manually which is not the issue for me. I would like to create a translation table that is filled vertically (w.r.t. language) since I want to make it easy to expand it for multiple languages. For example

id, text, language, key

0, welcome, en, welcome

1, bienvenue, fr, welcome

Ideally, I would refer from other tables to the key field and set a language in the app to determine which text value is shown. I am not sure how to set this up via relationships in dataverse. Is there a good way to do this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello, @MSchd,

You can set up multi-language support in your app using Dataverse by creating a translation table and establishing relationships with other tables. So you can start by making this table with the below columns:

Id: Unique identifier for each entry (Primary Key).

Text: The translated text.

Language: The language code (e.g., 'en' for English, 'fr' for French).

Key: A unique key that will be used to refer to this text from other tables.

Then, as you mentioned, add the translations manually:

For example:

0, welcome, en, welcome

1, bienvenue, fr, welcome

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Microsoft Business Application MVP

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @MSchd,

Multi-language support is available out-of-the-box in Dataverse. Make sure you installed the right language pack and then you can export the translations, edit the labels and re-import the translations. Here's the official Microsoft documentation on how to do so:

Enable languages (language packs): https://learn.microsoft.com/dynamics365/customerengagement/on-premises/customize/enable-additional-languages

Export translations: https://learn.microsoft.com/dynamics365/customerengagement/on-premises/customize/export-customized-entity-field-text-translation

Import translations: https://learn.microsoft.com/dynamics365/customerengagement/on-premises/customize/import-translated-entity-field-text

There's also a tool part of the XrmToolbox to facilitate this: https://www.xrmtoolbox.com/plugins/MsCrmTools.Translator/

Hope this helps!

Was this reply helpful? Yes No
MSchd 70 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response! This is exactly the table I had in mind, but I'm wondering how I can create relationships in dataverse with the key column of this table. If I understand correctly a foreign key relationship to a table's in Dataverse is always with the table's GUID? In this case that won't work as I aim to use the uniqueness constraint of the language and key columns to refer to the intended row. Is there any way to deal with this in Dataverse? I do not want to use automatic translations since we want to control the exact translations.

Was this reply helpful? Yes No
MSchd 70 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response. I had read about this, but unfortunately in our case we want to control the exact translations and not use automatic translations.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@MSchd, maybe I'm not understanding your question, but you can control the exact translations. You can set and overwrite the text as you wish 🙂

Was this reply helpful? Yes No
MSchd 70 on at

Like (0)

Report
Copy link

Link copied!

Ah sorry, I misunderstood and did not read well. I originally thought these translations can not be edited.

Was this reply helpful? Yes No