Forum Discussion
Can forms integrate with Active Directory?
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?
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)
- 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.
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
HasanZobaer-Cahill yes, that's what my app does.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- 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?
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.
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!
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!
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)- 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?
