{"id":6446,"date":"2022-06-22T19:07:12","date_gmt":"2022-06-22T18:07:12","guid":{"rendered":"https:\/\/rakhesh.com\/?p=6446"},"modified":"2023-05-23T16:41:27","modified_gmt":"2023-05-23T15:41:27","slug":"finding-the-owner-of-a-microsoft-form-based-on-the-form-id","status":"publish","type":"post","link":"https:\/\/rakhesh.com\/power-platform\/finding-the-owner-of-a-microsoft-form-based-on-the-form-id\/","title":{"rendered":"Finding the owner of a Microsoft Form based on the Form Id"},"content":{"rendered":"

A colleague wanted me to raise a case with Microsoft to see if there was a way to find the owner of a form based on the Id. I did a quick Google and there didn’t seem to be a way… all suggestions were to send the form link modified to open the edit mode around (https:\/\/forms.office.com\/Pages\/DesignPage.aspx?origin=shell#FormId=<YourFormID><\/code>), and see if anyone can open it. Kind of like King Arthur’s sword (\u201cWhoever pulls out this sword from this stone is the true king of England!\u201d<\/i>) or Thor’s Mjolnir (“Whosoever holds this hammer, if he be worthy, shall possess the power of Thor<\/em>“). :)<\/p>\n

It’s too hot outside and ideally I should be out walking, instead I decided to be unhealthy and sit at home and see if there’s some way to find the owner.<\/p>\n

I opened the form and went through the source code (did a quick search for words like “owner”) but didn’t find anything. Then I thought let me dig around with the “Inspect” tools.<\/p>\n

So I right clicked and selected “Inspect”. Am on Firefox.<\/p>\n

\"\"<\/p>\n

Went to the Network tab and did a Reload.<\/p>\n

\"\"<\/p>\n

First I tried the “ResponsePage.aspx” file and its Response headers… but that was just stuck. \"\"<\/p>\n

The “ResponsePageStartup.ashx” looked interesting. No idea what it is but it was the only other non JS or CSS file I found there… plus it had “Startup” in the name, maybe it does something interesting?<\/p>\n

The Response is a JSON. So I kept expanding it (started with “data”).<\/p>\n

\"\"<\/p>\n

Under “data” > “Form” I finally struck gold!<\/p>\n

\"\"<\/p>\n

Excitedly I did a Get-MgUser -UserId <theabove><\/code> and got nothing. Good thing I didn’t give up, coz I logged into Azure AD and put the Id in the main search page. Turns out it was an M365 group. Sweet!<\/p>\n

FYI, the full Url to that page is https:\/\/forms.office.com\/handlers\/ResponsePageStartup.ashx?Id=<FormId><\/code><\/p>\n

ps. The story continues…<\/a><\/p>\n

Update<\/strong>: Next time, I should use Get-MgDirectoryObject -DirectoryObjectId \"<id>\").AdditionalProperties<\/code> instead of Get-MgUser<\/code>. This will work with any object and not error out like above.<\/p>\n

Update 2 (23rd May 2023)<\/strong>: Thanks to reader Andrew Burow who wrote to say this doesn’t work if the form has expired. He came across the workaround in this forum post <\/a>and was able to get the owner id. If the form is owned by a group then the URL in the post will be \/groups\/...<\/code> instead of \/users\/...<\/code>. Thanks Andrew! :)<\/p>\n","protected":false},"excerpt":{"rendered":"

A colleague wanted me to raise a case with Microsoft to see if there was a way to find the owner of a form based on the Id. I did a quick Google and there didn’t seem to be a way… all suggestions were to send the form link modified to open the edit mode … Continue reading Finding the owner of a Microsoft Form based on the Form Id<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1027],"tags":[111],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6446"}],"collection":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/comments?post=6446"}],"version-history":[{"count":2,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6446\/revisions"}],"predecessor-version":[{"id":7100,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6446\/revisions\/7100"}],"wp:attachment":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/media?parent=6446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/categories?post=6446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/tags?post=6446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}