Видео

Thanks so much for your clearly explained instructions! I have managed to send certificates out for my quiz!

I am doing something wrong and I'm hoping you monitor these comments years later. I am doing a simpler version with only two questions that both need to be answered correctly to get a certificate. Each is worth 1 point and so you need 2 points to get certificate. I cannot figure out why my formula in the spreadsheet keeps adding up incorrectly. Even when the quiz is answered correctly the "score" isn't adding it up to 2. It's probably something simple but I cannot see it. Here's the formula: =SUM(IF(D3="An ABLE account", "1", "0"))+(IF(E3="TRUE", "1", "0"))

Great video, thanks!

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

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

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

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?

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?

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.

This is great. Thanks so much. Only problem is that I don’t yet know if I want to delete them. But I do not want the notifications. They are driving me mad!

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

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.

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

What is the formula for multiple answers?

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

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?

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!

god bless you man. Thank you

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 ?

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

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

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

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.

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.

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?

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

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

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!!

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.

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?

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?

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

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.

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!!

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.

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.

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

You are amazing! Saved the day for me!

Your video is excellent perfectly explains what I need

unable to download the template, pls share again

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

Great tutorial. Thank you

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

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

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?

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?

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!!!!

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

Thank you so much! It really helps me😭

thank you!!!!! my dumbass coworkers don't understand the difference between 'reply' and 'reply all'