How to record responses from a multilingual MS form and save them into SP List using Power Automate?

[Omar_204]

Hello,

I am trying to figure out a way to record responses from a Multilingual MS Form (English & French) and record the responses into a SharePoint List using power automate flows.

I have the English form working well recording the responses into the list, but how would I go about retrieving the French equivalent questions into the same SharePoint list ?

Thank you.

[#2]

@Omar_204 

You can use the same flow for French too. If you encounter any issues in flow, please briefly describe where you're facing difficulties. In doing so, I can help you further.

If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.

Regards,
NarasimaPerumal Chandramohan
Microsoft MVP
Apps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
Product Specialist - http://www.apps4.pro/

[#3]

@NarasimaPerumal Chandramohan 

Yes, thank you so much, I was able to figure out how to add the french responses from the same form into the sharepoint list. Although, now I am trying to create  a new flow that will send an email to the form responder. I used the default template in Power Automate to accomplish this. Although, how would I adjust it so that if the user submits a french response, to send an email to the form responder in French and it will translate all content. How would I go about  doing this ?

Thank you.

[#4]

@Omar_204 

You can use the 'Translate text into another language' action to translate text into French, then insert the translated text into your email body.

[#5]

@NarasimaPerumal Chandramohan

Would this be the correct logic to translate the text and generate an automated email either in English or French depending on which language the users selects in the form ?

Thank you.

@NarasimaPerumal Chandramohan