User dropdown

%3CLINGO-SUB%20id%3D%22lingo-sub-3213258%22%20slang%3D%22en-US%22%3EUser%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3213258%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20create%20a%20dynamic%20drop%20with%20the%20users%20in%20my%20M365%20tenant%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3213258%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3213348%22%20slang%3D%22en-US%22%3ERe%3A%20User%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3213348%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F866760%22%20target%3D%22_blank%22%3E%40TrevorG%3C%2FA%3E%26nbsp%3Bthis%20isn't%20possible%20with%20Microsoft%20Forms.%20When%20I%20need%20a%20dropdown%20for%20the%20user%20to%20select%20one%20of%20our%2065000%20staff%20I%20build%20the%20form%20in%20Power%20Apps.%20They%20enter%20the%20first%20few%20letters%20of%20the%20email%20address%20and%20then%20select%20the%20user%20from%20a%20combobox%20which%20has%20filtered%20the%20names%20down%20using%20the%20%3CSTRONG%3EOffice365Users.SearchUser%3C%2FSTRONG%3E%20function%2C%20for%20example%20Office365Users.SearchUser(%7BsearchTerm%3AinpApprover.Text%7D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22searchUser.png%22%20style%3D%22width%3A%20933px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351223i875AE8CD771B2AEB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22searchUser.png%22%20alt%3D%22searchUser.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3221863%22%20slang%3D%22en-US%22%3ERe%3A%20User%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3221863%22%20slang%3D%22en-US%22%3EThank%20you%20Rob.%20I%20was%20trying%20to%20avoid%20using%20the%20form%20in%20Power%20Apps.%20But%20this%20looks%20cool.%20I%20need%20to%20start%20using%20power%20apps.%20the%20forms%20are%20no%20where%20as%20cool%20as%20forms%20though.%3C%2FLINGO-BODY%3E
Occasional Contributor

Good Day,

 

Is there a way to create a dynamic drop with the users in my M365 tenant?

2 Replies

@TrevorG this isn't possible with Microsoft Forms. When I need a dropdown for the user to select one of our 65000 staff I build the form in Power Apps. They enter the first few letters of the email address and then select the user from a combobox which has filtered the names down using the Office365Users.SearchUser function, for example Office365Users.SearchUser({searchTerm:inpApprover.Text})

 

searchUser.png

 

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

Thank you Rob. I was trying to avoid using the form in Power Apps. But this looks cool. I need to start using power apps. the forms are no where as cool as forms though.