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 help thanks. How do I forward the form onto another person via email if its approved. So if approved, the information in the form needs to be forwarded onto another staff member.
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?
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 ruclips.net/video/eq6QRz29q9Q/видео.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.
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!
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.
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?
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 🙂
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.
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.
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!!!
@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.
@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
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 ?
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.
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.
Hi leila, I need your help I have some data in different boxes. Ex 1A have some name - car v 2A have some kilometers - 5000 3A have some time in time format like - 12:12:10 4A I used &" "& this formula sad merge all 1A, 2A, 3A so it show - car v 5000 4.000 so all data merge but time did not come properly due to time format how I can love this. I need merge all data.
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?
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?
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.
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 !!
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?
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!
Hello - I'm having a hard time figuring out how to do this when you have more than two choices in the multiple response question. For example I have 6 choices. Each choice requires a different colleague to receive the notification. Is there a way to do that?
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...
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.
I've been trying to figure out the best way to save forms responses to a PDF automatically every time a response is submitted or extract the answers to a readable format. At the moment I'm downloading the excel responses and using lookups to create a readable excel sheet that can be PDF'd. I have attempted to use PA but struggled massively.
I get this error :(, ActionBranchingConditionNotSatisfied The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied.
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 honestly cant believe you show folk how to do this for free, thank you!!!
which account is required for it ?
I've been using power automate at my work and I LOVE it!
Leila, you are an absolute genius! Thank you so much for this!
Very helpful and timely for our company. Thanks!
Impressive...never knew power automate had so much functionality. It's something I would definitely explore.
You and me both!
Super basic Vietnamese language
Good explanation,
I become understand about this.
Thank you.
Greetings from Jayapura Papua.
God Bless
Thank you thank you! ive lost track the number of times your videos have helped me.
Thank you for the kind feedback. 🙏
Thanks for pointing me in the right direction 👍🏻
Awesome, I use Power Automate to send emails to my email subscribers. This is how I'll do it next. Thank you.
👍
I have noticed the power automation but was hesitant to use it. The video has helped me to use the tool. Thanks a lot 😊
Leila - you're a lifesaver, let me tell you that! Subbed!
It looks so simple when is explained very well 🦉
👏👏👏
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!
you r my microsoft saviour
Wow.......... I didn't expect 0365 have this much options for forms.
The way presenting is so nice.
This is really a great way, lots of possibility with power automate! Thanks for sharing 😊
OHHHH!! Right On time this video, today I will need to send a Forms!!!
Great video!!! Thanks for sharing your knowledge!!!
Thanks for useful post waiting for your complete tutorial on power automate
Hi Leila. So many possibilities with Power Automate. Thanks for sharing your tips :)) Thumbs up!!
Thanks, something worth trying, be safe
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.
Great help thanks. How do I forward the form onto another person via email if its approved. So if approved, the information in the form needs to be forwarded onto another staff member.
Wow. This is new to me
Thanks for sharing.
What about if we have multiple options and with each response email needs to go to a different email?
Much needed at the right time
Great content, helped me a lot.
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 ?
Hi. Thanks for the video. What if the Form Id is not appear in the drop down selection?
Thanks for the video. I want to make email notification for my team, but can we change the email sender with responders email?
thank you! It Video help me a lot!
Awesome as usual!!!
nice work!
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?
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 ruclips.net/video/eq6QRz29q9Q/видео.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.
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
Great video thank you!
Oh my, I just did this same video topic at work 😀
I like your videos
Very useful thank u.
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! Thank you.
Incredible beautiful and incredible smart.
Very nice
thannks man!
Awesome, thanks.
We're currently using cognito forms. i think this is a good replacement. Thanks for the vid.
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?
This is so amazing...
Glad you like it.
@@LeilaGharani Marc Ravens
Tochter
Hoffentlich
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!
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.
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!
Leila, can this form be stored in SharePoint?
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?
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 🙂
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.
Brilliant!
Thanks for the info….but what if we want to send the email to someone else and bot to us?
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.
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.
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.
Great content!
Can the form be public? Any difference in capturing the responder email and start processing the flow?
Greate value
Can we consolidate all the forms data in to excel which can be created as report further?
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
@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.
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.
But I can just turn on the notification in Forms and then also get an email when a response, is much easier?
@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
Perfect!
Great info. Every time I open excel my 🧠 dies though 😅
Answers:
Q1 - Neil
Q2 - Yesss
Q3 - You are very smart, have 1M+ subs and it would be amazing if I could meet you!!!!
Hi Leila, can you embed these MS Forms within a web site rather than use say, a PHP form?
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?
Powerful!
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.
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.
Hi leila,
I need your help
I have some data in different boxes.
Ex
1A have some name - car v
2A have some kilometers - 5000
3A have some time in time format like - 12:12:10
4A I used &" "& this formula sad merge all 1A, 2A, 3A so it show - car v 5000 4.000 so all data merge but time did not come properly due to time format how I can love this.
I need merge all data.
How do you handle this if you have more than 2 options? I have 4 options and want to do the same for this.
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?
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?
Gr8... for you have any video regarding how to recall mail while using 0365
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!
How can this be done with a rating question? For example, if a person responds with a 3 or less rating, then email. Thanks!
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.
😁
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 !!
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?
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!
Hello - I'm having a hard time figuring out how to do this when you have more than two choices in the multiple response question. For example I have 6 choices. Each choice requires a different colleague to receive the notification. Is there a way to do that?
Is this only available through office 365 online?
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...
is it possible to send a team message via Power Automate? if yes, can you make a tutorial on that?
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.
I've been trying to figure out the best way to save forms responses to a PDF automatically every time a response is submitted or extract the answers to a readable format. At the moment I'm downloading the excel responses and using lookups to create a readable excel sheet that can be PDF'd. I have attempted to use PA but struggled massively.
Hi Connor, you could check out this video 👀ruclips.net/video/KVIWDRjPKUk/видео.html
I get this error :(, ActionBranchingConditionNotSatisfied
The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied.