Forum Discussion

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

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)

HasanZobaer-Cahill

Copper Contributor

Jun 02, 2022

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?

HasanZobaer-Cahill
Copper Contributor
Jul 06, 2022
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.
HasanZobaer-Cahill
Copper Contributor
Jun 10, 2022
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
RobElliott
Silver Contributor
Jun 03, 2022
HasanZobaer-Cahill yes, that's what my app does.

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