Forms data sync to Excel is now fully available with more functionality
We’ve been gradually rolling out Forms data sync to Excel . During this process, we actively collected user feedback and iterated to enhance the feature for various use cases. I’m excited to announce that this feature is now fully available for all customers, complete with additional capabilities. Let’s explore these updates together.
Import data from a Microsoft Forms PDF into Excel
Hi all. I have a number of PDFs for clients which contain questionnaires, score sheets, etc. Some are completely external, and some are from Microsoft Forms. A while back, I created a Macro/some VBA code to read data from the external PDFs, import it into Excel and display the figures; it works really well. Today, I've tried to update it to load data from the PDFs created by "printing" a Microsoft Forms complete questionnaire and saving as a PDF - unfortunately, when trying to import this into Excel (using "Get Data -> From File -> PDF"), the "Likert" questions are appearing but showing "null" for all the columns, not identifying which contains the "selected" checkbox. Possibly a slim hope, but I was wondering if anyone has experience doing something similar, or can recommend a way to get this to work? I know there are potentially other ways to approach this (I tried connecting it directly to the linked Sharepoint Excel file, but the URL is entirely powered by URL arguments ?foo=bar&baz=boing etc, and Excel demands those all be deleted when giving it a filename to connect to to get data from the web, helpfully); connecting it to a "local" version of the Excel file on OneDrive is a possibility, but ideally I'd a) want the tool to be accessible to people who have access to the PDFs but not the spreadsheet, and b) have to save the print-out PDFs in every client folder to store their data together, and the spreadsheet may occasionally be purged, so the PDF is the "safe" way to access the data.) PDFs can't be run through any online tools due to containing sensitive data. Many thanks.
my microsoft account is hacked
5 days ago, i was trying to verify my account at a discord server, then i realize that they are hacking my account because of incoming security mails. they changed my account security mails. and they even changed my mail to mailto:email address removed for privacy reasons (my mail was mailto:email address removed for privacy reasons). i tried to save my account through "save your account", but it didnt work because i dont know the birth date of the e mail( i usually dont use my own (im not under 18)). i have bunch of proof that it was my e mail. i bought xbox pc game pass subscription 2-3 months ago and i bought minecraft pc edition 1 months ago with that microsoft account. i have all payment info etc. please give my microsoft account back. i am also uploading screenshots. please help me 😕 (sorry for poor language, the screenshots is turkish, if it is possible i need a turkish support people )
Resubmitted response overrides original response instead of making a new entry
Hi, I have a Microsoft Form that allows respondents to edit their submissions after submitting. Last week when someone resubmitted their response, it created a new entry in the Excel sheet which is what I prefer since it triggered a Power Automate flow. However, I ran it again this week and now it seems to override the original response in the Excel sheet. This does not trigger the flow, which is a big issue. Does anyone know why this might be happening/how to fix it? Thanks in advance!
Forms: Time input question
In Office 365 Forms, I am attempting to create an event request form. I do not appear to be able to add a question for TIME of Day. I see a template for DATE but not TIME. In Google Forms "include Time" is an option for Date Questions in the contextual sub-menu. Is there someplace to add this function perhaps that I am missing? Ultimately I would like to add a script to the form that would auto-create an Outlook Calendar event on a shared calendar at the date and time on the form submission.Microsoft Forms - Need to view Image on Form
Hello everyone, I am new to Microsoft Forms and could do with some help. I have uploaded several images using the 'Upload file' tool but I need the image itself so show rather than a link. I need to be able to print the form / email it to a customer with the image showing. I have tried changing the images to a PDF and this has not worked. Can anybody help? Is Microsoft Forms even capable of doing this? Or will it show images as links only? Thanks Theo
