cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Suuz
Frequent Visitor

How to extract language chosen in forms

Hi, I have a flow to update sharepoint list and send automatic email after someone registers by filling out a form.

They can choose their preferred language for filling our their form. Standard is Dutch, but can be set to English (United States).

Now I would like to know in which language they filled out the form so I can send a confirmation email and further actions in their preferred language.

 

I searched the forums online, but could not find solution.

 

Now I was trying the Expression Contrains(Collection, Value) to see if I can extract the language from the body of the reponse, but that is not working. Below is my screenshot.

 

Does anyone have an idea how to do this? 

Thanks in advance for your help!

 
Screenshot_language extract flow_2.jpg
8 REPLIES 8
CFernandes
Super User
Super User

@Suuz 

 

>>Now I would like to know in which language they filled out the form so I can send a confirmation email and further actions in their preferred language.

 

You use the Detect language action (It uses Azure cognitive Services)- 

 

Untitled.png

 

You might also want to see:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Microsoft-Flow-Cognitive-Services-Detect-Lang...

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

Suuz
Frequent Visitor

@CFernandes thanks for your response but I do not think this is what I am looking for.

I am not looking to translate text, I just want to know was chosen to complete the form.Screenshot_language at top form.png

 

@Suuz Yes, my idea was to actually check if a string filled by end user and determine the language.

 

If the it is in Dutch language > Condition>s yes, send the email with this Dutch if no then send an email with English language and that can be done using the the Connector. 

 

 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

 

gregjh60
Regular Visitor

I'm also trying to figure out what language the Form submitter chose on a form. It seems like that information should be part of the Form Response details, but I don't see it. Did you ever figure out a way to do this? I've resorted to having to separate forms (one for each language) and two separate flows (depending on which form was filled out).

BekaertDeslee
Regular Visitor

I have the same issue here. Maybe a tip that would help us to find a solution: in the Results exported into Excel, I can see the language that was used to complete the form.

BekaertDeslee_0-1624960098664.png

 

 

Any solutions to this yet? We also use the multilingual option on our form, i see it in the export data to excel, but not in the dynamic content in power automate.

marioS
Frequent Visitor

Currently facing the same issue. I have a form which can be answered in three different languages. Somehow German is kind of the "leading language" means each answer is translated into the respective german string when i use it in Power Automate to store all answers in a Sharepoint list. 

 

Any possibility to retrieve the initial language value? Anyone...?

Suuz
Frequent Visitor

Still have not figured solution to retrieve. So I just added a choice question on each form asking for preferred language and use that as input for PA flow.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,462)