Forum Discussion
Can you populate form choices from external list i.e. Sharepoint?
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
RobElliott oh didn't know that thanks. That makes the whole process a little easier but sadly doesn't solve my next problem of asking about spoken languages since that would be a multiple choice answer at would be way better in a drop down but sadly those can't be multiple choice. I would love the option for a new possible "Other" answer to pop up whenever a previous one is filled out so the person can fill out whatever languages they speak but don't have to do so in a single text box.
But thanks for your help so far I will keep that in mind.