Forum Discussion

KatrienVds's avatar
KatrienVds
Copper Contributor
May 05, 2021

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...
language
microsoft forms
power automate
ootb20229's avatar
ootb20229
Copper Contributor
Jan 15, 2025

that information is stored in a Language field in the Excel Workbook in which MS Forms syncs the data, so to retrieve that information with Power Automate
>use the Excel (Business) "Run script from Sharepoint library" action, with an Office Script that forces a refresh of all connections (use the automation recorder to generate the script); this forces the workbook to include the latest submission
>then use Excel (Business)"Get a row" to get the row with the ID from the submitted form 

klausedelmann's avatar
klausedelmann
Copper Contributor
Jan 22, 2025

Unfortunately, when refreshing the excel as suggested here via script ran by PowerAutomate, the newly inserted lines will not be found even when I wait 30 seconds before refreshing and trying to retrieve the row.

When I open the excel and run the script manually, the new lines will appear as expected.

Resources