I am new to Forms and would like to set up the ability for any internal corporate users that complete the form to have their username from AD auto-filled in the form, or in the response. However, I cannot find where AD can connect to Forms. Is this possible?

If you use the "Only people in my organization can respond" option when sharing the form, you get a column added to the responses for e-mail address and Name which both pull from Azure AD on the responses sheet when they submit their form entry, they do not see this it just auto populates in the back end.

AaronMina if all your users that you want in the dropdown are internal then you could build a form in Power Apps which has the Office 365 Users actions and can look up all staff in your organisation. But with Microsoft Forms it's not possible. I did this recently as shown below and we get the user to enter the first few letters of the name or email and then the dropdown on the right is populated. We need to filter it that way because we have 65000 staff: RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

AaronMina it was all done from a blank app with a SharePoint list as the data source. After the user enters the first few letters of the name in the inpNominee fielld, the items property for the dropdown the code is Office365Users.SearchUser({searchTerm:inpNominee.Text}) RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

AaronMina this is exactly what I am trying to create as well. An employee recognition tool that finds all the employees in the AD and also finds the relationship with its direct manager so it can send an email automatically once someone gets recognized in their team. What is the exact name of the template you found? I havent seen the "Shout out" you mentioned. Thanks!

Good point everyone, but no one really answered the question. Put another way - "Can Forms integrate with AD (or Azure AD) and provide a way to update user information fields. Specifically from the "job info" and "contact info" pages? Just my two cents.

Can forms integrate with Active Directory?

24 Replies

TwinCessna
Copper Contributor
Jul 30, 2021
Good point everyone, but no one really answered the question. Put another way - "Can Forms integrate with AD (or Azure AD) and provide a way to update user information fields. Specifically from the "job info" and "contact info" pages? Just my two cents.
- Gladys Aguilera
  Copper Contributor
  May 18, 2023
  TwinCessna I have tried this before and I dont think is implemented on MS Forms, unfortunately.
  - RobElliott
    Silver Contributor
    May 18, 2023
    Forms can't integrate with or connect to anything.
- RobElliott
  Silver Contributor
  Jul 31, 2021
  TwinCessna not directly but it should be do-able via a flow in Power Automate:
  
  Rob
  Los Gallardos
  Microsoft Power Automate Community Super User
  - BrianHarry1730
    Brass Contributor
    Aug 03, 2021
    Can you get a field in the that when selected by a user, they can search Azure AD and get the AD user details. As I have the situation, where by a teacher will be completing the form for a student, whose details will be selected from AD and updated on the form. Is this possible, if so, how can it be done please. Kind regards
    Brian
buddyreview
Copper Contributor
Jul 01, 2021
Kara Brake - The form automatically knows your AD information when launched by you.
Deleted
Jul 30, 2018
If you use the "Only people in my organization can respond" option when sharing the form, you get a column added to the responses for e-mail address and Name which both pull from Azure AD on the responses sheet when they submit their form entry, they do not see this it just auto populates in the back end.

Forum Discussion

Can forms integrate with Active Directory?

24 Replies

Resources