Forum Discussion

Kara Brake's avatar
Kara Brake
Copper Contributor
Jul 30, 2018

Can forms integrate with Active Directory?

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 ...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Feb 09, 2022

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:

 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

AaronMina's avatar
AaronMina
Copper Contributor
Feb 09, 2022
Your example is exactly what I am trying to build for our HR team! I will look into Power Apps and see how I can accomplish this. Thanks!

Is there a template you used for this or is it all created from a blank app?
  • AaronMina's avatar
    AaronMina
    Copper Contributor
    Apr 11, 2022

    sarahtchechel When you go into the PowerApps from the list of Apps your company uses:

     

    Click on Create

     

    Then search the templates:

     

    I would suggest selecting tablet, but create one of each to see the differences yourself:

     

    I haven't had too much time to play around with it, but it seems like it is alright.

     

    It integrates within Teams:

     

    Hope this helps out.

  • sarahtchechel's avatar
    sarahtchechel
    Copper Contributor
    Apr 11, 2022

    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!

  • AaronMina's avatar
    AaronMina
    Copper Contributor
    Feb 10, 2022

    RobElliottThanks for that!

     

    I see there is a template for "Shout outs"  I am going to mess with that to see if that fulfills my requirements, but will definitely look into some more custom work.  There are other teams that can make use of this as well. 

     

    What a nice hidden utility!

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Feb 10, 2022

    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})

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources