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...
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
Unfortunately, even when refreshing the connections in the excel file via script from PowerAutomate as suggested above, the newly inserted lines do not appear. If then open the file and do the refresh manually the news lines will appear...