Forms Responses to Excel and Outlook with Power Automate - Beginners Tutorial
Vložit
- čas přidán 10. 07. 2024
- This tutorial shows how to automatically add Forms responses to Excel and Outlook with Microsoft Power Automate. You'll learn to automate the survey tool from Microsoft Office365, Forms.
VIDEOS FOR YOU:
🔹 Power Automate Tutorials: • Microsoft Power Automa...
🔹 Power Automate Desktop for Beginners: • Power Automate Desktop...
POWER AUTOMATE GROUPS:
👨👩👧👦 Discord: / discord
- Join my network with 4100+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!
👩🏻🎓 LinkedIn: / 12566435
👨🏻💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
0:00 Get Forms Responses into Power Automate
When we want to get responses from Microsoft Forms, we need to export them manually. With Power Automate, we can automatically get the Form's responses and save them to an Excel sheet.
3:53 Save Forms Responses to Excel
It's straightforward to save Forms responses directly into Excel. The requirement is that the Excel book needs to be in either OneDrive, SharePoint, or Dropbox. It also needs to be formatted as a table.
9:19 Send an email based on Forms response
We can send ourselves emails based on Forms responses. Either for every response or based on a condition. Then, we convert the response into an integer to compare it in our condition.
#powerautomate #powerplatform #office365 - Věda a technologie
Thanks for all your support and nice comments 🙌❤🔥
Find the full Microsoft Power Automate Tutorial here: czcams.com/play/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6.html
Thankyou Anders! Your content has helped me with the integers - not many youtubers will talk us through the way you did. Awesome work
Hey Renee, I'm so glad to hear, thanks a lot 😊 Kind regards, Anders
Thank you! Five stars!
Many thanks 😊🙌🔥
This was perfect, exactly what I needed to be able to use Power automate with forms. Thanks you! 5 stars!
I'm so glad to hear, kind regards, Anders 🙌🙂
Very helpful
I'm glad to hear 😊
This is awesome, exactly what I was looking for....ALL Stars to you!
Glad I could help! 😊✔️ Kind regards, Anders
You're the man. Thanks for the improved video of this skill. I was successful and your instruction was easy to follow. Thank you!
Thanks a ton, Wolfgang Confectioners 🤩 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
This was very helpful and so easy to follow - great job, and THANK YOU SO MUCH!
You're very welcome, Melinda L. - your support helps me a lot 😍
Skide god tutorial, det var lige den slags funktionalitet jeg ledte efter.
Haha, tusind tak 😍
Thank you for this easy example!!!! Best Regards.
You're very welcome, @abysmalsea1210 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html
Amazing tutorial, Anders.
Grateful for the learning you've been providing to the community with the help of simplest approach 🥳🥳👏👏
PS. Using power apps for the very first time :)
Thanks a lot, Rishabh Bahuguna 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
This is great!!!
Thank you so much, Carol 🙌🙌
First video that really helps me.
The only thing I need is to be able to send the excel as an attachment each time a change is made
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Muito obrigado, estou assistindo todos os vídeos e aprendendo muito. Parabéns.
Thanks a lot, @paulo.andreola 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
good video..
Good video... good comment from you, thanks a lot 😊🙌 Kind regards, Anders
Just what I needed, thank you for sharing this. I thinking about creating a report which the contents are from Forms and then attach that report and email it directly to the respondents.
Nice, Hammam. Please let me know, if you complete the task 😊
Amazing
Hey @vaibhavtiw1. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Great video! It's exactly what I needed.
I have one question: How can I incorporate the URL of the submitted Microsoft form into the live spreadsheet so we can edit the form when necessary?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Tack :)
Du er meget velkommen 🙌🙂
Thank you for the video, very helpful and instructive! I do have a question though. I'm able to use Power Automate so the responses are sent to a shared inbox, only if I'm the sole owner of the form I created. However if I create a group form (linked to a shared Sharepoint site) once I get into Power Automate I don't get the option to link the group form I created. Do you know how I can remediate to that? The organization I work for has 28 000 employees and several employees move around a lot, so we try not to be sole owners of the work tools and documents we create. Thanks!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Thank you for your amazing tutorial, I want to know how can i do this vice versa, we have already an Excel file which was filled manually with reports, I want to have the responses entered manually to the excel sheet on the Forms Responses section I have a created a dynamic Excel file in OneDrive and added the data there but it is not appearing on the Forms Responses section. I really appreciate your kind support. thanks, in advance
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Great video. Is it possible to create this flow on top of an existing Form or do I have to create a new one in order for this to work?
Thank you, you can fine create it on an existing Form. The same approach applies 🙂✅️
@@andersjensenorg, thank you.
Hello :)
Thank you for this video.
I would like to know how to make the power automate flow process the responses to the form one by one please.
Indeed, I have a power automate flow that does exactly the same thing as yours, except that in my Excel file, there are graphs which are built according to certain answers and based on a single line of writing.
So I have to have a single line in my Excel file every time.
So I added a step to copy the Excel file by adding the ID at the end and then delete the line written in the original file. This copy is then turned into a PDF and sent to the respondent.
But the problem is that, as soon as I have two or more answers at the same time, I have several lines that are written in my Excel file and my graphs come out of errors.
Note that for each step, I use a loop.
Thank you for your feedback.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Great video - need some advice on this. I did this, and then submitted a few tests (one to check it worked, and a couple to show colleagues). My problem is that I deleted these tests from my Forms and then from the spreadsheet and when a new response comes in, it gets added to the row after where the deleted tests were instead of at the top of the spreadsheet. Any ideas how to fix this please?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders,
I am working on a project where I have to create a form to gather employee's IT device information. Than, the form answers should navigate to the program Manager for approval and the approvals should be save into an excel sheet which will be operated by IT manager. Please guide me.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Thanks Anders, I really appreciate.
@andrew we have a task to do using power automate , like we have 2 collapsible meeting say A & B when we merge both the rooms, we are calling it as meeting room C , if we book C meeting room PAutomate should check rooms A & B to validate not booked Individually , could help me with this scenario ? Thanks .....
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
This was so helpful but I'm running into a unique situation - My form has questions with multiple possible answers, and when multiple answers are selected for a single question, the excel populates the answers in a string separated by " / and ]. Am I able to format how the form responses are imported into excel? Of course, all of the data is there but I would like to make it 'easy on the eyes' for the end user. Thank you in advance!!
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Is it possible to use power automate to get information from multiple Microsoft forms into one excel spreadsheet?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
how will you get the results in your email that is in table form on the body of the email together with the attachments?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Sir, what to do so that table option to show in Add a row into table
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I have a few more columns apart from those in form. How do i include them in email because the columns apart from those of form are going blank in email
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi sir i have also same thing but insisted of excel i need to add the data into uipath queue add queue item using power automate i have tried but it failing please help me
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
How can I use it to upload existing responses and at the same time for new responses
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I had a problem: The dynamic response from API excelonlinebusiness operation "GetTable" is too large, only schemas with at most "1024" properties are supported.
How can eliminate it?
Fixed!
I started having this issue on a flow that previously had been working. Struggled with the lack of information on what was actually wrong. In my case it turned out that the table definition somehow became corrupted. My simple 16 column table now covered over 16,000 columns! Once that was fixed everything worked
Hey Nihat - thanks a ton for coming back with the solution ❤️
There's no Id that shows up in the drop down menu. When I try to paste the Id link, no dynamic content seems to show up.
Hey JulienB. That's strange. I know this sounds like the usual "Tier 1 Support", but can you try to remove the trigger and add it again? Kind regards, Anders
@@andersjensenorg I believe it was because I'm not the form creator. I asked my collegue who created the form and she could do it. Thank you for your reply!
Thanks a lot for coming back with the solution 👍😊