Answered

Localizing Crisis communication app

(0) Share

Report

Posted on by BartSchaap

198

I have installed the excellent Crisis communication app made by Microsoft (great job guys!). This works fine in the English language. But I want to localize it to the Dutch language. I noticed all preparations are made in the app. You can uncomment code in App.Start and set a language. But the language datasource Translations which is used to populate colTranslations is not there.

I noticed on GitHub that there is a spreadsheet which contains translations for many languages including Dutch. I feel there is just a little step to take to make this work. can somebody (@MSFT) please give some directions?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

BartSchaap 198 on at

Like
a
(0)

Report
Copy link

Link copied!

Found it myself: it is indeed simple:

////////////////////////////
/* LANGUAGE AND TIME ZONE */
////////////////////////////
// Get the locale of the logged-in user.
// Use the Language() function if you would like to automatically pull in the locale.
// Or type your locale in between the quotation marks below.
//Set(varLanguage,Coalesce("",Param("locale")));
Set(varLanguage,"nl-NL");

comment out the Set(varLanguage......
and replace it with your language as shown above 🙂

Alternative is to start the app using the parameter
Karl G. Schneider 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, indeed it is in the Apps Onstart-Property to define the Translation-Localization-ID.
But where can i adjust these translations Text Strings. How to setup this Translation Data Source. I dont find any documentation
BartSchaap 198 on at

Like
a
(1)

Report
Copy link

Link copied!

It took some for me to find out but this is how I did it @SchneidAIR:

On github there is an Excel file called 'CrisisCommunication.Translations.xlsx.' In that file there is a tabel called 'colTranslation'. (see ExcelOriginal.png)
MSFT imported this file in the PowerApp using Data Sources, Search, Excel, Import from Excel. What this does is what it says, it imports the data from the Excel file permanently into the PowerApp (it took me some time to realize this 😀) . This table name was confusing for me because of the prefix 'col'. I thought there was a collection called 'colTranslation' in the app but there isn't. So I saved the Excel file under another name and change the name of the table in the Excel file to 'vertaling' (translation in Dutch). I also changed some of the translations in the Excel file for my language (Dutch nl-NL.)
Then in the PowerApp I deleted the Excel datasource 'colTranslations' (which gets its name from the tabel in Excel). see Original.png)
Using Data Sources, Search, Excel, Import from Excel I imported my modified Excel file, this gave me a new datasource called 'Vertaling' (see step 1 in ChangeTranslations.png).
Finally I modified the code in App.Onstart as shown in 'ChangeTranslations.png) step 2, (compare this to the original). Now there is a collection called 'colTranslations containing your modified translations. The app uses this collection without further modifications giving your own language and modified text.

Hope this helps
Bart Schaap