how to import questions and answers from Excel to microsoft drive into microsoft forms

New Contributor

I am a student and need to download country dropdown - list of countries. the professor said It should be pulled from an Excel file stored in OneDrive. When a country is selected in microsoft forms, the form should display a picture of a flag for this country. The form should display a picture from this flag CDN: https://flagpedia.net/download/api. I found and made an Excel document, but I don't know what to do next.  https://csspbstu-my.sharepoint.com/:x:/g/personal/martynenko2_ap_edu_spbstu_ru/ESgtHhKhLN9Nthxzk5LRh...

2 Replies

@kofekot909 you can copy and paste the list from Excel: create a choice question, click in the first answer and then ctrl+v to paste in the list.

 

There is no facility in Forms to display the flag when a country is selected. For something like that you would need to build somenthing in Power Apps (as I did in the image below).

 

isoAirports.jpeg

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliott  thanks for your reply! Could you tell me in more detail how you managed to implement what is done in the image below in the Power Apps?