Forum Discussion
Can you populate form choices from external list i.e. Sharepoint?
Hi. Wondering if there is any way to get a Form to read choices for a question from an external source say a SharePoint online list? This would make it easier to manage the list without havin...
PRossberg you don't have to enter the countries individually, you can drag and drop them all from Excel straight into your choice question in 1 go.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
I just discovered that you can only drag and drop one answer option at a time so this sadly does not help much in the end.
PRossberg not so. Select your list of items from Excel and copy (ctrl+c), click in the Option 1 answer and paste them in (ctrl+v) as I demonstrate in the attached video.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- I presume I just did it wrong before because it added all of the countries into the first answer option. Once again thank you very much