Building Multilingual Power Apps

In this Power Apps tutorial video, you will learn how to build multilingual PowerApps. The multilingual Power App will render the text in the language of the user's browser or preferred language set in their Microsoft 365 account profile.
You will learn the following:
✅ Detect the user's language in Power Apps
✅ Use Microsoft Translation Service to translate text
✅ Import localization excel file into Power Apps
✅ Use flow to translate text in excel file
✅ Connect to localized excel file in OneDrive / SharePoint
✅ Build dynamic translations to support multilingual Power Apps
Documentation:
docs.microsoft.com/en-us/powe...
Language function:
docs.microsoft.com/en-us/powe...
Microsoft Translator Connector:
docs.microsoft.com/en-us/conn...
Download Sample Help Desk Multilingual Power App:
github.com/rdorrani/PowerApps...
#PowerApps #Excel #PowerAutomate #SharePoint #Multilingual
Table of Contents:
00:00 - Introduction
00:55 - Help desk multilingual Power App walkthrough
02:32 - Get user's language in Power Apps
05:10 - Microsoft Translator connector in Power Apps to translate text
07:00 - Maintained localized text in an excel file & use in Power Apps
09:01 - Power Automate flow to translate text in excel file
14:10 - Import localized excel file into Power Apps & translate text
20:21 - Connect to localized excel file (business) in OneDrive or SharePoint from Power Apps
28:06 - Subscribe to Reza Dorrani channel

Must create a flow to auto like every video you upload to YT. Great content as always. 👍

[@RezaDorrani]

Thank You

[@pratafwd]

I really liked the option of uploading en excel file with the translation! It worked like a charm! Thanks

[@RezaDorrani]

Glad it helped!

[@smugada]

Great content Reza, you are litterally saving hours of research time for me.

[@RezaDorrani]

👍

[@necdetsaritas8722]

Greaaaat as always. It is so easy to learn with you. Thank you so much.

[@RezaDorrani]

You are most welcome 😊

[@sanwoolutolu4123]

As always. Top tier presentation and teaching skills. Thanks Reza

[@RezaDorrani]

Thank You for the feedback. Much appreciated!

[@svesamm]

further automate by attaching the flow to the SP list. When item created, run the flow with the new added lang. Great presentation. Thanks

[@RezaDorrani]

Thanks for watching.

[@vamsiduggineni6454]

Awesome. You just spreading knowledge for free. Kudos to you👏

[@RezaDorrani]

It's my pleasure

[@AnoopKumar-qx8to]

👍👍Great Reza Sir ..was waiting for it.

[@RezaDorrani]

Thanks Anoop

[@neethudev]

Simple and very very Informative. Great Content..!!

[@RezaDorrani]

Glad you liked it!

[@ferresferres]

very clear in details ! Thanks

[@RezaDorrani]

You are most welcome!

[@Fersbn_]

This is great! Really helpful

[@RezaDorrani]

Glad it was helpful!

[@NKBobcat]

It's amazing how your tutorials are always relevant to the app I am building. One of our subsidiaries is in Canada and the app in I am building needs to be in English and French. I just spent the last few days going to every single text attribute and label and I put in an if statement. I have a checkbox control on the home screen of the app and it says French. When the checkbox is selected, the user wants the French translation for all of the fields labels and text. I used If(chkLanguage.Value = true, "French text", "English text") For images that had text in them, we duplicated the image in French and I use the visible property to either hide or show it based on the checkbox. I wish I knew this before I did all the work. Are Canadian subsidiary has a language translation team and they provided me the French text. I guess it'll be more accurate than a translation tool can provide. It would take me two or three days to reverse all my code and add your method so now I have to debate whether I need to do it.

[@RezaDorrani]

Thanks for sharing the details of your project. I prefer the excel file technique rather than using the translator service. Moreover if we keep the excel file in OneDrive or SharePoint, we can add additional languages or update the translations on the fly without updating the Power App.

[@NKBobcat]

@@RezaDorrani Yes, that is truly the best method. Translator connector is blocked by the DLP policy at our company.

[@RezaDorrani]

@@NKBobcat Interesting

[@dominikpetri2120]

@@RezaDorrani Why Excel and not a SharePoint List? You wouldn't need the GUI function and could query the list with 2 parameters without a delegation warning, couldn't you? Although I like your collection method to query the source (Excel or SP) only once (on start) or every time the user changes the language. I always try to avoid using Excel in my PowerApps 😉 Thanks for the video. Great content as always. Here is an idea for part 2: How to localize Dropdown and other controls...

[@RezaDorrani]

@@dominikpetri2120 Excel online needs the GUID, SharePoint already has a unique ID Column. I did call out in the video that SharePoint is also an option. Loading excel within the App (import from excel) will be the fastest way to get to the data as all data is stored internally in memory. Recently, a lot of changes were made to excel connector with improved delegation & more. Localizing data is a challenge because data will more or less be stored in 1 language in backend system.

[@SAULSM17]

Very good Reza, saludos from México

[@RezaDorrani]

Thank You

[@muhannednidal3647]

Excellent video, thank.

[@RezaDorrani]

Glad you enjoyed it!

[@SHAli1474]

Amazing as always. Thanks Reza

[@RezaDorrani]

You are most welcome

[@SHAli1474]

@@RezaDorrani Just finish watching it again, as a POC coming up ;) Thanks again for a very clear and concise explanation.

[@riteshshukla4351]

Very Nice!! and helpful

[@RezaDorrani]

Thanks

[@jonathantoler787]

Thank you, the video was extremely helpful and worked like a charm. If your form has a dropdown, how do you connect the localization table to the choices in the dropdown?

[@RezaDorrani]

Choice values are loding from data source and cannot be multilingual with this technique.

[@aaron6516]

This is very helpful, is it possible for Microsoft to create it so when you start to build the app you can choose international and select languages? Then there could be logic that only allows certain text for languages that it can translate into from the primary language? This would save a ton of time during the build process for users working in one country to build one app for every language they need. Great work on this!!!

[@RezaDorrani]

Multilingual apps be design would be great. Hope MSFT is listening :)

[@soyebmalek1536]

Excellent video as always with great short/sustainable code.. Just wanted to confirm one more time, On that language Excel file Read permission will work for end users ? I came across similar situation but i learned that Edit permission is must even just to view/read the data from Excel in PowerApps. Correct me if I am wrong..

[@RezaDorrani]

I believe read permission should be enough.

[@mthotel]

Reza, this is a great tutorial, I have a SP List form I need to have available in 5 languages. The form has multiple dropdowns fields, how would I change the dropdowns to reflect the selected language? The tutorial seems to only cover labels.

[@RezaDorrani]

I dont think there is an easy option to make values multi lingual. Not something I have worked on. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@robniles3318]

Fantastic Video and very relevant to what I'm working on . One question, if you are writing your data back to SharePoint and the user has chosen another language, is it stored in SharePoint as the language they have chosen or does it or can it be stored as english?

[@RezaDorrani]

I believe it will be stored in the language it is entered in and not auto translate.

[@MrDrew4302]

Awesome video. This is exactly what I was looking for. I got everything setup the way I want it but its not defaulting to en if the browser is set to a language that’s not on my list. I have en and es in my translation list. If I set my browser to Romanian, it shows blank fields instead of defaulting to English. Thoughts?

[@RezaDorrani]

Not sure about it as I have not experienced the issue

[@pieternieuwkamer98]

Great video and great solution for column headings and text but do you know of way to get the values in Sharepoint 'choice' or 'lookup' columns in multiple languages?

[@RezaDorrani]

Thank You. You cannot bring in data in multiple languages from choices or lookups. You would have to work with your base language.

[@JohnroAngelo]

Hi Reza, this was a great video and Thank you for the tutorial. I do have a question though. When I select List rows present in a table on my flow. Under "Table" it doesnt show my table list from my Excel. Any idea why? Thanks in advance! I hope to watch more of your videos in the future!

[@RezaDorrani]

Not sure why. Video description has link to download sample solution. I would have to look at your flow in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@rishivedpathi6523]

Great Tutorial as always. What about taking user input ? how we will take the input from user based on language? In english ?

[@RezaDorrani]

User input will be in single language and so would the storing of data.

[@farhanq]

Great 👍

[@RezaDorrani]

Thank you!

[@kimdavis3945]

Thank you for this great video. I have followed your steps exactly in my app, however I have a question, when I open the app on my phone through power apps, I get an error that says 'the requested operation is invalid. Server response: Localisation failed: Expression "LanguageTag eq null" is not supported'. Do you know why it works fine on the PC but not on the app? Thanks.

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@asheerhasan5680]

Great as always. Just one thing, how to translate the collection values and drop down control values.

[@RezaDorrani]

You cannot do that unless you are using dataverse.

[@asheerhasan5680]

@@RezaDorrani thanks a lot for clearing my query.

[@santhoshamborep]

Thanks for posting videos helps me alot . Could you please make a video to setup flow for SP to send weekly excel report on every Monday morning just last 7 days with all attachment .

[@RezaDorrani]

I am planning a video on flow to get data from SharePoint. It will not include your exact use case but will help.

[@santhoshamborep]

@@RezaDorrani thank you

[@ManojKumar-zf1bi]

Thank you, sir. This video tutorial was extremely helpful in translating static (label text) data into Power Apps. Is it possible to translate the dynamic data (coming from the data source (Dataverse)) into a gallery or form control)? I have gone through many blogs and official documentation but couldn't find the possibility. I am trying to translate the language of all the information on the app into the selected language in the dropdown.

[@RezaDorrani]

You could use the translator service to translate it. But this is not something I have done.

[@tvenkatesh81]

It is really amazing to see the App in local languages. I am trying to add IN-Kannada for my app. But I use forms on all over my multiple screens. Would the language be changed for these controls also if i add the text I'd for them in excel ?

[@RezaDorrani]

You would need to write logic to change language. Nothing will change automatically.

[@ZOLTANOPS]

Very well done. Thank you!

[@RezaDorrani]

Glad you liked it!

[@ZOLTANOPS]

I do have a question. What would cause words you are trying to grab from the sheet to not show up in the app? I have a word that refuses to show up but other words in the sheet work just fine and there isnt any spelling errors.

[@RezaDorrani]

@@ZOLTANOPS Might be spelling, a space at end of word, etc.

[@ZOLTANOPS]

@@RezaDorrani turns out it was a space. Thank you for being so responsive, you are very fluent in this.

[@RezaDorrani]

@@ZOLTANOPS Glad to know it worked!

[@abhishekinvisible]

Cool

[@RezaDorrani]

👍

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

Thank you for watching Sundra

[@abdouramaneyoussoufou8789]

Great, thanks a lot. Now how to translate the values ​​of the fields?

[@RezaDorrani]

Translating values would require you to use a translator like bing or 3rd party service. Challenge is to store information in data source. More or less you will need 1 version of truth.

[@andypiker]

Translate(“Спасибо, отличный и очень полезный урок»; 🇷🇺)

[@RezaDorrani]

Translate("«добро пожаловать»")

[@savedios]

Thank you so much

[@RezaDorrani]

Most welcome

[@savedios]

@@RezaDorrani I am trying to create a floating bubble so that I can display more advanced help than what is displayed in the "tooltip". The idea is that when the mouse is over an object for 3 seconds it shows this help and also while the mouse moves over that object the help does the same, do you know if there is any control that allows me to know the position of the mouse or something similar? Thank you

[@RezaDorrani]

I'm not sure if there is a way. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com/

[@savedios]

@@RezaDorrani thanks a lot

[@FabianoSchimidt]

Reza, is there a way to apply multilingual settings to the column names in a Sharepoint list? I'd like to have a standard Sharepoint form in two languages, but I don't want to customize it with PowerApps or create a specific app for that...

[@RezaDorrani]

Not sure if thats an option. Never tried it.

[@paolovr1970]

Thanks Reza happy life

[@RezaDorrani]

Thank You

[@nagaiahyara3877]

Amazing explanation. Can we have an option to select the SharePoint list columns based on the Language. For example I have SharePoint list as data source which contains 10 fields. 5 are related to english and 5 are related to spanish like ( titleEnglish, titleSpanish etc..) If the current language is Spanish then I have to select the Spanish columns from the list and bind it to the controls on the screen and for the same to english

[@RezaDorrani]

Dynamic column selection is not an option unless you use collections. I would recommend to structure the SP list just as the excel file in the video.

[@nagaiahyara3877]

@@RezaDorrani okay. But when it comes to list we can not fix the columns. End user can add content dynamically. For each row one field will be spanish and one would be english. After getting the list data based on language can we create a collection on app start and in that collection I need to add only language related columns.If user changed language then we will user clear collect to reload collection to get data for selected language

[@RezaDorrani]

@@nagaiahyara3877 Ok. I will also recommend you check on the forums at powerusers.microsoft.com

[@sadzag]

Very helpful, Thanks. How would you handle optionsets translations? Thanks in advance

[@RezaDorrani]

Data translations would be a complex process (Specially with optionsets). I am not sure what would be the best way to handle them. I would recommend to check on the forums at powerusers.microsoft.com/

[@sadzag]

@@RezaDorrani thank you. In a simple way, I think we can use the standard translation of the Dataverse by installing language packs. Then the canvas app can retrieve the optionset in the user language.

[@RezaDorrani]

@@sadzag I have not tried that. Hence, I am not sure.

[@2007pradipta]

How we can bind to a Dropdown ? FYI dropdown is connected to SharePoint list's Choice field. Since we are storing all translation in a separate list & the choice filed only have English.

[@RezaDorrani]

I don't think it can handle multilingual with choice fields. SharePoint does have multilingual features for Pages but I believe content is entered manually for each language. If you have choice values in multiple lists, it could get quite complex to read that data based on language. Dataverse does have native multilingual capabilities for option sets. It would be a much better option.

[@akberpiracha915]

Your video is really helpful. I have coded all the same as in the video but getting this message "The requested operation is invalid. Server Response: Language failed: Expression "LanguageTag eq null" is not supported." Any suggestions

[@RezaDorrani]

Looks like some issue with your flow. I will have to look at your flow in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@nguyenminhthien3669]

Xịnn

[@RezaDorrani]

?

[@nguyenminhthien3669]

@@RezaDorrani this word means "great"

[@RezaDorrani]

@@nguyenminhthien3669 🙏

[@luiscarraquico7125]

👏

[@RezaDorrani]

Thanks

[@vishakhaprasoon3894]

Great video. Can you please suggest why i am unable to see preferred language after using office365 user connector. I can see preferred language in office account as English(Us) , however when adding in apps, the record for preferred language shows blank. Any advise how to resolve this?

[@RezaDorrani]

I am not sure why it would be empty for you & will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@SriPriya0]

Did you resolve this? I see the same behavior too. Any help is much appreciated

[@sukruthakini]

Can we change the language of text input control ie input also in non-english language ? Is this possible ?

[@RezaDorrani]

I don’t think that is possible

[@riteshshukla4351]

Can you also create a video on Visitor Register App

[@RezaDorrani]

Will add this request to backlog. I had built a sign in App for my User Group 2 years ago. Here is a quick look at it kzbin.info/www/bejne/nIjKdpWYoaqLpJI

[@terrywoodfine8848]

Hi Reza, Hopefully I can explain this correctly to you :) When creating a multilingual power app, can the drop downs in the app which are linked to the sharepoint list then be changed as well as the app text to the local language? So on the home screen you will select the language you wish to proceed in the app with, then in the app there are selection options via drop downs - these are currently in English only, and id like them to mirror the language selected on the home screen. Is this possible? If so, how is this done please?

[@RezaDorrani]

I believe data in dropdowns will be in base language. Data from data source will not be translated.

[@terrywoodfine8848]

@Reza Dorrani so is the only option to make a share point list for every language? Seems like a load of work.. or do you know of a work around?

[@RezaDorrani]

@@terrywoodfine8848 ​ I'm sure there are ways around this as well but not something I have explored. I will recommend checking on forums in case someone has built a complete multi-lingual app - powerusers.microsoft.com/

[@terrywoodfine8848]

@Reza Dorrani OK I will check that out. I just thought that there maybe a more simple solution that you were aware of. Thanks for coming back to me, especially so fast. much appreciated.

[@RezaDorrani]

@@terrywoodfine8848 There is no simple solution :)

[@jreyesvega]

Can I use and IF function with the lookUp? and put in a dropdown the lenguage selector?

[@RezaDorrani]

You can.

[@jreyesvega]

@@RezaDorrani its posible with the dropdown of languaje change the languaje the flow.. Mails and approvals?

[@RezaDorrani]

@@jreyesvega Possible

[@dishanagori6992]

How to get api key of Microsoft translator for large datasets.

[@RezaDorrani]

locoaddon.com/how-to-generate-microsoft-translator-api-key/

[@mrmozerz]

There are waaayyyy too many ads on this video. Makes learning really hard.

[@RezaDorrani]

I do not control how many ads are played. Typically, they are placed at beginning, middle and end of video which is the norm for most videos on KZbin.

[@aniketpachore6658]

Microsft Translator is asking for Connection name and Subscription key ?

[@RezaDorrani]

Check documentation on how to get that

[@sivajigade5053]

Hi sir, can you provide your course in Udemy so it will be very useful for us. Thank you

[@RezaDorrani]

I am planning to start with KZbin live training. (Content will be available for on demand viewing). kzbin.info/www/bejne/iXeZmnlslqqbqaM Udemy is something I have been thinking about.

[@sivajigade5053]

Thank you sir. We are following your videos which is very helpful for us. Can you do a complete video on canvas app design in step by step into 5 - 6 sessions which covers intermediate nd advance concepts while designing an canvas app. We need resources( excel sheet, sharepoint list - list schema while explaining in your videos ) we will also follow the steps and practice in our environment sir. Please help us. Thank you sir

[@RezaDorrani]

@@sivajigade5053 That would be in my live training sessions starting this Saturday - kzbin.info/www/bejne/iXeZmnlslqqbqaM

[@jimmyhu2565]

Thnx Reza!!! Very usefull. I added allso other collectiontable App OnStart: ClearCollect( colTabs, Table( { ID: 1, Name: "Kõik Tellimused", Logo: Icon.Tag, Language: "ee" }, { ID: 1, Name: "All Orders", Logo: Icon.Tag, Language: "en" }, etc... To get my mainmenu witch use a gallery wher I just filter: Filter(colTabs,Language=varCurrentLanguage)

[@RezaDorrani]

Thanks for watching

[@Aprendiz07]

Hi, how can I apply this to a gallery without it repeating the first value?

[@RezaDorrani]

Not sure if I understood your question? Video is on multilingual Apps. Gallery repeating is not covered.

[@2007pradipta]

How to implement currency conversion in PowerApp ?

[@RezaDorrani]

There is nothing out of the box that does that. May be a custom connector to call an API that does currency conversions. I will recommend you check on the forums at powerusers.microsoft.com/

[@sukruthakini]

Is Microsoft translator in powerapp a free service ?

[@RezaDorrani]

Up to a certain number of conversions.

[@sibaramnayak8138]

How to add Microsoft. Translator if I don't have licence.

[@RezaDorrani]

As mentioned in the video, leave subscription key empty and connect.

[@nazmulsarker3452]

Thank You for the wonderful video. I have one question, how can i make the language dropdown items value to English, Dutch, French Full Language name instead of en, nl, fr? I tried to rename the excel file LanguageTag column value to the Full Language name, It works fine, BUT the app start first time as Blank until i change the language from the dropdown. Is there any better solution how i can make language full name in the language dropdown? Thank You very much. @Reza Dorrani

[@RezaDorrani]

For the dropdown control Items property, you could pass a collection which includes Name and Tag. example: Name: French tag:fr Name is what user will select in dropdown and tag is what will be used in the code.

[@hak7136]

Hi Reza, Thank you for another great video. I was wondering on how to handle gallery items from a dataverse that need to be translated. If I want to for example display a gallery with a few columns from dataverse and I want to click a drop-down to select my language as you have, and then translate the entire dataverse gallery items. Microsofttranslatorv2 can only be used on behavioral functions and Microsoft Translator is deprecated, and sometimes throws this query parameter error when I use it on gallery items. Thank you so much for all your content

[@RezaDorrani]

I'm not sure about Data verse to be honest. I have an upcoming project where there is multilingual involved with Data verse. Might be a learning curve for me. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.