Hi All,
I have built a multilingual app (English & French) where the users can switch between the languages using a dropdown. I made use of the Excel connector and used the below function in the "Text" property for all the cards (so that it gets the data from the Excel table):
LookUp(Table1,TextID="exampleID" And LanguageTag=setLang,LocalizedText)
This works flawlessly and I am really happy with the result.
There's just one thing the customer doesn't like: English is a default language, and so every time a French user opens the form, it opens in English. What the user needs to do, is to select "French" from the dropdown. Which they are okay with. However, if a user saves the form as a draft, then comes back some other time to fill in the rest of the fields, the form is back to "English" and they need o pick "French" from the dropdown again. (Well, this wouldn't be a problem for me, but it is for them... 😑)
Is it possible to add some function to one of the dropdown properties so that it will pick the language of the user's browser settings? (I.e., if "French" is set as a main language in Edge settings, the dropdown in the form will switch to "French" automatically).
Or maybe there would be an option to make the form "remember" the last choice in the dropdown that user had made?
Please note that I cannot use the Microsoft Translator connector - it gives a warning about "Data Loss Prevention policy violation". (That's pretty much why I used the Excel connector instead)
Please advise,
Thank you