Forms Responses to Excel and Outlook with Power Automate - Beginners Tutorial

[@andersjensenorg]

Thanks for all your support and nice comments 🙌❤🔥 Find the full Microsoft Power Automate Tutorial here: kzbin.info/aero/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6

[@bobbirowlett6728]

Instructor rating - Great! Easy to follow and good instructions. Works great in the real world!

[@ReneeR08]

Thankyou Anders! Your content has helped me with the integers - not many youtubers will talk us through the way you did. Awesome work

[@andersjensenorg]

Hey Renee, I'm so glad to hear, thanks a lot 😊 Kind regards, Anders

[@pfuentesgalaz]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@regennajalon5251]

This was perfect, exactly what I needed to be able to use Power automate with forms. Thanks you! 5 stars!

[@andersjensenorg]

I'm so glad to hear, kind regards, Anders 🙌🙂

[@wolfgangconfectioners]

You're the man. Thanks for the improved video of this skill. I was successful and your instruction was easy to follow. Thank you!

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@rishabhbahuguna03]

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 :)

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@AnandDighe-n1h]

This is awesome, exactly what I was looking for....ALL Stars to you!

[@andersjensenorg]

Glad I could help! 😊✔️ Kind regards, Anders

[@melindal.614]

This was very helpful and so easy to follow - great job, and THANK YOU SO MUCH!

[@andersjensenorg]

You're very welcome, Melinda L. - your support helps me a lot 😍

[@HammamDisini]

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.

[@andersjensenorg]

Nice, Hammam. Please let me know, if you complete the task 😊

[@abysmalsea1210]

Thank you for this easy example!!!! Best Regards.

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@tomietran9516]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@JK-jt3lr]

Skide god tutorial, det var lige den slags funktionalitet jeg ledte efter.

[@andersjensenorg]

Haha, tusind tak 😍

[@tanmoysana4024]

Very helpful

[@andersjensenorg]

I'm glad to hear 😊

[@paulo.andreola]

Muito obrigado, estou assistindo todos os vídeos e aprendendo muito. Parabéns.

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@javiersalas3918]

Thank you! Five stars!

[@andersjensenorg]

Many thanks 😊🙌🔥

[@SarahSOM]

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!

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jkhaksaar]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@hamzahibrahim3687]

good video..

[@andersjensenorg]

Good video... good comment from you, thanks a lot 😊🙌 Kind regards, Anders

[@68pmpope]

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?

[@andersjensenorg]

Thank you, you can fine create it on an existing Form. The same approach applies 🙂✅️

[@68pmpope]

@@andersjensenorg, thank you.

[@DjenabouDIALLO-z2r]

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.

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@aanchaljoshi9803]

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.

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@aanchaljoshi9803]

Thanks Anders, I really appreciate.

[@tomwoods8754]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@vaibhavtiw1]

Amazing

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@KatieFowler-z4k]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@cesuich]

This is great!!!

[@andersjensenorg]

Thank you so much, Carol 🙌🙌

[@RobertAmine-wg4pu]

Tack :)

[@andersjensenorg]

Du er meget velkommen 🙌🙂

[@enfamousra]

Is it possible to use power automate to get information from multiple Microsoft forms into one excel spreadsheet?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@anjo828]

how will you get the results in your email that is in table form on the body of the email together with the attachments?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@johnwilliam9069]

Sir, what to do so that table option to show in Add a row into table

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@patsharleen6109]

How can I use it to upload existing responses and at the same time for new responses

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@DeadbeatGaming1705]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@viswanathanvasudevan]

@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 .....

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@atishayshrivastava8812]

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

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@nihathasanli]

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?

[@nihathasanli]

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

[@andersjensenorg]

Hey Nihat - thanks a ton for coming back with the solution ❤️

[@JulienB_BTW]

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.

[@andersjensenorg]

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

[@JulienB_BTW]

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

[@andersjensenorg]

Thanks a lot for coming back with the solution 👍😊