Hey Jon ... this is fantastic. We've had flow available to us for some time but not much use until this video. I want to thank you so much as we have a feedback form just sitting there and then have done nothing to it. In one video you have changed everything and we now have multiple forms that are now visible to the business through Power BI. You've turned me into a superhero. Thank you so much.
Jon. You are awesome! I came here for a different question but got 2 amazing answers to things I didn't know where possible and I didn't know I needed but I totally do. I'll be trying this!
You are an awesome teacher - straight to the point but super CLEAR on HOW TO - thank you soooo much - my flow worked :) (did a time off request approval flow)
Thanks Jon. I've been using your flow (oh umm.... Power Automate) videos for a bit and seen you at Ignite. Thanks for continuing to be a great resource to us all.
I'm enjoying your videos! I did the form one. My next challenge is to build a Flow that interacts with a Sharepoint List (gets items), then sends a scheduled email followed by updating a dashboard. Wish me luck.
This is fantastic. Loving the simple explanation of what is needed and made whole process easy to understand. Now i need to transfer the knowledge to connecting to CRM Dynamics 365
Just reviewed your video, in my way back time machine...genius. FYI, as a Canadian, I have no issues with your surname. One of the main streets when I drive through Montreal, QC.
I also had this problem, using Power Automate. However, my form seems to work without the "apply to each" item. I am only sending an email response to each submission and have not trialled this with any other processes, but the email response is working.
Thank you - this worked very well and my Form - flow with Power BI was a success. I am creating a small ticketing form and the issue I have is that I need to send an email to IT help desk with all the Form field data? - This was great
Great info thanks very much. If you haven't already, you should consider getting a better microphone as the sound is rather poor. Oddly enough, at 10:59, the sound improves, so not sure what was going on there.
Thank You so much! I have been trying to figure this out for about a month how to get form data to flow into powerBI and to a dashboard in an automated fashion! I created a survey for one of my workflows that has been manual in the past, and this will definitely put us on the path to streamlining! Could you also show how to create the data visualization in Power BI with the collected information in another video? maybe I will check out that bonus link you shared in your email to see if you already shared that :) Thanks Again for showing us how to use this powerful tool!
Super tutorial. Just seen your great channel and not yet see through all video. Right now, I only have basic subscription of MS account on my desk. To run Power automate like this or at least for someone who have worked as self-employed with some clients, what type of MA account should I have so I can work like you did? Thanks Jon
Hi Jon Great Video and so informative, I've subscribed. Wondered if it's possible to use flow to create an email with the results of a Form embedded in that email rather than having to view results in forms itself. Thanks.
Thank you the well explained content, I have a question though, is it possible to pre-fill the form using previous data entry by a user ? If so please can you create a video for it . Thank you !!!
True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing
True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing
Awesome video! I'm trying to use the same method but instead of Power bi, I'm using excel with tables. How do i put an condition on a response answer so that if the answer doesn't meet the condition it won't run or add to any tables. a simple example of this is on forms user picks "Site A" or "Site B" if they pick "Site A" that flow will run but not the flow for "Site B"
Super video.. love the way you defined. i have a question. 1. How do i get the summary of responses submitted through email or as a pdf attachment on submission 2. How do i get email alert if rating goes below 3 out of 10 (so and so person submitted down rating) Thanks in advance
@@JonJLevesque I have one idea currently, "once the form is submitted, start a new specific form". Ill put in the forum also. Another question, maybe this is for other Forms team, is there plans to add more functionality to forms? Functions like "if this then that"? Thank you
Beautifully explained concept of flow in Microsoft. Can we able to connect data of two Microsoft forms with the help of flow..? I yes please make a video of same...
Hi Jon - thank you for your video. Its really good and clear what are you doing and why. I am trying to set up Flow for meeting room booking. I would like to set up Flow which will do following: 1. Organiser send meeting request to the meeting room. Skype for Business meeting for instance. 2. Meeting is tentative at this stage; 3. Specific people in our organisation approve this request; 4. As part of approval from specific people email was sent back to organiser to fill up the form about catering requirement, for instance; 5. Organiser reply's back with specific catering (if any) requirement. Is that even possible with Power Automated / Flow?
Great Jon!!!! But can I use all data (or partial ones) to calculate them and give an answer to the user? And, I'd like to register all together, data and results. What do you think? ;-) Cheers from Brazil.
Hi Jon, great information. Can you tell me what the options are to blend this power automate data with an existing on prem dataset I work with in power Bi? I.e. we want to count customer visits by sales rep by month, then show that results along with applicable sales totals..
Hey Jon, thanks for sharing. I was thinking of setting up a flow with ms forms-quiz such that when a person gets full marks for the quiz he gets an email sayings congrats else it would be "try harder next time" However the tricky part is the "points" option does not seem to be available for selection within flow which is a stumbling block. any alternatives? Thanks!
+Sean you would need to create an answer key somewhere, Move the quiz answers there, compare and then calculate, then respond. This isn’t an easy thing unfortunately - but it is possible
@@JonJLevesque Yeah understood. If only Forms has exposed the "Points" field (since Respondent Time, Name, Email are available) that surely make this MS Forms-Quiz very very useful. Would you know if perhaps Forms Pro would have this? Tia
Jon, this is a great tutorial fro a beginner like me. I think you mentioned about looking at some run-time visualisations in powerbi after completing the flows and forms. Would you be able to demo that as well?
Thank you so much for this video! I was able to create my first Flow from a Microsoft Form conference registration to automated email thanking attendees for registering, providing the details of the conference, and asking them to email if they have to cancel. One thing is the email went to my junk email. Any way to avoid that? Next...I am going to try to have a flow from a specific question on the form (do they want to pre-order a t-shirt) to an email that provides them the payment information. Thanks again!! So helpful!
I've created a form flow to capture policy acknowledgements by populating a SharePoint List but is there a way to dynamically populate information about the form itself? Specifically I would like the list item to include the name of the form through dynamic selection rather than a static entry in the flow.
Hi Jon, that was a great intro, I knew nothing, now I know lots. I have a website that collects client data input by staff, and the business wants to send a partially filled Form to a client to fill all the remaining details, which I would store in the appropriate SQL Server record. Is this the best technology for that purpose (i.e., not a survey as such)? How would a 'Send' button on my website connect to Forms and actually send the form please?
Hey Jon, thanks for this! Could you help me to know if the following thing is possible or not ? I have 3 difft forms to be filled by each employee of my company 5,5,5 which means on 5th Day one form,5week,5month. I want to make this automatic, if one employee fills it on day 5 will get form link of 5th week and for 5th month without any manual or minimal manual intervention? Possible ?
this video is awesome , ca we have this for large data collection , work flow for progress on 40 to 45 indicator by 15 people every three month on some target
Hi i wanna cross chexk a sharepoint list where i need to match the user’s department (from profile) and matxh it with the department’s manager from the sharepoint list , and use his email in the email connector to send the approval email. Which sharepoint connector do i use get items or item ? Also how do i cross check and select from the list , which condition do i use
How to get data from multiple MS forms and create one live stream for a power BI dashboard? Can we use SharePoint alongwith flow to create the live data stream and then connect it to Power BI?
It was very interesting. Thanks. How can I automatically add the person's line manager name and line manager's email address in the organization into the email for example?
great video. I have a question. I see a lot of videos where "surveys" are used as an example. I created a quiz, it works well but I can't get the same result when I export it with the option in the Form response tab of my quiz (open with Excel) and my flux. I have my answers but I don't have the right answer like the file. Can you help me. I can send you a screen or a link to show you. Thank you in advance.
Thank you! great video. One question. Why I cant see these connectors in my options "outlook send an approval email" or "office 365 outlook send an approval email". I want users be able to approve from outlook.... Again thank you the material uploaded.
Can you explain how to just send the responses from the form* into an email? Im trying to create a Ticket* creation process by using forms to gather the information going into an IT Ticket. Trying to get it to go from Form->(flow) to send all responses into the email*
Hey cory, if you do the first two form steps, and then use the "send an email" action - you should be able to drop all the dynamic content right into the email from the form
Hey Jon. I have layered audits set up for my organization and people are grouped up in teams. I used forms but I'm trying to build a flow to send out automatic responses to the individuals team to where they can view the responses for that form that was submitted? Please help.
@@JonJLevesque ok so, I have a form created. There are 20 teams that fill out the form but only one person from each team completes the form. I'd like to set up a flow to where when a team member submits their form, an automatic response in an email "view responses" is sent to the rest of that persons team. Everyone has the same company email address. How do I get the flow to work where when a response is submitted, an email with the results is sent to only that team?
Hi Jon. I have been watching your video and that have been really good! However, I am still relatively new to Forms and Flow and I am trying to figure out something within Flow. I am trying to figure out a way to send an email where the FROM field is actually the user's email address. I have a specific business case where I need this to happen and I don't want the from email address to by my email address. I tried using the From (Send as) field with the Responders' Email selected for that field, but I receive an error in my email saying "You don’t have permissions to send emails on behalf of [user email address]. Contact [user email address] to check shared mailbox permissions and gain access." Do you know if there is a way to do this within Flow at all? Thanks!
Unfortunately you can’t make a Flow to send on behalf of others. That would be a huge security flaw :( You can use the flow mail service though or a sendgrid account if you want to not send from you
Hey Jon, I have happily made so many forms but today, sadly wanted a time picker for my new project with ms Form Pro.. I do not want time.. any help :)
@@JonJLevesque I want a ms Form which can allow staff to pick the hours they work per week. Like a time attendance sheet. It will contain start to finish time and lunch breaks during the 7 days.(I hope this is clearer)
I have built a form to use as a sign up sheet. Is there a way to limit how many people can sign up for a certain date? I have tried so many different things to get this to work I can do it in google forms. But prefer the way that the Microsoft for looks and feels just need a way to do this.
@@JonJLevesque do you have an example video of this or another resource I can check out? BTW, awesome videos. I just started this weekend with Flow with hesitation but after watching your videos, a few others, and tons of googling I am really excited to show my coworkers tomorrow. I have a whole slew of forms, excel, and flow already built from this weekend really just geeking out and trying new things...so thank you! And also for your quick reply!
I keep getting an Error (400) when I try to test my Flow. The Power BI function doesn't let me map the fields one to one as Jon does in the video. Instead after I define my workspace/dataset Ect. it asks me to add dynamic content to the "Payload". This is where the error occurs every time. Thoughts?
Super amazing. Feel like crying. Hahaha.
Haha crying?! Hopefully with tears of joy! Lol
@@JonJLevesque yes tears of joy
I felt the same 😂😂😂
@@JonJLevesque DEFINITELY
Hey Jon ... this is fantastic. We've had flow available to us for some time but not much use until this video. I want to thank you so much as we have a feedback form just sitting there and then have done nothing to it. In one video you have changed everything and we now have multiple forms that are now visible to the business through Power BI. You've turned me into a superhero. Thank you so much.
Woohoo! You are so welcome!!
Probably one of the best sample intros I’ve seen yet. Thanks so much for putting this together.
You are very welcome!
Jon, this rocks. I haven't tried it but I think I am able to get this done. Well done and let's hope our IT department lets Flow work like this.
Jon. You are awesome! I came here for a different question but got 2 amazing answers to things I didn't know where possible and I didn't know I needed but I totally do. I'll be trying this!
Yesssss! So excited to hear it!
Awesome video Jon, definitely worth it. Was looking at it on the phone, and came to the lap, connected and made this Flow. Thanks dude, legit!
Yesssss! So stoked you made it work! :)
Mate did you just make an MS tutorial video look cool?! well done to you
I watched your video and took action! Awesome tutorial! Thanks a bunch Jon Levesque, Levesque
You are an awesome teacher - straight to the point but super CLEAR on HOW TO - thank you soooo much - my flow worked :) (did a time off request approval flow)
Wooot! Thank you for letting me know! I love hearing that people made flows successfully from watching me!
What’s your next one now?!
Hi Jon, I am late to the party, but I created a flow based on your video for a large school district. Your video explanation is amazing! Thank you!!
Richard, yes!! That’s amazing! Thank you for letting me know
Thanks Jon. I've been using your flow (oh umm.... Power Automate) videos for a bit and seen you at Ignite. Thanks for continuing to be a great resource to us all.
Rocco! My pleasure pal. Thanks for taking a second to leave such a nice comment :)
Im new to MS flow and I find your content, so easy to follow. Thank you.
OMG simply loved it. Will watch all of your videos for sure. Thank you so much for sharing it with us. Good bless you
I'm enjoying your videos! I did the form one. My next challenge is to build a Flow that interacts with a Sharepoint List (gets items), then sends a scheduled email followed by updating a dashboard. Wish me luck.
Thanks!! and Good luck Allan!
This is fantastic. Loving the simple explanation of what is needed and made whole process easy to understand. Now i need to transfer the knowledge to connecting to CRM Dynamics 365
Just reviewed your video, in my way back time machine...genius. FYI, as a Canadian, I have no issues with your surname. One of the main streets when I drive through Montreal, QC.
Awesome video! Thank you so much for all the detail and step-by-step!!
I liked your simple and clear way to teach...keep doing like that. Marcius from a city called Goiania, Brazil. Search on the Maps!!!
+Marcius M G Souza thanks so much my friend!
Great great great training video! Awesome job done Jon!
Super Cool Jon! Really enjoy your vids :) Sharing with students :)
Hi Jon..... I just watched your tutorial is a very good material, I really love it. please, I want to know more about Microsoft flow.
Awesome ! I loved it. You explained in great flow! Keep up it.Cool
Just what I need. I'm looking forward to unlocking the secrets!
Excellent Jon!
Thanks for sharing it!
For some reason I don’t get the apply to each in the get response details. Do you know what would cause this?
This happened to me when I tried my first form
@@rkchamberlin5 Me too.. any solution to this?
I also had this problem, using Power Automate. However, my form seems to work without the "apply to each" item. I am only sending an email response to each submission and have not trialled this with any other processes, but the email response is working.
Great clip Jon! can;t wait to visualize this in Power BI
Thank you - this worked very well and my Form - flow with Power BI was a success. I am creating a small ticketing form and the issue I have is that I need to send an email to IT help desk with all the Form field data? - This was great
Jon thanks you so much! I tried on my own and work it out on my first flow
Thanks Mate, what a way to create the tutorial from a learner's perspective for a better understanding :-)
You’re very welcome! :)
This was a really good explanation, thanks a lot!
You are very welcome! Thanks for watching! :)
Great video, very well explained! Thank you
Great info thanks very much. If you haven't already, you should consider getting a better microphone as the sound is rather poor. Oddly enough, at 10:59, the sound improves, so not sure what was going on there.
Thank You so much! I have been trying to figure this out for about a month how to get form data to flow into powerBI and to a dashboard in an automated fashion! I created a survey for one of my workflows that has been manual in the past, and this will definitely put us on the path to streamlining! Could you also show how to create the data visualization in Power BI with the collected information in another video? maybe I will check out that bonus link you shared in your email to see if you already shared that :) Thanks Again for showing us how to use this powerful tool!
Super tutorial.
Just seen your great channel and not yet see through all video.
Right now, I only have basic subscription of MS account on my desk. To run Power automate like this or at least for someone who have worked as self-employed with some clients, what type of MA account should I have so I can work like you did?
Thanks Jon
Hey!
Thanks for the video. Congratulations!
Hi Jon
Great Video and so informative, I've subscribed.
Wondered if it's possible to use flow to create an email with the results of a Form embedded in that email rather than having to view results in forms itself.
Thanks.
Mick that is very possible! You’ll add the first two forms steps then add the action “send an email v2” and voila! Customize to your hearts content!
@@JonJLevesque so Trigger and action and then another action as email? What's v2?
Great video, so well explained. Thank you! Is there a way you can collect response results and send in batches?
Thank you the well explained content, I have a question though, is it possible to pre-fill the form using previous data entry by a user ? If so please can you create a video for it . Thank you !!!
It is not possible :(
True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing
True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing
Nice One Mate, Love Your Work. Will pass this on to my students :) Keep it up :)
Thank you for sharing your knowledge, much appreciated!
You are very welcome!
Awesome video! I'm trying to use the same method but instead of Power bi, I'm using excel with tables. How do i put an condition on a response answer so that if the answer doesn't meet the condition it won't run or add to any tables.
a simple example of this is on forms user picks "Site A" or "Site B"
if they pick "Site A" that flow will run but not the flow for "Site B"
Super video.. love the way you defined.
i have a question.
1. How do i get the summary of responses submitted through email or as a pdf attachment on submission 2. How do i get email alert if rating goes below 3 out of 10 (so and so person submitted down rating)
Thanks in advance
Love these sessions that can help trainers train - but I think the most important part comes at the 18:25 mark. :-)
Haha! Love the comment!
it's a new piece of the PA/Flow Gospel, Jon 18:25
Just did it. Great idea, Works amazingly Thanks!
Woot woot! Now you have a working flow! What’s the next one you want to build?
Jon awesome presentation. I have a question, is there a plan to add more Forms triggers and actions into Flow? Thank you
Hey Dusan, what actions and triggers would you suggest? You can also add ideas to aka.ms/flowideas
@@JonJLevesque I have one idea currently, "once the form is submitted, start a new specific form". Ill put in the forum also.
Another question, maybe this is for other Forms team, is there plans to add more functionality to forms? Functions like "if this then that"?
Thank you
Beautifully explained concept of flow in Microsoft. Can we able to connect data of two Microsoft forms with the help of flow..?
I yes please make a video of same...
Hey John, Excellent Video for learning just wanted to know what about POWER BI Data you have not show how data is reflecting in Power BI.
Hi Jon - thank you for your video. Its really good and clear what are you doing and why.
I am trying to set up Flow for meeting room booking. I would like to set up Flow which will do following:
1. Organiser send meeting request to the meeting room. Skype for Business meeting for instance.
2. Meeting is tentative at this stage;
3. Specific people in our organisation approve this request;
4. As part of approval from specific people email was sent back to organiser to fill up the form about catering requirement, for instance;
5. Organiser reply's back with specific catering (if any) requirement.
Is that even possible with Power Automated / Flow?
Sorry - name is Boyan :-)
Great Jon!!!! But can I use all data (or partial ones) to calculate them and give an answer to the user? And, I'd like to register all together, data and results. What do you think? ;-) Cheers from Brazil.
I made it. I created my first flow..its amazing feeling..tall credits goes to you...thank you jon :-)
Woo woo! Happy Dance!
Hi Jon, great information. Can you tell me what the options are to blend this power automate data with an existing on prem dataset I work with in power Bi? I.e. we want to count customer visits by sales rep by month, then show that results along with applicable sales totals..
Hey John great job.
Thanks Dimitri! I appreciate you saying so!
Hey Jon, thanks for sharing. I was thinking of setting up a flow with ms forms-quiz such that when a person gets full marks for the quiz he gets an email sayings congrats else it would be "try harder next time" However the tricky part is the "points" option does not seem to be available for selection within flow which is a stumbling block. any alternatives? Thanks!
+Sean you would need to create an answer key somewhere, Move the quiz answers there, compare and then calculate, then respond. This isn’t an easy thing unfortunately - but it is possible
@@JonJLevesque Yeah understood. If only Forms has exposed the "Points" field (since Respondent Time, Name, Email are available) that surely make this MS Forms-Quiz very very useful. Would you know if perhaps Forms Pro would have this? Tia
Jon, this is a great tutorial fro a beginner like me. I think you mentioned about looking at some run-time visualisations in powerbi after completing the flows and forms. Would you be able to demo that as well?
Yeah, i could make one of those in a future video for sure!
Thank you so much for this video! I was able to create my first Flow from a Microsoft Form conference registration to automated email thanking attendees for registering, providing the details of the conference, and asking them to email if they have to cancel. One thing is the email went to my junk email. Any way to avoid that? Next...I am going to try to have a flow from a specific question on the form (do they want to pre-order a t-shirt) to an email that provides them the payment information. Thanks again!! So helpful!
You’re so welcome! Woo hoo so excited for you :)
@@JonJLevesque I was trying to take it a step further...but can't get it to work. See below comments. :)
yo...this was dope! Big help, thanks man!
You’re very welcome!
Nice one great video, but I am new to this and then I get a good start, keep up the good work, thanks
Thanks!!
Thanks in a million. Second to none!
So glad you enjoyed it!
I've created a form flow to capture policy acknowledgements by populating a SharePoint List but is there a way to dynamically populate information about the form itself? Specifically I would like the list item to include the name of the form through dynamic selection rather than a static entry in the flow.
Hi Jon. Great video. I wonder if this works with forms or is it just quizzes. Thanks!
This definitely works with forms!
This is awesome as usual, but what happened to the PowerBI portion of the demo?
Hmm.. i guess i skipped over that huh?! Sorry!
Great video. Could you show us how to display responses in the email.
Hi Jon, that was a great intro, I knew nothing, now I know lots. I have a website that collects client data input by staff, and the business wants to send a partially filled Form to a client to fill all the remaining details, which I would store in the appropriate SQL Server record. Is this the best technology for that purpose (i.e., not a survey as such)? How would a 'Send' button on my website connect to Forms and actually send the form please?
Hey Jon, thanks for this! Could you help me to know if the following thing is possible or not ? I have 3 difft forms to be filled by each employee of my company 5,5,5 which means on 5th Day one form,5week,5month. I want to make this automatic, if one employee fills it on day 5 will get form link of 5th week and for 5th month without any manual or minimal manual intervention? Possible ?
Thanks! This video is awesome
You’re very welcome!
Hey. Had a quick question.
If we use a branching form and a field is left blank, the FLOW fails. What is to be done in such a scenario ?
Can you please make the video for Check- In project and publish if the projects are checked-out using power automation ?
Love it! This is exactly what I've been looking for! By the way, it's been a year since you made your video, do you have any easier way so far?
Amazining, I like the way it was explained.
this video is awesome , ca we have this for large data collection , work flow for progress on 40 to 45 indicator by 15 people every three month on some target
+Ehsan Ullah I’M not sure what you mean. You could set up a flow to do that, sure.
Would love to see on how to connect to ms sql and it thrilled me to see the dashboard in power bi. Good video though
Hi i wanna cross chexk a sharepoint list where i need to match the user’s department (from profile) and matxh it with the department’s manager from the sharepoint list , and use his email in the email connector to send the approval email.
Which sharepoint connector do i use get items or item ? Also how do i cross check and select from the list , which condition do i use
Thank you very helpful. Does anyone know how to keep a flow running? Mine stops running after the form is filled out everytime.
Did a flow!!! and it worked.
Yesssss! That’s awesome. What did you build?
How to get data from multiple MS forms and create one live stream for a power BI dashboard? Can we use SharePoint alongwith flow to create the live data stream and then connect it to Power BI?
It was very interesting. Thanks. How can I automatically add the person's line manager name and line manager's email address in the organization into the email for example?
This is so so cool. Trying it now...🤞
great video.
I have a question.
I see a lot of videos where "surveys" are used as an example.
I created a quiz, it works well but I can't get the same result when I export it with the option in the Form response tab of my quiz (open with Excel) and my flux.
I have my answers but I don't have the right answer like the file.
Can you help me. I can send you a screen or a link to show you. Thank you in advance.
How did you get your audio to sound like it does? I am wearing headphones but it sounds like your voice is coming out of my monitor (but it isn't).
Haha i was in an echoey room
Thanks will experiment and use it!!
Tried it and use it now!! Thanks..
Can we convert SharePoint List data into XML using Flow?
Is there a way to auto populate the fields for a calendar event using the data from the form?
Thank you! great video. One question. Why I cant see these connectors in my options "outlook send an approval email" or "office 365 outlook send an approval email". I want users be able to approve from outlook.... Again thank you the material uploaded.
Can you explain how to just send the responses from the form* into an email? Im trying to create a Ticket* creation process by using forms to gather the information going into an IT Ticket.
Trying to get it to go from Form->(flow) to send all responses into the email*
Hey cory, if you do the first two form steps, and then use the "send an email" action - you should be able to drop all the dynamic content right into the email from the form
Thanks very much. Super helpful!
Hey Jon. I have layered audits set up for my organization and people are grouped up in teams. I used forms but I'm trying to build a flow to send out automatic responses to the individuals team to where they can view the responses for that form that was submitted? Please help.
I’m not sure what your question is?
@@JonJLevesque ok so, I have a form created. There are 20 teams that fill out the form but only one person from each team completes the form. I'd like to set up a flow to where when a team member submits their form, an automatic response in an email "view responses" is sent to the rest of that persons team. Everyone has the same company email address. How do I get the flow to work where when a response is submitted, an email with the results is sent to only that team?
Abraham, you should ask this in the Flow community - aka.ms/flowcomm - try to build it and post where you get stuck and they will help!
Can you make a video on some of the functions for excel online in flow. Maybe even combining it with answers from forms
Thank you so much for this video, iand also for the learning material
Hi Jon. I have been watching your video and that have been really good! However, I am still relatively new to Forms and Flow and I am trying to figure out something within Flow. I am trying to figure out a way to send an email where the FROM field is actually the user's email address. I have a specific business case where I need this to happen and I don't want the from email address to by my email address. I tried using the From (Send as) field with the Responders' Email selected for that field, but I receive an error in my email saying "You don’t have permissions to send emails on behalf of [user email address]. Contact [user email address] to check shared mailbox permissions and gain access." Do you know if there is a way to do this within Flow at all? Thanks!
Unfortunately you can’t make a Flow to send on behalf of others. That would be a huge security flaw :(
You can use the flow mail service though or a sendgrid account if you want to not send from you
@@JonJLevesque Thanks for the feedback. I really appreciate it!
Jon - Is there a video that details connecting via Flow a Microsoft Form and a SharePoint Online List?
This one does - ua-cam.com/video/AOpm_lVjgmk/v-deo.html
Hey Jon,
I have happily made so many forms but today, sadly wanted a time picker for my new project with ms Form Pro.. I do not want time.. any help :)
Hmm care to explain more?
@@JonJLevesque I want a ms Form which can allow staff to pick the hours they work per week. Like a time attendance sheet. It will contain start to finish time and lunch breaks during the 7 days.(I hope this is clearer)
HI Jon, Can I do a flow to come back to the form page when the form is submitted?
I have built a form to use as a sign up sheet. Is there a way to limit how many people can sign up for a certain date? I have tried so many different things to get this to work
I can do it in google forms. But prefer the way that the Microsoft for looks and feels just need a way to do this.
You’ll want to have a list of “available” dates somewhere else and have the flow check against that list when setting a date
Hello Jon ,Hope you doing well can you please fix this for me when we submit the form it will post into yammer needs to be that of the submitter ?how?
Thanks a lot! You're a life saviour
You are so very welcome! Happy to help
Thanks for this content
You’re welcome!
What's the advantage of sending the data to power BI dataset instead of just processing/sending it to excel or email?
It’s really for if you want to build reports and visualizations of the data
@@JonJLevesque do you have an example video of this or another resource I can check out? BTW, awesome videos. I just started this weekend with Flow with hesitation but after watching your videos, a few others, and tons of googling I am really excited to show my coworkers tomorrow. I have a whole slew of forms, excel, and flow already built from this weekend really just geeking out and trying new things...so thank you! And also for your quick reply!
Thanks!
I keep getting an Error (400) when I try to test my Flow. The Power BI function doesn't let me map the fields one to one as Jon does in the video. Instead after I define my workspace/dataset Ect. it asks me to add dynamic content to the "Payload". This is where the error occurs every time. Thoughts?
Neat and funny. Good information. Thanks
awesome dude