Forum Discussion

LouiB's avatar
LouiB
Copper Contributor
May 28, 2025

Forms

I was looking and all I found were similar questions from as far back as 2019, so assuming no solution has been made, yet?

 

Is any way to get a Form to read/populate dynamic choices for a question from an external source say a SharePoint online list?

 

This would make it easier to manage the list without having to update the form each time new options were added.

 

For example, if I had a form with a question asking for a person to assign that day to that task and the list of people available to pick from changes daily (but is scheduled a month in advance with potential last minute tweaks), I would rather pull a list from a common external source than have to update the form each day or any time a person switches days.

1 Reply

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

    Microsoft Forms has never been able to - and still can't - dynamically access data from an external source. I don't see that changing any time soon. So the only alternative is to build a form with Power Apps connected to your SharePoint list.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, Microsoft Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Resources