Can forms integrate with Active Directory?

[Kara Brake]

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?

[#2]

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.

[#3]

@Kara Brake - The form automatically knows your AD information when launched by you.

[#4]

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.  

[#5]

@TwinCessna not directly but it should be do-able via a flow in Power Automate:

 Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#6]

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

[#7]

I am looking to do something similar as well. I would like to have a drop down that I can search for team members in my organization. Example:

And when I select the name, I would be able to get their email address.  I would like to use this email address to use in Power Automate to send out an email to them.

[#8]

@BrianHarry1730 no, that's not possible.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#9]

@AaronMina y0u wouold have to add them to the dropdown manually /copy&paste. There is no way to programmatically add them or do any sort of lookup.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#10]

@RobElliott  That is what I definitely do not want and would be cumbersome.  :|  

I would have to add the entire company and then keep it up-to-date manually?  Is there another process that you can suggest?

[#11]

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

[#12]

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?

[#13]

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

[#14]

@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!

[#15]

@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!

[#16]

@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.

[#17]

I was looking for exactly this! So after the user clicks on his/hers name then could it be possible to auto populate Job Title, Manager and other fields in Power Apps using data from Azure Active Directory?

[#18]

@HasanZobaer-Cahill yes, that's what my app does.

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

[#19]

@RobElliott That's absolutely amazing! I have been looking into doing exactly that but I am unable to figure out how. It has almost been a month since I have been working on the Power App

(SharePoint -> Integrate -> Customize Forms).

My App looks something like this -

The "Employee Full Name" works fine as I used the "Person" type in "Add column" in SharePoint but I am unable to figure out a way to automatically fill up Job Title, Supervisor (manager), Company name, and maybe even email upon selecting the user

This is where I am trying to get the data from. Azure AD.

Could you please help me out with this. Or any guide or documentation. I would really appreciate it!

Yours sincerely,

Hasan Zobaer

[#20]

Can you please guide me on how to auto populate selected user's Job title and manager / Supervisor please, I really need help or guidance on this been looking for it for weeks.