Forum Discussion
random and shuffle questions
I have a 100-question and want the quiz to select randomly 20 question of it, how can I do this?
OK, so I have something very close to what I want but this is only working on desktop versions of excel and word. I have a bank of quesitons in a spreadsheet, using the rank variable to rank quesitons, then vlookup to pull in random 5 questions.
Then in a word doc, I have copied the resulting random question and "special paste" as Paste Link (HTML Format). Each time the Word document is opened, it pulls in different random questions from the spreadsheet. Although this doesn't work when I place these docs in OneDrive, I'm guessing word and excel don't have the same funtionality as the desktop versions.
My aim, when I have created this, is to give access to managers who can use the questions when they are interviewing for jobs. Ideally so they can be printed off Iwhich is why I went for Word)
I hope all this makes sense, I've just been playing around and following some youtube videos so far. I'm not fully acquainted with Power Automate, and my organisation has not yet rolled out functionaltiy of Sharepoint so I can't use lists. Though I do have Microsoft Lists, don't know if this is the same thing or not.
Then in a word doc, I have copied the resulting random question and "special paste" as Paste Link (HTML Format). Each time the Word document is opened, it pulls in different random questions from the spreadsheet. Although this doesn't work when I place these docs in OneDrive, I'm guessing word and excel don't have the same funtionality as the desktop versions.
My aim, when I have created this, is to give access to managers who can use the questions when they are interviewing for jobs. Ideally so they can be printed off Iwhich is why I went for Word)
I hope all this makes sense, I've just been playing around and following some youtube videos so far. I'm not fully acquainted with Power Automate, and my organisation has not yet rolled out functionaltiy of Sharepoint so I can't use lists. Though I do have Microsoft Lists, don't know if this is the same thing or not.
GaryRodgers yes Microsoft Lists is the same as SharePoint lists, just a more standalone version. If you ever get Power Apps it is easy to shuffle questions from a spreadsheeet or list as Power Apps has a Shuffle function.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- Strangely enough I now have Power Apps. Our IT dept must have rolled it our over the weekend and I've been having a look. So far all I have managed to do is place a button on the screen and somehow "import" my spreadsheet which has a table of questions. I've no idea how to connect the two or make it choose a random set of questions from the bank and output them to a Word doc or Form.