So far some findings I came up with during last Microsoft forms troubleshooting… I’ll keep them here just as a reminder for myself or it might help you to troubleshoot Microsoft forms.
You know, a user can create a form. Then user can share it. There are two kind of links –
- to respond
- to edit/view/export results
Link to respond is kind of :
or short one: https://forms.office.com/r/kDKaHWauj7
Link “to collaborate” -e.g. with the link a person can edit and view results – is created under … “Create or duplicate”, and could be for anyone, for all people in org, and for specific people in org
if the link looks like
then it’s for specific people in org
if the link looks the same but also contains
then it’s for anyone with work or school account or for anyone in the organization
The one with the “edit” link can edit the form (including questions, answers options, and form visibility , view responses, delete responses, create a “summary link”, create a duplicate link, and export responses to excel (“Open in Excel” button). But cannot change collaboration options.
When user complete the form (after submit button), there is an option “Save my response” – if so – user will see this for with only one (his/her) response under forms app.
Collaborator is not seeing the form he/she has access to until follow the link.
Form owner can move the form to a group. If so:
- people who are group members (not only owners) will see this form under forms app – under specific group
- form id will be changed, i.e. old links will stop working
group-owned form id seemed to me little longer – 88 characters vs 80 for individual-owned forms and has no dashes.
The trick Tomasz Szypula @toszypul shared here (also citing the trick below) on how to find form owner having just “collaboration” link works like a charm! Even for deleted owner`s IDs.
If the form is owned by group – the link would be similar, but with “/group/<groupId>” instead of “/user/<UserId>” .
you can see “65714e55-87f4-49c3-b790-fc75d7349c8a” which is group Id.
Deleting user who owns forms
When a form owner user account is deleted from AAD… tbp…
Deleting a group that owns forms
When a form owner group is deleted from AAD… tbp…
Audit log events
- ListForms – Listed forms – viewed forms home page with list of forms
- ViewForm – Viewed Form –
- ViewRuntimeForm – Viewed response page
- ViewResponses- Viewed responses
- CreateResponse – Created response
- ExportForm – Exported form – “export to excel” – file saved to the local machine (form owner=user)
- ConnectToExcelWorkbook – Connected To Excel Workbook – “export to excel” – file saved to the teams SharePoint site under Documents (form owner = group)
- EnableSameOrgCollaboration –
How to find Microsoft forms form owner
(credit goes to Tomasz Szypula @toszypul )
toszypul replied to Jason_B1025 Jan 03 2022 03:17 AM - edited Jan 03 2022 03:18 AM @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=<YourFormID> -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 Graph Explorer - Microsoft Graph to run this request to retrieve the username and email address of the owner https://graph.microsoft.com/v1.0/users/<UserID>
How do I know – is it a person-owned or group-owned form
Let say you got a claim that “we were able to work with the form, and now it is gone”, and the only you have is the “collaborators” link to the form – so you can edit form, view responses etc. but nobody knows who created that form… So how to determine who owns the form – person or group and what person/group.
It is a form owned by person if
- form id is 80 characters length
- on “Export to Excel” button – it saves/downloads excel file to the file system
- “Export to Excel” button generates ExportForm – “Exported form” event in the audit log
- network trace contains “https://forms.office.com/formapi/api/<tenantId>/users/<UserId>/…”
It is a form owned by group if
- form id is 88 characters length
- on “Export to Excel” button – it saves excel file to the team SharePoint site and opens it in browser
- “Export to Excel” button generates ConnectToExcelWorkbook – “Connected To Excel Workbook” event in the audit log
- network trace contains “https://forms.office.com/formapi/api/<tenantId>/groups/<GroupId>/…”