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!

  • shaungoins's avatar
    shaungoins
    Copper Contributor

    I have been looking for something like this as they have it on the google platform.  I can't believe this simple function isn't available after all this time for a request.  AndresCacho 

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    Hi AndresCacho 

     

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

     

    Cheers

    Damien

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        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

  • DanielTroyerFST's avatar
    DanielTroyerFST
    Copper Contributor
    Upvote for this as a feature request! The next step after using a list of values from the source would be to cross-filter options based on other values selected.

    We'll probably end up using Power Automate for my use case, but it would be really nice to keep all of this in Forms. Simple validation lists in Excel should be accessible in Forms.

Resources