Is there any way we can use patch to record each answer in a different list for the question and what would the query look like?? Thanks for this video as it helped me a lot
Thanks Kristof, I could probably do with your responsive skills but I guess that’s for another video.
9 месяцев назад
@@DamoBird365 I built a responsive quiz app 5 months ago I can upload it to github to turn static collections into a dynamic feed from Sharepoint lists or create a quiz questions generator copilot. To demo its building process would take a longer video for sure 👍
Nicer to trainning of employees in some specific subjects! Very good explanation. We could improve and extend to issue certificates (e.g. PDF) and also a new administrative screen to leaders create their own questions.
This was brilliant and I followed you every step and managed to set up my own quiz and was able to set up all the features you show. The only thing that did not work for me was the Patch to the original Responses List and also adding a new question in the list and then seeing it come through to the App. I did try the refresh of the source. Any ideas why that may be?
Thanks for this! Really good content and I answer yes to subscribe in your final question! It's timely as I wanted to build a quiz app. If you had time to show 1) how to have different quizzes available for selection and 2) capture the user in the list once rather than each time they do the quiz 3) retake button so to update their list item score
You need to add this to the radio button items property "ForAll(ThisItem.ShuffledAnswers, Answer)" where shuffled answers is the name of the column and then answer is the name of that column in the column. You can see this by opening the variables tab and stepping through just as shown in the video.
I want to use a gallery, but also I want to display each question one after one. If only the first question is answered the user can skip to the second question. Can I do this with a gallery structure?
Damo you're awesome! Thank you! I believe this app should not require app licenses from your users since it only uses sharepoint lists and standard connectors. Am I wrong? And hell yeah, we all want to make these quizzes dynamic based on gpt and automated processes. Im imagining a flow that kicks off when a knowledge base is updated requiring a list of people (dynamically, by department) to take a dynamic quiz, and sending them reminders until they do.
Hi!! I've been following your Power Apps videos for a while now and I love your content. I was building this quiz but all of the sudden my PowerApps stopped connecting my SharePoint list data to the gallery, I've tried recreating my SharePoint list and tested it in another computer but nothing works. Could you help me solve it?
@@DamoBird365 The gallery turns blank and in the labels text function appears "This formula uses scope, which is not presently supported for evaluation"!!
Running through this I am getting stuck on the ClearCollect in the visible for the screen. This is what I am entering and the AddColumns function is not happy: ClearCollect( colQuestions, AddColumns( Questions, Question, Title, Answers, Shuffle( Table( {Answer:AnswerA}, {Answer:AnswerB}, {Answer:AnswerC}, {Answer:AnswerD} ) ) ) ) The error messaging is a bit too vague IMHO. Thanks.
I can’t see anything wrong. Are your columns definitely the same name? Did you create the list manually? Try add columns with just question,title then if the works answers,shuffle etc. Let me know how you get on.
@@DamoBird365 So, everything is okay, but the column names I want to use (kind of like an SQL alias for a column) needs to be quoted for me. Not sure why you don't need them. But, here is the working version: ClearCollect( colQuestions, ShowColumns( AddColumns( Questions, "Question", Title, "Answers", Shuffle( Table( {Answer: AnswerA}, {Answer: AnswerB}, {Answer: AnswerC}, {Answer: AnswerD} ) ) ), "Question", "Answers") )
@@DamoBird365 This would be great to know. Really struggling with the correct formula to iterate through and get the selected values. My responses lists has a field for each answer (Answer1...Answer10). Can you point out what's wrong with this? FirstN(Filter(colQuestions,!IsBlank(radAnswers.Selected.Answer)),1).radAnswer.Selected.Answer
@saikiran7970 replying and including you in case you or anyone new needs a solution Assuming the SharePoint field's name is Answer1 you can use the Index function to grab a record, then punch down to get the selected answer like so: Answer1: Index(galQuiz.AllItems,1).radAnswers.Selected.Answer
Awesome video. I refer your videos most of the time. In this one I am getting a delegation error. UpdateContext({score:CountIf(Gallery4_1.AllItems,Radio3_1.Selected.Answer = LookUp('AI-900_MockTest_Questions',Questions=Questions).'Answer-B')}); at this section Questions=Questions, This list contains 50 question, some of them are lengthy. Can you help?
Is it to do with questions=questions? Try using the full enumeration as these are two different fields with same name. Mine were title and questions. So try nameofyourdatasource.Questions
Is there any way we can use patch to record each answer in a different list for the question and what would the query look like??
Thanks for this video as it helped me a lot
Really i love this video, i was trying for last 18months finally i did it
As always a great demo 💡🔥 Keep them coming 🚀
Thanks Kristof, I could probably do with your responsive skills but I guess that’s for another video.
@@DamoBird365 I built a responsive quiz app 5 months ago I can upload it to github to turn static collections into a dynamic feed from Sharepoint lists or create a quiz questions generator copilot. To demo its building process would take a longer video for sure 👍
Thank you so much for this tutorial, is there any option to have multiple right answers to one question?
How can i round the score? or remove the decimals? to show up the pop-up window after the submit.
@@sikandersheikh3994 learn.microsoft.com/en-us/power-platform/power-fx/reference/function-round 👍
Nicer to trainning of employees in some specific subjects! Very good explanation.
We could improve and extend to issue certificates (e.g. PDF) and also a new administrative screen to leaders create their own questions.
Thanks a lot for the informative video !
This was fantastic. Thank you so much.
This was brilliant and I followed you every step and managed to set up my own quiz and was able to set up all the features you show. The only thing that did not work for me was the Patch to the original Responses List and also adding a new question in the list and then seeing it come through to the App. I did try the refresh of the source. Any ideas why that may be?
I’m not sure if I’m honest. You could ask on the forum.
Thanks for this! Really good content and I answer yes to subscribe in your final question! It's timely as I wanted to build a quiz app. If you had time to show 1) how to have different quizzes available for selection and 2) capture the user in the list once rather than each time they do the quiz 3) retake button so to update their list item score
Thanks for those ideas 💡 I will see what else I get and maybe make a follow up video in weeks to come.
Thanks! fantastic 🎯
Hi, I'm not getting my options in radiogroup instead getting some random numbers
You need to add this to the radio button items property "ForAll(ThisItem.ShuffledAnswers, Answer)" where shuffled answers is the name of the column and then answer is the name of that column in the column. You can see this by opening the variables tab and stepping through just as shown in the video.
same here, did you find any solution?
just figured, you need add the field by clicking on Edit field in property.
I want to use a gallery, but also I want to display each question one after one. If only the first question is answered the user can skip to the second question. Can I do this with a gallery structure?
Damo you're awesome! Thank you!
I believe this app should not require app licenses from your users since it only uses sharepoint lists and standard connectors. Am I wrong?
And hell yeah, we all want to make these quizzes dynamic based on gpt and automated processes. Im imagining a flow that kicks off when a knowledge base is updated requiring a list of people (dynamically, by department) to take a dynamic quiz, and sending them reminders until they do.
Standard licenses in this demo yes. Using GPT would make it or the flow to generate them premium.
Hi!! I've been following your Power Apps videos for a while now and I love your content. I was building this quiz but all of the sudden my PowerApps stopped connecting my SharePoint list data to the gallery, I've tried recreating my SharePoint list and tested it in another computer but nothing works. Could you help me solve it?
What happens? An error? I will try but not so easy. So I cannot promise I’ll manage.
@@DamoBird365 The gallery turns blank and in the labels text function appears "This formula uses scope, which is not presently supported for evaluation"!!
Would it be possible to have 100 questions then shuffle and select a random 25. Then keep track of historical pass % on each question?
Yes, absolutely 👍
Running through this I am getting stuck on the ClearCollect in the visible for the screen. This is what I am entering and the AddColumns function is not happy:
ClearCollect(
colQuestions,
AddColumns(
Questions,
Question,
Title,
Answers,
Shuffle(
Table(
{Answer:AnswerA},
{Answer:AnswerB},
{Answer:AnswerC},
{Answer:AnswerD}
)
)
)
)
The error messaging is a bit too vague IMHO.
Thanks.
I can’t see anything wrong. Are your columns definitely the same name? Did you create the list manually? Try add columns with just question,title then if the works answers,shuffle etc. Let me know how you get on.
@@DamoBird365 So, everything is okay, but the column names I want to use (kind of like an SQL alias for a column) needs to be quoted for me. Not sure why you don't need them. But, here is the working version:
ClearCollect(
colQuestions,
ShowColumns(
AddColumns(
Questions,
"Question",
Title,
"Answers",
Shuffle(
Table(
{Answer: AnswerA},
{Answer: AnswerB},
{Answer: AnswerC},
{Answer: AnswerD}
)
)
), "Question", "Answers")
)
Awesome, but can you help how to store the selected answers into the list for the all the 10 questions
I like your suggestion, I will bear it in mind.
@@DamoBird365 This would be great to know. Really struggling with the correct formula to iterate through and get the selected values. My responses lists has a field for each answer (Answer1...Answer10). Can you point out what's wrong with this? FirstN(Filter(colQuestions,!IsBlank(radAnswers.Selected.Answer)),1).radAnswer.Selected.Answer
@saikiran7970 replying and including you in case you or anyone new needs a solution
Assuming the SharePoint field's name is Answer1 you can use the Index function to grab a record, then punch down to get the selected answer like so:
Answer1: Index(galQuiz.AllItems,1).radAnswers.Selected.Answer
Awesome
Awesome video. I refer your videos most of the time. In this one I am getting a delegation error. UpdateContext({score:CountIf(Gallery4_1.AllItems,Radio3_1.Selected.Answer = LookUp('AI-900_MockTest_Questions',Questions=Questions).'Answer-B')}); at this section Questions=Questions, This list contains 50 question, some of them are lengthy. Can you help?
Is it to do with questions=questions? Try using the full enumeration as these are two different fields with same name. Mine were title and questions. So try nameofyourdatasource.Questions