Forum Discussion
Can I auto populate a dropdown list from an excel file?
I want to auto populate a dropdown list answers from an existing excel file. Is there any way to achieve this? Thanks!
RobElliott Is there any update. Being able to populate an ms form from excel, Sharepoint, or MS SQL server should be a priority for Microsoft.
drewbennett35 you can copy an excel list, then click in the first answer of a choice question in Forms and do a ctrl+v paste. That will paste in all the excel rows into separate options in the choice question.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- this helped me, thanks!
- Thank you for the tip about the ctrl + v option. That really helps. If the import is more than one column I wonder what it does but will have to try. The two columns need to be merged anyway so maybe I will do that prior to copy and paste.
