Passing URL variable doesn't work when exporting to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1504657%22%20slang%3D%22en-US%22%3EPassing%20URL%20variable%20doesn't%20work%20when%20exporting%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504657%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20created%20a%20Forms%20Pro%20survey%20that%20contains%20two%20questions%3A%20SessionID%2C%20and%20Name.%20In%20addition%2C%20I%20have%20initialized%20a%20variable%20called%20SessionID.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20passing%20a%20variable%20in%20the%20URL%20for%20the%20Session%20ID%20which%20is%20the%20following%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Ehttps%3A%2F%2Fforms.office.com%2Fformspro%2FPages%2FResponsePage.aspx%3Fid%3DFORMID%26amp%3Bctx%3D%7B%22SessionID%22%3A%22Social%20Media%22%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3E%3CU%3E%3CSTRONG%3EThe%20problem%20is%20the%20following%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CUL%3E%3CLI%3EWhen%20I%20submit%20my%20response%20using%20the%20above%20URL%20and%20I%20export%20to%20excel%20the%20responses%2C%20unfortunately%2C%20the%20SessionID%20column%20remains%20blank%20knowing%20that%20it's%20already%20passed%20in%20the%20URL.%20But%20it%20seems%20that%20the%20SessionID%20doesn't%20get%20populated%20when%20the%20URL%20is%20loaded.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EMy%20requirement%20is%20just%20to%20capture%20the%20session%20ID%20along%20with%20other%20questions%20and%20download%20the%20excel%20report.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20have%20a%20look%20at%20the%20below%20screenshots%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203369i3841CB1997A9B29E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture1.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203370iE9DB2C3C97C53F32%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture1.JPG%22%20alt%3D%22Capture1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3EAny%20idea%20why%20this%20problem%20occurs%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20please%20someone%20explain%20in%20detail%20and%20provides%20an%20example%20to%20achieve%20the%20above%20scenario%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20will%20be%20greatly%20appreciated.%3CBR%20%2F%3EThank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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:
Capture.JPGCapture1.JPG
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!

4 Replies

@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.

Hello @bullsb ,

I am already using Forms pro and I have created my survey using Forms pro but unfortunately, the same problem occurs.

Please have a look at the below screenshot:
(PS: I am using SessionType as a variable. In the first post, it was SessionID)

Capture.JPG


Looking forward to your response.
Thank you!

@Julien_Anid It should be a hidden field, I see its visible for the user to enter. Please check the youtube post by Megan.

 

https://www.youtube.com/watch?v=7RPMGjaP1EU&list=PLD9xXqUZnFj8eYWTN_aULBE47qslRM7et

 

Hope it meets your requirement.

Take my Microsoft Forms Pro Online Course to learn everything you need to capture, analyze, and act on customer and employee feedback with this simple-yet-po...

Hello @bullsb,

Its already hidden but here it's showing because it's not on preview mode, thanks for sharing I have already followed the same tutorial but the problem persists.

Any other suggestions?