Generate and send a personalised certificate to users who pass your quiz with Power Automate!

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024

Комментарии • 64

  • @TheKermit2110
    @TheKermit2110 2 года назад +7

    Watched many content creators in power platform and i think you have a real talent. I'm a power platform consultant myself and recognize the high quality delivery you have in terms of pacing, understanding and delivery. You really should consider making more content for the power platform community as i believe you have a real skill in this area.

  • @melissaolive4359
    @melissaolive4359 2 года назад +1

    For the past 6 months I have been trying to create a flow in our biz sharepoint. I have watched at least 50 different tutorials. Your training was the ONLY one that worked!!!!!! THANK YOU and GREAT job!!!!

  • @robertl.edwards1753
    @robertl.edwards1753 2 года назад +2

    Awesome, thank you! I'm contracted for a company to create training test. You helped me to save this company a lot of money by using something this company already has versus purchasing an expensive e-training program. This is a time-consuming process but worth it for the safe of staying under budget.

  • @RaeJobst
    @RaeJobst 3 года назад +2

    Thank you for sharing not just the video but the templates as well! Amazing!

  • @renzonavarro3170
    @renzonavarro3170 2 года назад +1

    Amazing, now I have to convince my boss to buy the premium features hahahaha thanks a lot man, a very especific explanation. You're the boss! Grateful from Peru

  • @margaretadamiec8740
    @margaretadamiec8740 Год назад +1

    Very grateful to have stumbled onto this video. Thank you for your work.

  • @cianancou
    @cianancou 2 года назад +2

    It's pretty crazy there isn't a built in dynamic function to pull the total marks from the quiz when the output file has the total in it.
    Really like this work around. Thank you so much.

  • @greencarlson4657
    @greencarlson4657 10 месяцев назад +1

    Thank you! This is super helpful for automating certificate completion for all kinds of applications.

  • @helbee01
    @helbee01 7 месяцев назад +2

    Thank you very much for this. It was really clear and easy to follow along with.
    This next bit might help other users who are using the New designer mode. Turn it off and revert to the old mode. The function of sending an email with a PDF attachment using the method explained in this tutorial doesn't work with the New designer mode. It sends a file which can't be opened properly. I expect this is an issue that Microsoft will deal with, but as on Jan 24, you need to use exactly the same steps as described above, but with New designer toggled off.

  • @pritishdas8530
    @pritishdas8530 2 года назад

    Your a genius'👍👍👍👍.. Great video & Rare one in youtube.. M searching same kind of video since long time but finally you made my day .. Thanku soo much

  • @sbrutcher
    @sbrutcher 20 дней назад

    Great video, thanks!

  • @shazanasabri
    @shazanasabri 22 дня назад

    Awesome, thank you so much! really helpful :))

  • @luisba1282
    @luisba1282 7 месяцев назад +1

    Excellent! U r a great teacher! Excelente Matt muchas gracias!

  • @katebrig9172
    @katebrig9172 2 года назад +1

    You are amazing! Saved the day for me!

  • @chrisknowler5657
    @chrisknowler5657 2 года назад +1

    Great tutorial Matt, you should do more , very clear and informative. 👍

  • @pngtrips6846
    @pngtrips6846 2 года назад +1

    Your video is excellent perfectly explains what I need

  • @WychfinderYT
    @WychfinderYT 2 года назад

    Matt, thank you very much for a very well presented and instructional video.

  • @gui9529
    @gui9529 Год назад +1

    This formula just absolutely does not work on my excel, I've tried everything and it keeps saying it's wrong

  • @jovaniofaccount2things512
    @jovaniofaccount2things512 2 года назад

    very simple and easy to follow. this very much worked for me. thanks.

  • @christineking96
    @christineking96 2 года назад

    This is really brilliant, so detailed and step-by-step so even I can follow it and I'm new to PowerAutomate. Just wondering which step in the process requires the Premium license?

  • @lealausecker5238
    @lealausecker5238 4 месяца назад

    Many thanks for the template, it was very helpful!
    Unfortunately, when sending emails I have the problem that the PDF documents are always sent empty even though they are saved correctly in OneDrive. Can anyone help me with this?

  • @chrismillett
    @chrismillett Год назад

    This is AMAZING. Is there any reason this wouldn’t work with a form submission rather than a quiz? Similarly, would it matter if I don’t have conditional content aside from completing the form?

  • @Animademy
    @Animademy 9 месяцев назад +1

    What is the formula for multiple answers?

  • @Vaida0505
    @Vaida0505 3 месяца назад

    Tried it in so many ways.... it does everything perfectly until the point where I need to attach the PDF to the email. it keeps on attaching empty document. Delay (2 minutes) does not help.... what could be the issue?

  • @mol_fsg3489
    @mol_fsg3489 2 года назад

    Hi, excellent video has helped me loads setting up this type of flow, HOWEVER I seem to be stuck in a rut. My spreadsheet I have created is setup exactly the same but when it populates the scores it never comes out as 100% even though the results were? I have triple checked the formula and its identical throughout for the required question responses any idea why it may be doing this? Anyone else had this issue? Thanks again great job explaining this.

  • @lewisduffy6738
    @lewisduffy6738 22 дня назад

    anyone know what to do when a question has multiple correct choices?

  • @smoker6269
    @smoker6269 2 года назад

    Great tutorial. Thank you

  • @pjakey1
    @pjakey1 5 месяцев назад

    Excellent video, one info, what if there are more than one correct answers for a question in MS form, what should the formula be on the excel sheet. Please advise anyone.

    • @lewisduffy6738
      @lewisduffy6738 21 день назад

      have you found this out yet? I am stuck with this also

  • @naderhussein8535
    @naderhussein8535 2 года назад

    this requires to make an excel sheet for every quiz and fill in the answers into it, i'd like to do that for one time only and use it with all quizzes.

  • @BloomHubX
    @BloomHubX 3 месяца назад

    what if you have multiple forms for quizzes with different number of questions

  • @mattwookie
    @mattwookie 2 года назад

    Thank you so much! It really helps me😭

  • @Minimeh3067
    @Minimeh3067 2 года назад

    Awesome video that has let me automate certification to staff who complete my training. However, I now want to populate another spreadsheet with the data from another spreadsheet. Are you able to help at all? It's just adding a flow element and I can't work it out!!

  • @mrhansros
    @mrhansros 11 месяцев назад

    god bless you man. Thank you

  • @jem777wh
    @jem777wh 11 месяцев назад

    I want to Know how to do the same thing, but with a excel file. Like a publipostage. When i selecte ok in a columb excel, there is a merge date line to thé word template. Thank you!

  • @bobclarke9294
    @bobclarke9294 11 месяцев назад

    I have tried the flow condition twice using a 25 question form and simple 4 question form and the Flow condition has failed both times? what could be wrong?

  • @sajeevraj1528
    @sajeevraj1528 Год назад

    Hi, today i tried this steps again with only one difference. I placed the excel file in SharePoint Online instead of OneDrive. But i getting error "Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.' in Condition. It seems the Score not getting populated into the excel file. Any advise on this ?

  • @TheMaccistanmassive
    @TheMaccistanmassive Год назад

    Hi Matt, such a good video.
    Is there a way to complete a flow that you've created? But also include an anonymous (no name or email address) course/class survey. So you would complete a class then a quiz on the class then complete an anonymous survey about the class, finally, be issued your certificate via email.

  • @paddymcginley
    @paddymcginley 2 года назад

    I am trying to add images (uploaded from within forms), but just getting a reference to a link in the output word doc.

  • @meretereichel9642
    @meretereichel9642 2 года назад

    Thank you for the detailed explenation. What formula do I have to enter in the Excel Spreadsheet in the score field, if in the quiz TWO answer boxes have to be checked for one question?

  • @sajeevraj1528
    @sajeevraj1528 2 года назад

    I'm not sure why, some of my answers got added into the excel with white spaces like "enter" and and the formula i not working. So for testing i reduced my scoring. Then when converting to pdf, its says bad gateway... not sure why

  • @chanelbraddy3551
    @chanelbraddy3551 2 года назад

    This tutorial was amazing! I attempted to mimic this flow and encountered an error on the Condition step. The error is, InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'. What do you anticipate I am doing wrong that is causing this error?

    • @garneshialewis5536
      @garneshialewis5536 9 месяцев назад

      Did you ever find the answer to this? I'm getting the same error.

  • @LeviBlount
    @LeviBlount 8 месяцев назад

    I get "InvalidTemplate" during the "Add a row into a table" step. I've been at this for hours. Any suggestions?

  • @Luanamarinho.m
    @Luanamarinho.m 2 года назад

    I tried to do it, but I got the following error: he error is, InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'. What do you anticipate I am doing wrong that is causing this error? plsss help me

  • @marinamatos5014
    @marinamatos5014 Год назад

    amazing tutorial thanks!! is there any trick when there is more than one correct answer in MS forms?? struggling at the moment!!

  • @christianortega1079
    @christianortega1079 Год назад

    Hello! I would like to ask for support to be able to import the file that you share of this excellent video please! What happens is that when importing the package in the Power Automate certificate import I get an error so I would greatly appreciate your support.

  • @TheCrownclown13
    @TheCrownclown13 2 года назад

    can you guide me i wanna have unique name
    sample: John Cerb is on the excel he cannot create a certificate since he created already
    can you teach how to do that?

  • @cookjone940
    @cookjone940 2 года назад +1

    Are there any ways to convert doc. to pdf without fee/charge? (premium)

    • @cookjone940
      @cookjone940 2 года назад

      @@thethirdline Thanks alot.

  • @kavitharam7315
    @kavitharam7315 2 года назад

    Hi ,Thanks for this video. How to get the rows without using onedrive

    • @kavitharam7315
      @kavitharam7315 2 года назад

      ​@thethirdline Thank you for your response. is Convert file(Preview) option only for a OneDrive? Can we use it on SharePoint?

  • @matthewmclean1799
    @matthewmclean1799 2 года назад

    Hi there, I have copied yours exactly but getting an error at the float(outputs('Get_a_row')?['body/Score']) step. I get the following error on the condition step of the flow :
    InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '45453': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
    I also get the error details: Unable to process template language expressions for action 'Condition' at line '1' and column '45453': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
    Any help would be greatly appreciated!

    • @averagediyguy80
      @averagediyguy80 9 месяцев назад

      I am getting the same thing, did you ever get a response or resolution?

    • @oscarsanchez5357
      @oscarsanchez5357 3 месяца назад

      @@averagediyguy80 the answer is to stablish both value as a int, int(outputs('Get_a_row')?['body/Score']) and int(80)

  • @user-uc5zk9gv9b
    @user-uc5zk9gv9b Год назад

    How to edit certificate name font. Video format is not working

  • @andreameras9089
    @andreameras9089 Год назад

    Hi! I just created the flow and almost worked! Im struggling with the pdf conversion. Even though I used "path" in the conversion it gives nme the error of nor finding the file. Any idea? (just in case, Im creating files in sharepoint, not one drive) thanks!!

    • @andreameras9089
      @andreameras9089 Год назад

      this is th error: The selected file doesn't exist, please select a valid file and drive.

  • @JohnWestwood-sp9vi
    @JohnWestwood-sp9vi Год назад

    Does this work for multiple choice where there are more than 1 answer for each question?

  • @sathyasekar2938
    @sathyasekar2938 2 года назад

    unable to download the template, pls share again