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
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)

      • jdunn2010's avatar
        jdunn2010
        Copper Contributor
        Apr 23, 2024
        this helped me, thanks!
    • 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