Forum Discussion
random and shuffle questions
RiyadhHaj it's not possible for a certain number of questions to be selected randomly on Forms.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- GaryRodgersJul 21, 2022Copper Contributor
RobElliott Is there any microsoft product that could do this function at all? I could do with something that will choose x amount of questions from a bank. I don't need answers because the questions will be then printed off to be used in a job interview situation, and the interviewer will be writing the answers down.
- RobElliottJul 21, 2022Silver Contributor
GaryRodgers thinking about this a bit more, although Forms can't display a random set of questions from a bank, it would be possible if you forget using Forms and instead store the questions in a SharePoint list or an excel spreadsheet (though I prefer lists). A flow in Power Automate could then run and select 20 questions randomly from the list. I've only ever done it with selecting a single item from a list - we have it on our intranet homepage to display one randomly-selected country each day from 256. But I'm sure it could be expanded to select 20 items. I'll have a further think and post again as soon as possible.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- KC_SPAdminMar 23, 2023Copper Contributor
That is awesome. Can you show me how to do it? RobElliott