Where Forms Pro Invite stores context variables when invite has just been generatd but not responded

%3CLINGO-SUB%20id%3D%22lingo-sub-1104411%22%20slang%3D%22en-US%22%3EWhere%20Forms%20Pro%20Invite%20stores%20context%20variables%20when%20invite%20has%20just%20been%20generatd%20but%20not%20responded%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104411%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EWhen%20we%20create%20a%20new%20survey%20we%20can%20add%20context%20variables%2C%20that%20might%20be%20populated%20within%20Power%20Automate%20for%20Survey%20distribution.%20(E.g.%20First%20name%2C%20Last%20name%2C%20Employee%20job).%20One%20of%20the%20variables%20we%20are%20using%2C%20is%20%E2%80%9CAbout_Whom%E2%80%9D%20the%20survey%20is.%3C%2FP%3E%0A%3CP%3EWhen%20invitation%20link%20(survey)%20is%20sent%20to%20the%20recipient%2C%20but%20hasn%E2%80%99t%20been%20responded%20yet%20%2Cwe%E2%80%99d%20like%20to%20see%20such%20records%20as%20a%20separate%20list%20on%20a%20SharePoint.%20For%20tracking%20purposes.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%E2%80%99ve%20almost%20achieved%20that%2C%20when%20we%20made%20a%20sync%20between%20SharePoint%20and%20%3CSTRONG%3EForms%20Pro%20Invite%20Entity%3C%2FSTRONG%3E%20in%20CDS.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20the%20issue%20is%20that%20%3CSTRONG%3EForms%20Pro%20Invite%20Entity%3C%2FSTRONG%3E%2C%20as%20per%20our%20understanding%2C%20doesn%E2%80%99t%20store%20the%20context%20variables%E2%80%A6%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20what%20is%20surprising%2C%20if%20you%20open%20the%20%3CSTRONG%3ESurvey%20invitation%20link%3C%2FSTRONG%3E%20or%20analyze%20the%20Survey%20response%20afterwards%20(%3CSTRONG%3EFormsProSurveyResponse%3C%2FSTRONG%3E%20Entity%20with%20%3CSTRONG%3EContextData%3C%2FSTRONG%3E%20field)%2C%20you%20can%20see%20the%20%3CSTRONG%3EContext%20variables%3C%2FSTRONG%3E%20shown%20correctly.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3EMy%20questions%20is%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EHow%20can%20we%20get%20the%20context%20variables%2C%20generated%20by%20Forms%20Pro%20Invitation%2C%20before%20the%20surveys%20is%20responded%2C%20but%20has%20already%20been%20sent%3F%3C%2FP%3E%0A%3CP%3EOr%2C%20in%20another%20words%2C%20where%20the%20%3CSTRONG%3EForms%20Pro%20Invite%3C%2FSTRONG%3E%20stores%20context%20variables%20when%20invite%20has%20just%20been%20generated%3CSTRONG%3E%3F%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EKindly%20help.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EThanks%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1104411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Hi,

When we create a new survey we can add context variables, that might be populated within Power Automate for Survey distribution. (E.g. First name, Last name, Employee job). One of the variables we are using, is “About_Whom” the survey is.

When invitation link (survey) is sent to the recipient, but hasn’t been responded yet ,we’d like to see such records as a separate list on a SharePoint. For tracking purposes.

We’ve almost achieved that, when we made a sync between SharePoint and Forms Pro Invite Entity in CDS.

But the issue is that Forms Pro Invite Entity, as per our understanding, doesn’t store the context variables…

But what is surprising, if you open the Survey invitation link or analyze the Survey response afterwards (FormsProSurveyResponse Entity with ContextData field), you can see the Context variables shown correctly.

My questions is:
How can we get the context variables, generated by Forms Pro Invitation, before the surveys is responded, but has already been sent?

Or, in another words, where the Forms Pro Invite stores context variables when invite has just been generated?

 

Kindly help.

 

Thanks

1 Reply

@Sayanika - you are creating the survey invitation using Power Automate, and passing the variables through at that time. From what you have said, you want to have those same variables added to a SharePoint list. Although there is a Context parameters field in CDS on the Survey Invitation entity, it isn't populated.

 

Why not populate your SharePoint list in the same flow where you are creating your Survey invitation record? That's where you are getting all of the values, so why not just do it at the same time?