Forum Discussion
Find out in which language a form was submitted
Hello Community I've set up a Microsoft Forms in mutiple languages, so my user can choose the language in which he or she wishes to fill it out. After that, I want to automatically reach out to t...
Hello, I am also trying to find a solution to achieve this, there is a default template in MS Forms to send an custom automated email notification to the person who filled out the form in English. I am also having issues, trying to detect which language the user select in the multilingual form and then based on the language chosen translate the field names and their responses into French and send it in an automated email. Did you ever find a solution, if so how would I go about achieving this, do you create 2 variables, one called FlagEnglish, String and FlagFrench, String and create a condition if FlagEnglish is equal to "English" then send form responser English automated email notification, if no then send from responser French automated email notification? Thanks.
Hi Omar
No the issue still stands.
As a workaround I added an option field in the form to which the customer had to choose their preferred language of communication. That way I could use a case to send out mails in the correct language.
No the issue still stands.
As a workaround I added an option field in the form to which the customer had to choose their preferred language of communication. That way I could use a case to send out mails in the correct language.
- Hi KatrienVds,
You can use the following component in Power Automate: Select + New step > AI Builder, and then select Detect the language being used in text in the list of actions. From here you can use the dynamic content pop-up and enter the first field of your form. Then use an apply to each and in the box "Select an output from previous steps enter "results" in here. Then create a condition where there are two, first condition Responders email is not equal to "anonymous" && (And) Language (AI builder) is equal to "en" (for example English), then if yes, create a new step "Send an email (V2) and within the body of this email enter your email template and insert all the fields that correspond to your MS Form as you like. If no, then create several conditions to translate the text. For example: If "MS form field" is equal to the first option in the MS form question, if yes then you'll need to create a string variable for the question and in this step you'll want set the variable to the corresponding language you prefer if no "add no steps", after that you just repeat this process and at the end you'll want to add new step -> send an email and create your email template and insert all corresponding fields from your form using dynamic content. But for the responses you want translated make sure you insert the string variable instead of the form field.
