Build a PowerApps Quiz plus intro to controls 

Also, the Fill and Color hack is genius, I will be using a Settings page in all apps going forward

Thank you. Better news? I have a new version of this in the works. :) Should come out in the next couple of weeks.

Happy to help, there is a newer version if you want to go deeper. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MziQUOE3jNc.html

Thanks for sharing 😻

Like you want to leave comments so the next person sees them? Collections are temporary so you would have to write comments to a list or other data source.

Shane Young Great, hope you make a tutorial on that. 🙂

Thanks 😊

You are welcome. Glad it helped. :)

Randy that sounds like a tough one. Have you looked at Microsoft Forms? I think Microsoft intended that to be your answer for this problem. You could make something like you are thinking in PowerApps but it would be really complicated.

Diane I made a new version of this video. Does it help? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MziQUOE3jNc.html

Awesome. Thanks for sharing.

I will see what I can do.

@@ShanesCows I would be more interested on using this as an interactive decision tree (i.e., as you mention, going to different screens depending on your answers). Have you got a video about something similar?

You're welcome!

Yeah. Not ideal but this is a great platform. Hopefully by the time you are a pro with it they will let it out of the org.

1 - yes. 2 - yes. You need to use patch or a form but probably a patch.

I haven’t done that before but I wonder if there is a color for selected you could change to transparent. Worth a look.

You can add as many images controls to a gallery as you want.

Awesome 😎

Thank you Gerardo. Repeating tables is on my short list. Do you have an example form? I would love to see it. I do think I know how I would do it but if you will send me a form that I can use I will use it for a video. 😻 Shane at PowerApps911.com

Shane Young Hi Shane, I will create one and I will share it with you. Could be creat you explaining a repeating table! Thanks and keep going

Glad it helped.

Look for my video on security and environments 😀

Yes mam! I just ran out of time yesterday, I will do it today. I will also be out there this Thursday and Friday. If you are around I would love to catch up. I will include you on my planning email tomorrow.

OMG! I would love to sync with you! Private message me when you're in the area!

Done! powerusers.microsoft.com/t5/Video-Webinar-Gallery/PowerApps-Training-App-new-way-to-learn/m-p/106836#M201

Thanks so very much! I need to go and favorite your videos for my playlist too. It's just a matter of time but your stuff needs visibility everywhere. :)

Thanks for watching Adi! 1. Set creates a global variable. UpdateContext sets a variable just for the screen. Watch this video for a deeper dive. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e2_BGekECfY.html 2. There is a language and format property. I haven't tried either but might be worth a shot. Let me know what you find? 3. I will have to play with the exact format but I know you can use explicit references. Between you and I just avoid duplicate names. :) I added it to the list. Shane 😀

Thank you for the very quick reply. 1. Ha, you are right (how else!?), apologies. I kind of stopped listening to the second part of that video as I was looking for a way to transfer a variable from one screen to the other and after I've learnt from you how to do it my mind started thinking about the project I was working on. Re-watched carefully now, thank you for the reminder. 2. I did try both of them but it does not work, at least not in my case. Moreover, although my default Windows Regional settings are for United Kingdom, Powerapps shows the date in the Date Picker in the US format, nevermind being able to customising it. 3. Good tip, noted :).

I will ask about date picker format this week when I visit with the team.

@@ShanesCows Hi Shane. Thanks for the great tutorials - they're a massive help. I have the same issue as Adi in terms of the date. Also using UK format in Windows Regional settings, all my other Windows apps are displaying correctly, except for Power Apps. I was wondering is this isn't a browser setting that needs to be changed?

@@sanet3095 In this it's explained the use of the Language property of the Date Picker control, if you select "en-UK" that'll do it. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-date-picker

You aren’t the first person to ask. I will put it on the list of videos to make. 😀

I also would like to see a video with quiz tied to sharepoint list @@ShanesCows

I'd love to see this video too!

@@ShanesCows Did this video make it to production yet ? :)

@@ShanesCows you would really safe my ass with that Video :)

Sorry I am behind on comments. Yes you can! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html this video shows SharePoint but same for SQL

@@ShanesCowsno worries! Thanks this is amazing!

Not that I know of. Try tab?

Set(score, 0)

I think the video is called save SharePoint data. You would use the Patch function which I also have a video for.

Nope, sorry. If you need to have them multi-select you could do that with a list box or by stacking checkboxes.

Shane Young can you demo this please?

Thanks. I like your random thoughts. :) That is why I make these, to inspire people. :)

Jump around based on the answers and calculate more complex senarios

I replied to the other comment. More Ifs required. Sorry, don't have a video.

I would make it a number in SharePoint and I would use Patch. Maybe this video will help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MziQUOE3jNc.html I made a new version of this video. I think it might help.

The SharePoint column needs to be a number column

Toggle.Value will return a true false value

I finally just saved, got out of the application and back in, and it worked! But it converted the commas in semicolon on its own :S

Yes, your local language uses a , (comma) as the decimal separator so in this function you have to use a ; not a comma. Quite confusing for sure. This will help: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/global-apps

Sorry I am slow. You would need to patch them to a datasource. Toggle.Value will either be true or false based on what you clicked.

I have some videos of Excel as a data source you can adapt :) YOu will use Lookup once you add the data source.

What about something like this? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7XXo9wjnJvc.html

@@ShanesCows you're forever awesome, Shane! Thank you for your unselfish act!

I figured how to do this. Your videos have been very helpful. I just got the questions and answers from my list into separate collections and used the shuffle, first functions for the question and put that into a gallery and based of that gallery question, used the filter function from my second collection for the answer choices and put them into the radio button control. It works.

Awesome. I was going to say shuffle. You beat me to it. 😀

thanks to you Shane. You are awesome to be putting out these videos, tremendous help.

Baby steps. Don’t try to do it all at once. Do it in baby steps.

Hi Rakesh - I think I helped in the other comment? :) But in case others are looking for it I think this is a good video to help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gX5q_V3U8-s.html

Do you have something over it or the radio disabled. I have never seen it not clickable

@@ShanesCows Thanks for the response. I figured it out....For some reason, I have to hold "ALT" while selecting my option. Trying to figure out a way where the user does not need to hold ALT in order to select.

Don’t do forms. Instead take the info and patch the results to the the row. I have a video on patch if you haven’t done it before.

Thank you for your answer Shane. I watched your video on patch which was very interesting ! But I still struggle to build my quiz. What if I don't want to insert a Gallery with all the row appearing with all the details? I want to have a screen with "Name", "Surname" and a dropdown list with "Worker/Employee" then a Save button and after different screens with the quiz questions. I think I understood how to use the patch function but it seems I have to insert a gallery to do so and I do not want to have the same view as yours in the video...

I wonder if a video like this would help you understand the dropdown better? You are right, you don't need a gallery . ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pkZG2boN7jQ.html

Thanks again for you answer Shane. This video was interesting but didn't fix my problem. In fact, what I am trying to do is to create a quiz and to connect all the results in my Sharepoint list. I tried with Patch function but I am not sure my methodology is the right one. I have a "Register" screen with inputs "Name", "Surname" and a dropdown list 'Worker/Employee" then other screens with the questions. So I would like that when I register (=fill the "Name", "Surname" and dropdown menu "Worker/Employee" and then click on a button like a submit button) it creates a row in my Sharepoint List with these data. Then when I go to the Questions screens and submit the answer it fills the columns "Question1", "Question2"... in my Sharepoint List and a column "Result" as well... Hope my problem is clear I tried to first create a row with "default values" as you did in your Patch Function Video than tried to update this field with the input value but it didn't work. Thanks

Use Patch. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gX5q_V3U8-s.html

Yes. When you write the results to a data source you will have all of the info. Then you can do any type of reporting you want.

@@ShanesCows Awesome, thanks Shane!! :)

Look under the media control. Options for both.

Sorry I am behind on comments. Hopefully you got it figured out. 😀

You have to set the Items property of the Radio

Yes. You would have to add score tracking and saving to a datasource. I don’t have a video on that.

Yes with Patch

There is a Back() function in PowerApps that you can use. Or you could have the back button Navigate(ScreenYouWant) both would work 🤩

@@ShanesCows Thanks, Shane! Will it hold the previous answer when hit the back button to edit or modify the answer?

The Radio button has an OnChange event that you could have it check if the answer was correct or not and then take action from there.

I would love to but not my thing. Sorry 😐

This should help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gsk14D-CYRE.html

@@ShanesCows Thanks a ton, your videos are really helpful

Look for a video on patching. You need to patch the final score to the data source.

Need a better data model. 😀 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7XXo9wjnJvc.html

You could look at Flow. Might need a 3rd party to write to Word.

Checkbox.Value returns true or false. Store accordingly

Thanks! 😎 Hopefully someone is 333,333 one day

Look into Patch for a way to update Excel

I would it it by adding If statements. Of correct score = score + 10

Use Patch

Maybe this will help? docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-colors

Actually, with some trial and error I changed my question to a radio select one. I have 7 options that I want to give a score 1-7 depending on option selected. But I can’t seem to figure out how to do that

YOu can use an If or Switch function to set the value based on their choice.

Or is the key. If(radio.value = 1 Or radio.value =2, logic here)

If(Score

@ShanesCows I figured it out after my post now to make a certificates

You gotta a video on that tied to quiz

Yes. Have an input at the beginning. Then save their scores to a data source.

Hello, Thank you for your reply. But technically how?

I search on the Microsoft site and I can not find the process. Ideally, after the quiz, the players should register and I, I can get their score and addresses

There is a new control that gives you some options with forms. 😀

Sorry Ken I never did the scoring video for more complex. It is the same concept, just more If statements.

I have a few videos on Patch that could help.

Ryan I think this is the closest thing I have. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kWUvttbYpu4.html Hope it helps

@SagarARaghuram your answer is in 19:43, where in Q1 the variable Score is set to 25 if true or to 0 if false.

Thank you very much

I fixed that now

Sorry I am behind on comments. Glad you guys figured it out.

You have to write them to a data source.

Sorry. Maybe this is dumb but what is papps?

oh, sorry Papps was just my shorthand for Powerapps

Ha ha ha. Duh. My bad. What does your email line look like?

your the man Shane, thank you for responding: Gmail.SendEmail("rjohnson@eichenlaub.com",{Subject:Label4.Text,Body:"Cari, Please do the following: " & " "& Char(13) & Char(10) & " create opprotunity: " & opp.Text & Char(13) & Char(10) & "...Add budget: " & budget.Text & Char(13)& Char(10) & 'proj prop_1'.Text & 'proj prop_2'.Text&":"& 'proj prop_3'.Text & 'proj est'.Text & Char(13) & Char(10) & 'proj prop'.Text & Char(13) & Char(10) & 'proj prop_7'.Text & Char(10) & 'proj prop_8'.Text & Char(13) & Char(10) & 'proj prop_9'.Text & Char(13) & Char(10) & 'proj prop_4'.Text &Char(13) & Char(13) & Char(10) & 'proj prop_5'.Text & Char(13) & Char(10) &'proj prop_6'.Text & Char(13) & Char(10) & If(Toggle1_9.Value=true,"add proposal due: "&DatePicker1.SelectedDate,"")}) ;Reset(opp) ;Reset(Toggle1_6) ;Reset(Toggle1_7) ;Reset(Toggle1_8) ;Reset(Toggle1_9);Reset(Toggle1_5);Reset(Toggle1_4);Reset(Toggle1_3);Reset(Toggle1);Reset(Toggle1_1);Reset(Toggle1_2);Reset('proj prop_3');Reset(budget)

I haven’t sent an email with or to gmail but I will test it out later today and let you know what I get. When I send with Outlook to Outlook I only use Char(10). Very interesting. I wonder if Google is stripping them out to be “helpful”?

Sorry I don’t understand

Set(variable, 0) would set the value to zero