cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
STA-Admin
Frequent Visitor

Select User from MS Form Dropdown

I have a question that I'm having trouble putting into words.

 

Right now, I have a flow that is triggered by a user submitting an MS Form. The flow relies upon the user entering the email of another user to work correctly (I use "Get User Profile" with the form question as an input).

 

This isn't the best way to do things because users may mistype the email. Is there some way to populate a dropdown list with every user in the organization? Better yet, can users start typing the email and a list of potential options will pop up (this is the way it works when you type in emails inside power automate).

 

I'm just looking for a more dumby proof method to select users from the organization. From what I understand, this is not possible in MS Forms. Is there another solution? 

 

Thanks for any input!

4 REPLIES 4
Nogueira1306
Super User
Super User

Hey! Sure. If you have a SP List and use Power Apps

 

Create the list with the fields from the form and, in Power apps, create a form control

There, in the combobox, you can set the combobox to be searchable 

Thanks so much for your reply. I'm afraid that, after a few hours of googling and tinkering, I'm not sure what you mean. I have a sharepoint list with the emails of all my staff. Is there some kind of tutorial for what you're talking about? I can't find one.

 

Do I need to recreate the form in powerapps or?? Sorry, I'm completely new to PowerApps so not sure where to start.

 

Edit: To clarify, can I integrate this into my existing MS Forms? Or will I have to remake everything in PowerApps?

Hey!

 

In power apps you just need to insert the form and set the data sorce

 

But you need to create the list in SP...

 

 

If you need additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

@STA-Admin- You would be using Power Apps entirely to collect the same data you were in MS Forms.  Check out https://www.youtube.com/watch?v=QhGV4AhCFRc which talks about Office365SearchUser. You might need a couple of videos to get your project rolling so search through Shane Young's YT > https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng and Reza Dorrani's YT > https://www.youtube.com/user/rezadurrani28

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,050)