Leyla Gharani you are very professional lecturer. Great videos, and most importantly with min or no music background which is distracting always. Many thanks to you.
Great video, as always! Did you know quizzes in MS Forms do not provide the global test score? For teachers that is disappointing. The way I figured out using Power Automate was by adding all student's answers to Excel and compare with a table of correct answers. Since all student scores are in the same place, now it's very easy to share with students their incorrect answers along with links to study material related with each topic. But even more interesting, average scores can be sent to students automatically as well, after each test is submitted or periodically as in my case. The potential is gigantic. A video from you oriented to teachers to automate quizzes would delight such audience.
You can download the full form results using a hidden api ua-cam.com/video/eq6QRz29q9Q/v-deo.html and this includes the answers and a total. No need to trigger on each response or save to excel/list.
@DamoBird365, thank you for the API clue. I will take a look on that. To download the Excels is good at least for archiving purpose. Yet, the key here is to trigger automations for every quiz answered among a set of tens of quizzes, like recommend new lectures for incorrect answers or deliver automated reports weekly with average scores by subject matter or global. That requires a single central Excel table or database. In this scenario there is no need to download the Excels.
Great flow and yes I want to have a meeting with you. Condition, when I select "yes", you will receive an email notification of the restaurant I want to buy you dinner at.
@LeilaGharani can you also make a video on how to do this when using a group form. I also want to set up responses to go to multiple people within my team.
Leila, I have a challenge for you (I think). I'm not a savvy Excel user but I'm quick to learn. Point is, I don't possess the jargon to query my Excel problem in your channel to find out if you have already covered my problem, but I tried. So, at the risk of redundancy - allow me to pose my Excel problem that you can refer me to a video link covering my query, otherwise, this may be a new one for you. Either way, I am confident in you. I do valuations as part of my work involving long-hand calculations with +/- equations that I wish to bypass with single data entry on a preformatted template to extend values for a quicker work process. The problem is ascribing percentage values for a set of value ranges. Example, basis: 1,000 to 2,000 = -/+20%. What is the cell formula for a value range of say 1,528 (1222 to 1,834)? While also affixing monetary values to certain Yes No values? I hope this isn't asking too much... by the way, how can I know if are responding to me?
thank you! this is very helpful :) but is there any way for the responders receive a personalized email based on their total marks? for example, when students complete the quiz on forms, the ones with good result (eg: 10/10) will get a different response compared to the others with 4/10 result. Thank you and hope you will be able to help me with this 🙂
A great demo Leila, thank you, though I was hoping to see the responses included in the email body, as I've been having some trouble inserting them as a table.
@LeilaGharani can you please do a video on how to insert signatures in emails in power automate? emails sent on recurring flows are not sent with professional signatures. i noticed there is no video on it in youtube perhaps you could do one on it. Thanks
Very well explained indeed! (but also a little scary!) How would be able to type out a new email, add a MS Forms multiple choice question, and then send out to the recipients? (without them being able to view the report of who responded etc? I'm an old guy learning new tricks !!
Great video thank you for creating/sharing this! Updated: I missed a step when I created the form "Get email Notification of each response" was not checked.
Thank you for making this tutorial though. I was looking for the google form exact the same linkage, is there any way to do that through add-ons? I will highly appreciate your respond to this. Thank you
Hi, great video. Is it also possible to fill the form with multiple people based on certain entries within the form? So as example the form should go through a whole department consisting of 6 groups and each group needs to fill in information in the form and then the form is send to the next group until all 6 groups have entered their information. It could also be that based on certain form entries that only lets say 4 out of the 6 groups need to enter information, so there should be also different branches to steer the form through the needed groups. Thanks in advance!
wow been seaching for clear video and this is it. However the form i have built requires the email to go to someone else not me. My form has a multi answer question regarding what site you work at with 3 different sites. Whichever site is selected a different person will get the email for a uniform request. I have followed your steps and when you get to condition i have added another 2 steps and when i test all 3 run succsessfully. My problem is each of the 3 answers needs to go to a different email address and non of them are mine. Anybody out there point me in the right direction please...
Hi - amazing content! I go to click my Conditioning and I am not seeing my Form questions listed.. I only get "response ID, Resource Data, or Body" to choose from. How do you get your questions to be available there?
Finished your Power Query classics on Udemy. That was bomb. When are you releasing your classic on Power BI 😁? I have studied like two (Foundation and Advanced) by other tutors on Udemy, but I would buy yours because it's gonna be something different.
Great video thank you so much. Is there a way to trigger a form from particular cell or a row from Excel and response to that form should be saved in the same row/cell from wr it was triggered?
Can you create a form where someone inputs information and then an email is sent to the customer dependent on what information they have entered into the form. eg. I create a form for different type of sushi orders. The customers enter what sushi they would like. Then an automatic email is sent to the customer, stating what they ordered, the total and when they can pick up their order etc.
Hi Leila, must say this tutorial was such a simplified demo. I already tried one automation successfully. One thing I wanted to know is if there's a way grant view only visibility to the response statistical visual of the forms page in the same automation.
I want the auto mail to be assigning a serial number to responder as they fill the form Then when i clear response, the serial number should reset from 1
Hello. For me, the 2nd step (get response details) always automatically change into 'for each loop' when I selected 'Response Id'.. Is there a workaround for this issue?
This is very helpful and might solve a problem for a project we are working on. With power automate, can I setup multiple email addresses to send notifications to specific group or individual emails? (based on the trigger choice). Also, with those flows, can I also send a bcc copy to my own group mailbox? Thank you!!!
Can you include all the answers in the form submission in the notification email you receive? I know that you can use Dynamic Content, but it won't title the content (only provides answers). Any suggesstions?
Would you please show how to generate form responses to PDF with attachments and post that PDF on sharepoint/Microsoft list please? My form also have many branches, so the ideal PDF result only shows the answered questions. Thank you sooooo much!!!
after creating a form when I tried using automate to create flow I got this error "Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application". Can you help me with this, please?
Hi Thanks for the video, I am just learning to use Power Automate. I have one question - I have created 20 forms (they have questions about daily my checks), when I submit the form, I get an email with link inside to view result. However, I want this same email to go to people whose area I have checked/audit. Can you please help me set the flow? I don’t want only email notification but want the same email which have a link of the result or that particular response completed.
To date I have not had a need for 'Forms' ... but quite an interesting demonstration. Another topic for my Bucket List ... although for me probably not at the top of the list. But definitely good to know. PS Who knew??? .... I can get a meeting w/Leila???? ME??? .... Are you kidding??? ... Where's the Form???? And how many questions can I ask? Are 127 questions too many??? Can the meeting last 3 days??? (Based upon video background, I can see why the "plant" question was asked. I will BUY a plant for the office if I can get a meeting with Leila).
Thanks for this guide , I have an issue, my form belong to a team, so when I try to get form ID , i am not able to find it. is there a workaround for this issue ?
I have followed intrusions however , it’s generating a general automated response I checked by clicking yes I received a notification o the tried with no I received a notification :( how do I fix this
Hi Leila, do you have tutorial on how to create an event in Office 365 Outlook when a Microsoft Forms is submitted. The responder will select their preferred session date and time and add the session details to their calendar. Thanks!
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
Leyla Gharani you are very professional lecturer. Great videos, and most importantly with min or no music background which is distracting always.
Many thanks to you.
Glad you like the content!
I've been using power automate at my work and I LOVE it!
I honestly cant believe you show folk how to do this for free, thank you!!!
which account is required for it ?
Impressive...never knew power automate had so much functionality. It's something I would definitely explore.
You and me both!
Super basic Vietnamese language
Leila, you are an absolute genius! Thank you so much for this!
Very helpful and timely for our company. Thanks!
Awesome, I use Power Automate to send emails to my email subscribers. This is how I'll do it next. Thank you.
👍
Awesome tutorial, it will be great if you can please make a video tutorial on how to create a project Dashboard in Office 365
Great video, as always! Did you know quizzes in MS Forms do not provide the global test score? For teachers that is disappointing.
The way I figured out using Power Automate was by adding all student's answers to Excel and compare with a table of correct answers. Since all student scores are in the same place, now it's very easy to share with students their incorrect answers along with links to study material related with each topic. But even more interesting, average scores can be sent to students automatically as well, after each test is submitted or periodically as in my case. The potential is gigantic.
A video from you oriented to teachers to automate quizzes would delight such audience.
You can download the full form results using a hidden api ua-cam.com/video/eq6QRz29q9Q/v-deo.html and this includes the answers and a total. No need to trigger on each response or save to excel/list.
@DamoBird365, thank you for the API clue. I will take a look on that. To download the Excels is good at least for archiving purpose.
Yet, the key here is to trigger automations for every quiz answered among a set of tens of quizzes, like recommend new lectures for incorrect answers or deliver automated reports weekly with average scores by subject matter or global. That requires a single central Excel table or database. In this scenario there is no need to download the Excels.
Thanks for pointing me in the right direction 👍🏻
I have noticed the power automation but was hesitant to use it. The video has helped me to use the tool. Thanks a lot 😊
Good explanation,
I become understand about this.
Thank you.
Greetings from Jayapura Papua.
God Bless
Wow.......... I didn't expect 0365 have this much options for forms.
The way presenting is so nice.
This was outstanding thank you
Glad you enjoyed it!
Thanks for sharing! 👍
I didn't know about this, thanks Leila!
Thank you! This really did the trick for me on something I was struggling with.
Glad it helped!
Great flow and yes I want to have a meeting with you. Condition, when I select "yes", you will receive an email notification of the restaurant I want to buy you dinner at.
😁
Leila - you're a lifesaver, let me tell you that! Subbed!
Thanks for the video. I want to make email notification for my team, but can we change the email sender with responders email?
you r my microsoft saviour
@LeilaGharani can you also make a video on how to do this when using a group form. I also want to set up responses to go to multiple people within my team.
Great info. Every time I open excel my 🧠 dies though 😅
OHHHH!! Right On time this video, today I will need to send a Forms!!!
Just a suggestion. It would be informative if you made a video highlighting some of the flows and power apps you developed for your workflows.
I like your videos
Thanks for useful post waiting for your complete tutorial on power automate
Hi. Thanks for the video. What if the Form Id is not appear in the drop down selection?
Very nice
Leila, I have a challenge for you (I think). I'm not a savvy Excel user but I'm quick to learn. Point is, I don't possess the jargon to query my Excel problem in your channel to find out if you have already covered my problem, but I tried.
So, at the risk of redundancy - allow me to pose my Excel problem that you can refer me to a video link covering my query, otherwise, this may be a new one for you. Either way, I am confident in you.
I do valuations as part of my work involving long-hand calculations with +/- equations that I wish to bypass with single data entry on a preformatted template to extend values for a quicker work process.
The problem is ascribing percentage values for a set of value ranges. Example, basis: 1,000 to 2,000 = -/+20%. What is the cell formula for a value range of say 1,528 (1222 to 1,834)? While also affixing monetary values to certain Yes No values?
I hope this isn't asking too much... by the way, how can I know if are responding to me?
It looks so simple when is explained very well 🦉
👏👏👏
Thanks, something worth trying, be safe
More videos on Power Automate
This is really a great way, lots of possibility with power automate! Thanks for sharing 😊
Great video!!! Thanks for sharing your knowledge!!!
Hi Leila. So many possibilities with Power Automate. Thanks for sharing your tips :)) Thumbs up!!
Hello Leila, many thanks for your videos. Can we do a trigger if someone didn't answer my email within two days in power automate ?
thannks man!
Wow. This is new to me
Thanks for sharing.
Simple ,short and excellent explanation 😎
Leila,
Is there a way to share the flow with others on the same team?
I want to create an approval form+flow and let everyone on my team use it.
Answers:
Q1 - Neil
Q2 - Yesss
Q3 - You are very smart, have 1M+ subs and it would be amazing if I could meet you!!!!
Much needed at the right time
thank you! this is very helpful :) but is there any way for the responders receive a personalized email based on their total marks? for example, when students complete the quiz on forms, the ones with good result (eg: 10/10) will get a different response compared to the others with 4/10 result. Thank you and hope you will be able to help me with this 🙂
thank you! It Video help me a lot!
A great demo Leila, thank you, though I was hoping to see the responses included in the email body, as I've been having some trouble inserting them as a table.
Great content, helped me a lot.
Very useful thank u.
Oh my, I just did this same video topic at work 😀
@LeilaGharani can you please do a video on how to insert signatures in emails in power automate? emails sent on recurring flows are not sent with professional signatures. i noticed there is no video on it in youtube perhaps you could do one on it. Thanks
We're currently using cognito forms. i think this is a good replacement. Thanks for the vid.
Very well explained indeed! (but also a little scary!) How would be able to type out a new email, add a MS Forms multiple choice question, and then send out to the recipients? (without them being able to view the report of who responded etc? I'm an old guy learning new tricks !!
Great video thank you!
Great video thank you for creating/sharing this!
Updated: I missed a step when I created the form "Get email Notification of each response" was not checked.
Incredible beautiful and incredible smart.
Leila, can this form be stored in SharePoint?
Awesome as usual!!!
Great! Thank you.
Thank you for making this tutorial though. I was looking for the google form exact the same linkage, is there any way to do that through add-ons? I will highly appreciate your respond to this.
Thank you
Hi,
great video.
Is it also possible to fill the form with multiple people based on certain entries within the form?
So as example the form should go through a whole department consisting of 6 groups and each group needs to fill in information in the form and then the form is send to the next group until all 6 groups have entered their information. It could also be that based on certain form entries that only lets say 4 out of the 6 groups need to enter information, so there should be also different branches to steer the form through the needed groups.
Thanks in advance!
Is this only available through office 365 online?
nice work!
wow been seaching for clear video and this is it. However the form i have built requires the email to go to someone else not me. My form has a multi answer question regarding what site you work at with 3 different sites. Whichever site is selected a different person will get the email for a uniform request.
I have followed your steps and when you get to condition i have added another 2 steps and when i test all 3 run succsessfully.
My problem is each of the 3 answers needs to go to a different email address and non of them are mine.
Anybody out there point me in the right direction please...
Hi Leila, can we setup such flow for the form another person from my team owns to send them details from the form in an email directly?
Awesome, thanks.
Hi - amazing content! I go to click my Conditioning and I am not seeing my Form questions listed.. I only get "response ID, Resource Data, or Body" to choose from. How do you get your questions to be available there?
This is so amazing...
Glad you like it.
@@LeilaGharani Marc Ravens
Tochter
Hoffentlich
Finished your Power Query classics on Udemy. That was bomb.
When are you releasing your classic on Power BI 😁? I have studied like two (Foundation and Advanced) by other tutors on Udemy, but I would buy yours because it's gonna be something different.
Great video thank you so much. Is there a way to trigger a form from particular cell or a row from Excel and response to that form should be saved in the same row/cell from wr it was triggered?
Very useful video. As I see the email notification came on Outlook online. Is it possible to receive an email on Outlook desktop app? Thank you!
This is Legendary!! Power Automate is actually quite helpful. Is it possible to send the email to the person who filled the form?
Yes. If it's a public form though, you'll need a field where they put in their email address and then you can use that for the sending of email.
@@LeilaGharani Thank You for replying. Will definitely recommend this to my teachers!! Already recommended your channel to my friends!
Can you create a form where someone inputs information and then an email is sent to the customer dependent on what information they have entered into the form. eg. I create a form for different type of sushi orders. The customers enter what sushi they would like. Then an automatic email is sent to the customer, stating what they ordered, the total and when they can pick up their order etc.
Brilliant!
Gr8... for you have any video regarding how to recall mail while using 0365
But I can just turn on the notification in Forms and then also get an email when a response, is much easier?
Perfect!
nice video again. :) Is there a way to add a condition to a text field that checks if the field is filled or not?
You could require the field to be filled.
Hi Leila, must say this tutorial was such a simplified demo. I already tried one automation successfully. One thing I wanted to know is if there's a way grant view only visibility to the response statistical visual of the forms page in the same automation.
I want the auto mail to be assigning a serial number to responder as they fill the form
Then when i clear response, the serial number should reset from 1
Powerful!
How do you handle this if you have more than 2 options? I have 4 options and want to do the same for this.
Hi Leila, have you ever had instance where the Form ID just doesn't show? Not in the url, and not in the Power Automate drop down?
I have the same issue
Hello. For me, the 2nd step (get response details) always automatically change into 'for each loop' when I selected 'Response Id'.. Is there a workaround for this issue?
This is very helpful and might solve a problem for a project we are working on. With power automate, can I setup multiple email addresses to send notifications to specific group or individual emails? (based on the trigger choice). Also, with those flows, can I also send a bcc copy to my own group mailbox? Thank you!!!
hi did you ever sort this issue ??
@@markevans3026 Hello! Yes we did. Thanks for checking back. The site is an excellent resource.
Can we consolidate all the forms data in to excel which can be created as report further?
Can you include all the answers in the form submission in the notification email you receive? I know that you can use Dynamic Content, but it won't title the content (only provides answers). Any suggesstions?
Would you please show how to generate form responses to PDF with attachments and post that PDF on sharepoint/Microsoft list please?
My form also have many branches, so the ideal PDF result only shows the answered questions. Thank you sooooo much!!!
after creating a form when I tried using automate to create flow I got this error "Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application". Can you help me with this, please?
Hi Thanks for the video, I am just learning to use Power Automate. I have one question - I have created 20 forms (they have questions about daily my checks), when I submit the form, I get an email with link inside to view result. However, I want this same email to go to people whose area I have checked/audit. Can you please help me set the flow? I don’t want only email notification but want the same email which have a link of the result or that particular response completed.
Great content!
Can the form be public? Any difference in capturing the responder email and start processing the flow?
To date I have not had a need for 'Forms' ... but quite an interesting demonstration. Another topic for my Bucket List ... although for me probably not at the top of the list. But definitely good to know.
PS
Who knew??? .... I can get a meeting w/Leila???? ME??? .... Are you kidding??? ... Where's the Form???? And how many questions can I ask? Are 127 questions too many??? Can the meeting last 3 days??? (Based upon video background, I can see why the "plant" question was asked. I will BUY a plant for the office if I can get a meeting with Leila).
Haha, it has to be a plant I can eat though 😂
strawberries??? ... blueberries??? ... raspberries???
Thanks for this guide , I have an issue, my form belong to a team, so when I try to get form ID , i am not able to find it. is there a workaround for this issue ?
Hi Eravisz, have you found a workaround for this yet?
I have followed intrusions however , it’s generating a general automated response I checked by clicking yes I received a notification o the tried with no I received a notification :( how do I fix this
How to provide specific I'd or Name to the Ms form which is automatically Generated when you open the form.
Anyone able to link me to a video where its form attachments posting to a team chat? yet to find instructions on this on the web.
is it possible to send a team message via Power Automate? if yes, can you make a tutorial on that?
I didnt understand the reason to use this feature or how does it help. It looks interesting though.
Hi Leila, can you embed these MS Forms within a web site rather than use say, a PHP form?
Hi Leila, do you have tutorial on how to create an event in Office 365 Outlook when a Microsoft Forms is submitted. The responder will select their preferred session date and time and add the session details to their calendar. Thanks!