SOLVED

How to find out who created a form

Brass Contributor

someone created a MS Form and embeded it on a sharepoint online page. The form is giving an error now but no one knows who created it and I can only find the URL to the form, nothing else.

How do I find the owner or take ownership so we can work on the form?

thank you

 

31 Replies

@solman2k 

 

I just used Edge (Chromium) developer tools, open the network section of this, paste in the url to the form and hit enter. Once the page fails to load, look through the request, if you don't have access you'll see a red 403 error. In this request you should see the form ID/users/USERID

That userID is the AzureAD object ID so you can use it to work out who owns the form. I've uploaded a screenshot that will hopefully help. 

 

 

Thanks Josh.

That worked.

@Josh Malik I have tried used Edge developer tools, open the network section of this, paste in the url to the form and hit enter. But, how can I do it if I can see a 401 error only?? 

3 cheers to toszypul for such a great find!

@steviebee here is a way to Inspect the Network trace. This works in Chrome and Edge (and probably any other Chromium based browser).

  • Right-click the browser page (anywhere on the page is fine) and choose Inspect
  • Go to the Network tab
    • Note: if the Inspect window is small enough, Network may be hidden in the >> menu

  • Clear any data that has already been collected (Crossed out circle 'No' icon)
  • Check the checkbox for Preserve Log
  • Make sure the log is recording (red circle with a red square inside = it is recording)
  • Browse to https://forms.office.com/Pages/DesignPage.aspx?origin=shell#FormId=<FormID> again

  • Click the down arrow icon to download the results as a .har file
    • You can give this .har file any name you want and save it anywhere you want - the file won't be needed for very long

  • Open the .har file with a text editor like Notepad or Notepad++
  • Use Ctrl+F to search for https://forms.office.com/formapi/api/
  • You will find a URL like this https://forms.office.com/formapi/api/a5cbe99f-1120-999c-a6e7-999e2c99e8c4/groups/a2579999-96b5-99b-bfc5-07d999670f99/light/forms... [a lot more URL here]
  • If it says /groups/ between the 2 IDs it is a group that owns the form. If it says /users/ between the 2 IDs it is a user who owns the form.
  • The ID after /groups/ or /users/ is the AAD ID (Azure AD ID)

To convert the AAD ID to an actual name/group, toszypul recommended Microsoft Graph, but I was able to just open up Azure AD, select groups, and search by that AAD ID. I haven't tested to see if that also works with users, but I'd assume so.

MS Graph API explorer could be a good tool to identify the profile of a user or group once you have the object Id, details as below:
1. Navigate to https://developer.microsoft.com/en-us/graph/graph-explorer
2. Login with your work or school account which is same tenant as the user/group you want to search
3. Modify the URL to https://graph.microsoft.com/v1.0/groups/{group object id} for group profile, https://graph.microsoft.com/v1.0/users/{user object id} for user profile.
4. Click "Run query" and you will get the profile including display name, email address (if applicable), etc.
This is a life saver and should be pinned as the solution..

@solman2k Same here, I'm not finding /formapi/api in the network trace. 

@Gary Schultz Actually ever since determining that the F12 Developer tool in either Chrome or Edge was the easiest option to obtain a network trace that should track an event with the described information that would contain either a user or group that "owns" a Form, @toszypul 's procedure described in earlier post has worked as described 99% of the time.

This worked wonders for me, thank you!

A little trick my boss just showed me.  Go to the URL of the form in your browser. and use f12 - ownerId is in there this URL explains it Who created this Microsoft Form? | It's Partly Cloudy (itspartlycloudy.com) @Jason_B1025 

I know how to open and look at developer tools in Edge/Chrome, but when using developer tools, where did you find something that denotes the creator/owner of the form?
I followed this article - it's exactly how with screen shots and everything. If you are worried about following links ,I pasted the text of the article below. (the original just looks much nicer) :)

https://itspartlycloudy.com/2022/01/20/who-created-this-microsoft-form/
If you have ever needed to track down the owner of a Microsoft Form, you likely have run into a dead end or a frustrating round of trial and error. Whether the Form was created for collecting data, creating a quiz for your Class Team, or some other reason I’m here to tell you there’s a better way to find some answers!

It is well documented that, as a global admin, you can transfer Forms to a new owner. However, you’ll need to know the email address of the original Form owner. There are just a few steps to take and you’ll be armed with the info you need to get that email address.

You’re going to need a couple of things (NOTE: You can likely do this with another browser/packet tracing tool, but I’m using Edge so that’s the perspective you get here):

Microsoft Edge
URL of Form in question
Azure AD PowerShell module
Start by opening Microsoft Edge, and opening DevTools by pressing F12. Once you have DevTools open, paste the Form URL into the address bar and load the Form.

Once the Form loads, navigate to Network and Fetch/XHR in DevTools


Navigation of DevTools
In the “Name” column, look for entries related to Forms. This may be something that starts with “ResponsePageStartup” or “runtimeFormsWithResponses”. There may be a couple of them so you may need to look at a few entries. What we are looking for is the one that has “form:” under “data” in the accordion menu as shown below


ResponsePageStartup entry
Expand “form:” and scroll down until you find the “ownerID” attribute which is going to correspond to the Azure Active Directory Object ID for the owner.


ownerID attribute
Now that you have the ownerID attribute handy, simply hop over to PowerShell, load the Azure Active Directory Module, and connect to your Azure tenant. I’m completely sure you can also use the MS Graph to do this but we’re using Ol’ Reliable here. You’ll be using the Get-AzureADObjectByObjectID commandlet along with the ownerID we pulled from above. (You can also just use Get-AzureADUser if you prefer.)

Get-AzureADObjectByObjectID -ObjectIds <ownerID>
Now that you have the owner info, you can proceed with transferring ownership or whatever other reason you had for needing to know the owner.

Caveats
There are a couple of caveats here. This will work if you have created a Form in Teams either by “at mentioning Forms” or natively with the Forms add-in. However, if you have a Group Form, the owner is going to be the Office 365 Group and not a specific person. Also, you’ll need to dive a little deeper into the trace to find the owner ID for a Group Form.