Forum Discussion

Julien_Anid's avatar
Julien_Anid
Copper Contributor
Jul 05, 2020

Passing URL variable doesn't work when exporting to excel

Hello,

I have created a Forms Pro survey that contains two questions: SessionID, and Name. In addition, I have initialized a variable called SessionID.

I am passing a variable in the URL for the Session ID which is the following:

https://forms.office.com/formspro/Pages/ResponsePage.aspx?id=FORMID&ctx={"SessionID":"Social Media"}


The problem is the following:

  • When I submit my response using the above URL and I export to excel the responses, unfortunately, the SessionID column remains blank knowing that it's already passed in the URL. But it seems that the SessionID doesn't get populated when the URL is loaded.

My requirement is just to capture the session ID along with other questions and download the excel report.

Please have a look at the below screenshots:

Any idea why this problem occurs?

Can please someone explain in detail and provides an example to achieve the above scenario?

Any help will be greatly appreciated.
Thank you!

  • bullsb's avatar
    bullsb
    Copper Contributor

    Julien_Anid - this feature is not available in Forms and is available in Forms Pro. You can get the variables passed in the URL and save it.

Resources