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

 

29 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