Forum Discussion

AndresCacho's avatar
AndresCacho
Copper Contributor
Jan 07, 2020

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!
excel
microsoft forms
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Jan 08, 2020

Hi AndresCacho 

 

Unfortunately that's not a feature of Forms at this time. It will have to be manually populated and changed.

 

Cheers

Damien

Shahzad Syed's avatar
Shahzad Syed
Copper Contributor
Mar 22, 2021

Damien_Rosario Any updates on this? Is it possible to programmatically populate a dropdown using flow/power automate?

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Mar 22, 2021

    Shahzad Syed no it's not, there are no actions in Power Automate to do that.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • drewbennett35's avatar
      drewbennett35
      Copper Contributor
      Aug 12, 2021

      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.

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        May 19, 2022

        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)

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Aug 13, 2021

        drewbennett35 no there's no update and it doesn't appear on the Forms roadmap.

         

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

Resources