Forum Discussion
How to find out who created a form
- Jan 03, 2022
Jason_B1025 I was able to get the ID of the user with a bit of a hack. Here are sample steps:
-Access the form using this designer direct URL https://forms.office.com/Pages/DesignPage.aspx?origin=shell#FormId=<Here
-Inspect the network traces. You will find a request similar to this
https://forms.office.com/formapi/api/72f988bf-86f1-41af-91ab-2d7cd011db47/users/e5351c57-d147-418e-89ab-3a3d50c235b6/light/forms('v4j5cvGGr0GRqy180BHbR1ccNeVH0Y5Bias6PVDCNbZUOUg4TkZJUEswSVQ1ODhNNkpHVVlMMldPTi4u')?$select=id,...
-The ID in bold is the AAD ID of the user
-Use https://developer.microsoft.com/en-us/graph/graph-explorer to run this request to retrieve the username and email address of the owner https://graph.microsoft.com/v1.0/users/<UserID>
Jason_B1025 I was able to get the ID of the user with a bit of a hack. Here are sample steps:
-Access the form using this designer direct URL https://forms.office.com/Pages/DesignPage.aspx?origin=shell#FormId=<Here
-Inspect the network traces. You will find a request similar to this
https://forms.office.com/formapi/api/72f988bf-86f1-41af-91ab-2d7cd011db47/users/e5351c57-d147-418e-89ab-3a3d50c235b6/light/forms('v4j5cvGGr0GRqy180BHbR1ccNeVH0Y5Bias6PVDCNbZUOUg4TkZJUEswSVQ1ODhNNkpHVVlMMldPTi4u')?$select=id,...
-The ID in bold is the AAD ID of the user
-Use https://developer.microsoft.com/en-us/graph/graph-explorer to run this request to retrieve the username and email address of the owner https://graph.microsoft.com/v1.0/users/<UserID>
- Bjorn_Van_CotthemSep 22, 2023Copper ContributorThis is a life saver and should be pinned as the solution..
- solman2kDec 02, 2022Copper ContributorHello, I'm feeling a little stymied in attempting to make headway with your advice here. I'm not exactly a noobie when it comes to network traces but it has not been part of my tool box for some time. I've tried WPA and Wireshark and simply not finding anything that corresponds to the request as mentioned in your response. Hopefully you or someone else viewing this thread might provided some additional details as to process and tools used if they have been successful in gathering an owner or group GUID following this routine. Thanks in advance for any assistance.
- Gary SchultzOct 10, 2023Iron Contributor
solman2k Same here, I'm not finding /formapi/api in the network trace.
- solman2kOct 10, 2023Copper Contributor
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.
- JoshMDec 02, 2022Copper Contributor
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.
- LMelitoSep 30, 2022Copper Contributorsomebody buy this guy beer!
- MaciekParJul 04, 2022Copper Contributor
Hi, thanks for your guide, unfortunately I have an issue permission when I use "designer" URL, do you know what maybe wrong? THX for any help!
- MaciekParJul 04, 2022Copper ContributorI just found it, you don't need permission just better eyes, Thanks Tomasz!!
- toszypulJul 04, 2022Brass Contributor
MaciekPar just by looking at the screenshot it seems you might not have sufficient permissions to open the form in the form designer. I would also try to check the technical details for more insights. To confirm its a permission issue you can also ask a more privileged user (like an admin) to run the same URL and see if it works for them.
- iarichterJun 23, 2022Copper ContributorHot diggity this did it! I've been trying to figure this out all morning thank you!
- arthur26Apr 11, 2022Copper Contributor
toszypul ... how do you know what the form ID is when you only have a html link to display it?
- JoseOrneApr 13, 2022Copper Contributor
arthur26... The ID is the long value right after "FormID=" in the html link, but if you are not sure where it stops, you can get the ID by clicking Share on the form (if you are the owner/creator), then copy/paste the value to a note editor, there you would see the ID aftger "ResponsePage.aspx?id=". Hope this helps.
- SamHarrisonFeb 16, 2022Copper ContributorThis is genius! thanks for sharing, worked perfectly for finding the owner