Unanswered

Run an Office Script in Excel when a Microsoft Forms response is received

(0) Share

Report

Posted on by Community Power Pla...

Hi I would like to confirm how to pass the Microsoft Forms response to the Office script of Excel as a parameter, add a parameter to the script and use the Microsoft Forms response as the value for that parameter when use this template:

Run an Office Script in Excel when a Microsoft Forms response is received.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report

Hey @Anonymous

So for this you need to choose enter custom value from the Script dropdownlist and then you can grab from the dynamic content the response item corresponding.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

HI @alaabitar Thank you for your reply.
As my understanding, the script should be created in Web Excel, I can grab the Response ID but how to write it in the Script. Could you please kindly give me more details?

Was this reply helpful? Yes No