SOLVED

Can I capture a Forms' questions as well as responses

%3CLINGO-SUB%20id%3D%22lingo-sub-1566603%22%20slang%3D%22en-US%22%3ECan%20I%20capture%20a%20Forms'%20questions%20as%20well%20as%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566603%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20via%20MS%20Flow%20I%20can%20capture%20a%20Forms'%20questions%20as%20well%20as%20the%20responses%2C%20does%20anyone%20know%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20scenario%3A%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Prior%20to%20heading%20out%20to%20work%20on%20a%20hitch%20(usually%202%20weeks%20on%2Foff%20cycles)%20employees%20must%20answer%20various%20HSE%20questions%3C%2FP%3E%3CP%3E-%20currently%20this%20is%20done%20via%20phone%20conversations%3C%2FP%3E%3CP%3E-%20I%20want%20to%20move%20this%20to%20MS%20Forms%20because%20it's%20perfect%20for%20that%3C%2FP%3E%3CP%3E-%20however%2C%20over%20time%20the%20pre-hitch%20questions%20will%20change%3C%2FP%3E%3CP%3E-%20for%20compliance%20reasons%20we%20need%20to%20know%20'what%20we%20asked'%20%26amp%3B%20'when'%20as%20well%20as%20the%20responses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20is%20it%20possible%20to%20capture%20questions%20%26amp%3B%20responses%20via%20a%20MS%20Form%20submit%3F%20I%20can%20easily%20capture%20and%20send%20responses%20to%20SharePoint%20but%20I%20need%20the%20questions%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%2C%20are%20the%20questions%20stored%20somewhere%20else%20tagged%20with%20a%20date%2Ftime%20eg%20in%20the%20JSON%20code%20of%20the%20flow%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%2C%20greatly%20appreciated.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1566603%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%3CLINGO-SUB%20id%3D%22lingo-sub-1567147%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20capture%20a%20Forms'%20questions%20as%20well%20as%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F471216%22%20target%3D%22_blank%22%3E%40Eelman68%3C%2FA%3E%26nbsp%3Bno%2C%20it%20isn't%20possible%20to%20capture%20the%20questions%20even%20by%20parsing%20the%20JSON%20of%20the%20response.%20If%20you%20add%20new%20questions%20you'll%20need%20to%20add%20another%20column%20into%20your%20SharePoint%20list%20for%20that%20question%20and%20the%20response%2C%20and%20then%20you'll%20need%20to%20adjust%20the%20flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I'm wondering if via MS Flow I can capture a Forms' questions as well as the responses, does anyone know?

 

My scenario: 

- Prior to heading out to work on a hitch (usually 2 weeks on/off cycles) employees must answer various HSE questions

- currently this is done via phone conversations

- I want to move this to MS Forms because it's perfect for that

- however, over time the pre-hitch questions will change

- for compliance reasons we need to know 'what we asked' & 'when' as well as the responses.

 

So, is it possible to capture questions & responses via a MS Form submit? I can easily capture and send responses to SharePoint but I need the questions as well.

 

Or, are the questions stored somewhere else tagged with a date/time eg in the JSON code of the flow?

 

Any help, greatly appreciated. Thanks

2 Replies
Best Response confirmed by Eelman68 (New Contributor)
Solution

@Eelman68 no, it isn't possible to capture the questions even by parsing the JSON of the response. If you add new questions you'll need to add another column into your SharePoint list for that question and the response, and then you'll need to adjust the flow.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

Thanks for getting back to me. I'll just have to see if I can do this some other way. Cheers