How can I know that a registered user in our portal completed an Embedded Microsoft Form?

%3CLINGO-SUB%20id%3D%22lingo-sub-2921643%22%20slang%3D%22en-US%22%3EHow%20can%20I%20know%20that%20a%20registered%20user%20in%20our%20portal%20completed%20an%20Embedded%20Microsoft%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHow%20can%20I%20know%20that%20a%20registered%20user%20in%20our%20portal%20completed%20(submitted)%20an%20Embedded%20Microsoft%20Form%3F%20I%20tried%20to%20reach%20the%20submit%20button%20through%20the%20DOM%20and%20add%20an%20event%20listener%20to%20trace%20this%20action%20but%20cross-frame%20scripting%20was%20blocking%20this.%20Did%20I%20miss%20something%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20suggestions%2Fguidance%20are%20welcome.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2921643%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%3CLINGO-SUB%20id%3D%22lingo-sub-2921905%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20know%20that%20a%20registered%20user%20in%20our%20portal%20completed%20an%20Embedded%20Microsoft%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205592%22%20target%3D%22_blank%22%3E%40Thoukidides%3C%2FA%3E%26nbsp%3Byou%20can%20always%20look%20at%20the%20Excel%20spreadsheet%20behind%20the%20form%20that%20stores%20the%20responses.%20Or%20you%20can%2C%20as%20we%20always%20do%2C%20build%20a%20flow%20in%20Power%20Automate%20to%20save%20every%20form%20response%20into%20a%20SharePoint%20list.%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%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2922089%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20know%20that%20a%20registered%20user%20in%20our%20portal%20completed%20an%20Embedded%20Microsoft%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922089%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20quick%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20try%20to%20be%20more%20specific.%3C%2FP%3E%3CP%3EI%20need%20to%20know%20if%20a%20user%20in%20our%20platform%20completed%20the%20survey%2C%20so%20we%20can%20show%20him%20a%20different%20survey%20%2F%20or%20hide%20the%20already%20answered%20form%20from%20his%20menu.%20This%20will%20be%20computed%20programmatically%20from%20our%20side.%20So%20does%20the%20existing%20solutions%20of%20Forms%20and%20Share%20point%20by%20any%20chance%20can%20satisfy%20something%20like%20this%3F%3C%2FP%3E%3CP%3ESo%20what%20I%20am%20asking%20is%20not%20to%20only%20store%20the%20results%20externally%20by%20Microsoft%20but%20also%20to%20store%20internally%20if%20a%20user%20answered%20or%20not%20a%20specific%20survey.%20(internally%20we%20do%20not%20care%20about%20the%20results%20as%20forms%20handle%20it)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20forward%20to%20your%20reply.%3C%2FP%3E%3CP%3EYours%20Thoukidides%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How can I know that a registered user in our portal completed (submitted) an Embedded Microsoft Form? I tried to reach the submit button through the DOM and add an event listener to trace this action but cross-frame scripting was blocking this. Did I miss something?
Any suggestions/guidance are welcome.

3 Replies

@Thoukidides you can always look at the Excel spreadsheet behind the form that stores the responses. Or you can, as we always do, build a flow in Power Automate to automatically save every form response into a SharePoint list.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Hello @RobElliott,

 

Thank you for your quick reply.

 

Let me try to be more specific.

I need to know if a user in our platform completed the survey, so we can show him a different survey / or hide the already answered form from his menu. This will be computed programmatically from our side. So does the existing solutions of Forms and Share point by any chance can satisfy something like this?

So what I am asking is not to only store the results externally by Microsoft but also to store internally if a user answered or not a specific survey. (internally we do not care about the results as forms handle it)

 

Looking forward to your reply.

Yours Thoukidides

@Thoukidides the SharePoint list could show the user's email (we always get the flow to put that in the Title column) and name, display name, employee ID etc. The same flow could send a link by email to the user with the different survey. There is an update file action for the local file system so you could possibly update a file with the details of the user then somehow use that in your internal systems but I don't really know because we never do that, the details of the responder are always saved into a SharePoint list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User