Introducing Forms data sync to Excel
The highly anticipated feature – Forms data sync to Excel is now available in Microsoft Forms. With just one click, you can now easily access all your form responses in Excel for the web and take advantage of Excel’s rich functions to analyze and visualize your data. With automatic syncing of new responses in real-time, you can keep working on your existing spreadsheet without missing a beat. No more juggling multiple copies of the same file, making it easier than ever to stay on top of important data. Ready to check out this feature? Let’s get started!Revamped Forms experience is now available for commercial users
We’ve now revamped the end-to-end experience of Forms for commercial users, offering a sleek and intuitive design from start to finish! You can now enjoy a fresh, modern look across the landing/portal page, form creation, and response analysis. This exciting update makes creating, managing, and analyzing forms easier and more enjoyable than ever before.
Assign an email adress on an option in MS Form
Hi. New here. I just started using MS Form and Workflow to automate requesting study for new projects. I made a form where you will type in project name, location, system to use, etc. Two of the options in this form are the names of the Salesman and the Draftsman that will do the project that the salesman will assign to. My problem is that upon completion of the form, workflow has the flow of: when a new respose is submitted -> Get response -> Create a task in planner -> Send an email. For the create task, I want the draftsman that will be picked in the form will be the one assigned in the planner including the salesman who filled up the form. Next is sending a custom email, with dynamic content highlighting the response on the form and sending that email to the draftsman that the salesman picked in the MS Form. Is it possible to have this kind of flow? If yes, please shed some light on how I can accomplish this. Thanks bunch.Update to the new solution for syncing forms responses to Excel
We are excited to announce that we have a new and improved solution for syncing your form responses to Excel, with better reliability and performance! Previously, some Forms supported an older version of live data synchronization with Excel. This older solution will be gradually discontinued and completely replaced by the new solution by October 20th, 2024.
Can IT Admins Block Anonymous Responses in Microsoft Forms?
Is it possible for admins to configure Microsoft Forms so that users cannot create an option for anonymous responses? For example, if there is a concern that someone might submit inappropriate responses, admins would want the ability to trace who provided the response. From my understanding, an anonymous response is completely untraceable.
MS Forms: multi-select checkbox answers in grid questions
Is there a way in MS Forms to add a multi-select checkbox grid for survey questions? I'm aware of the existing Likert scale grid option but that only allows for selecting one response in each row. I want respondents to able to select more than one option in each row. Google Forms has this feature. If it is not available in MS Forms, how does one go about submitting feedback to have this feature added to Likert scale questions?Newly launched app with intuitive and easy-to-access polling experience for your Teams meetings
Polls is a newly released app in Teams meetings, aims to provide an intuitive and easy-to-access experience when you are searching for a polling tool in Teams meetings. You can find it in multiple locations in Teams via top navigation bar, message extension, sidebar navigation (“…” button) and Teams app store. In addition, you can add it directly to your meetings or chats without login or setup process.Try Copilot in Forms with your Microsoft account
Earlier this year, we rolled out Copilot in Forms for commercial users, and now we’re excited to announce it’s now available for all Microsoft account holders! Get ready to supercharge your form creation with Copilot and easily craft all kinds of daily life forms using your personal Microsoft account. Let’s dive into the exciting details below! Form creation Imagine your birthday is just around the corner, and you’re planning to invite your friends over to celebrate. Let’s see how Copilot can make creating your birthday invitation a breeze! Specify your intention to generate Simply tell Copilot to generate a birthday party invitation, including details like food preferences, guest arrival times, preferred activities, and more. Within a minute, Copilot will provide a draft for you. You can easily adjust the draft by adding or removing questions and keep it. Generate form draft with Copilot Continue adding questions and rewrite Once you've kept the draft to use, what if you forget to include a question about whether anyone will stay for the after-party? No worries! You can access Copilot anytime to easily add this question. Continue adding new questions Also, if you notice there are only four options for activities, you can ask Copilot to rewrite the question to include more options and add with just one click. Rewrite questions Refine the form with Copilot suggestions From Copilot’s suggestions, you can add a birthday theme to the invitation and apply settings like allowing responders to save and edit their responses, just in case someone submits their answers incorrectly and needs to make changes. Finally, Copilot will recommend suitable channels for sending out the invitation. Copilot suggestions Rewrite invitation message Before sending it out, Copilot will help you personalize the default message to better match your birthday celebration. This ensures respondents have a clearer understanding of the invitation's details and timeline, making it easier for them to respond on time. Rewrite the invitation message Quiz creation Quiz generation is also available for Microsoft account holders. Let’s say that during the party, you plan to host a movie trivia quiz, and the person with the most wrong answers will perform a talent show. Let’s see how Copilot can assist with that. Generate quiz draft with detail explanation You can tell Copilot to generate a movie trivia quiz, and the quiz will be generated with correct answers and detailed explanations for each question. Generate quiz with answer explanations Other features, such as continuing to add questions, rewriting, and smart suggestions, are also available for quizzes. You can even rewrite the answer explanations for each question. Rewrite answer explanation Responders check the answer with explanation Your friends can scan the QR code to take the quiz. After submitting, they’ll immediately see the correct answers along with detailed explanations. The person with the most wrong answers will then take the stage to perform in the talent show. Check results and answer explanations after submitting To use Copilot in Forms with your Microsoft account, you need to subscribe to the Copilot Pro plan. Find it in this page under personal plan.
