Forum Discussion

Philip Worrell's avatar
Philip Worrell
Steel Contributor
Jun 15, 2017

Change the language of a form

Anyone know how to change the language of a form?   I hope it is not changing profile or local computer settings. Just I have an international organisation who want to be able to send forms in dif...
microsoft forms
MartinHubert's avatar
MartinHubert
Copper Contributor
Jan 21, 2019

Hi Philip,

 

The language of the questions written in your form are in the language you wrote them.

So if you want a form to be available in multiple languages, you need to create multiple forms.

 

Regarding the language of the form application (words like Mandatory, Send, ...), the words used are displayed in the language of the browser. See https://support.office.com/en-us/article/language-settings-for-microsoft-forms-b282f9aa-0fe4-4290-b1e1-827a8a35ac27 for additional details on this.

 

Hope this helps.

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 07, 2019

    Hi Martin,

     

    The actual question is how to combine forms results (especially with Quiz). Assume you have few hundred people answering the forms, let say few forms on different languages with exactly the same content and you need stats for all people, not for each language group separately. Plus data is constantly updated, like repeating test for employees and entry one for newcomers. Could be done through Excel files, but without Excel connector to results for Quiz it looks bit hard.

    • mscherismith's avatar
      mscherismith
      Copper Contributor
      Nov 05, 2019

      Hi.

       

      Not sure if you still need a solution to this, but I've just done it myself.

       

      1. First of all, I created my form in English.

      2. I then translated it into the other languages I required (I used Google Translate and then had humans quality check the translations).

      3. I copied the form I'd created in English and replaced each piece of text with the translated text in the first language.

      4. I clicked on the menu icon (the three dots in the top right hand corner) then 'Multilingual'. I changed the primary language to the new language (e.g. from English to French).

      5. I copied the URL for the translated form and added the language tag to the end of the URL, e.g. &lang=fr for French or &lang=es for Spanish, etc. (You can find a list of language tags online).

      6. I repeated these steps for each language

      7. I created a SharePoint list with a column for each question in the form

      8. I used Microsoft Flow to build an automated process that does the following: any time a form is submitted, add the content into the relevant column in the SharePoint list

      9. I created one Flow per language

       

      From there I have options:

      1. I can go to the SharePoint list and download the data into an Excel file at any time

      2. I can build a flow that automates the process so that I have an Excel file that's always up to date, i.e. as soon as an entry is submitted, it gets added to the Excel file. Within that Excel file I can already have tabs containing pivot tables that allow quick analysis of large scale data.

      3. I can use Power BI to build a dashboard that will make the info easier to view for people who're not Excel experts.

       

      I hope some of that is helpful! 🙂

       

Resources