Forum Discussion
MicrosoftIs there an API to read Microsoft forms data
Is there any way you could let me view your code? I am trying to do the exact same thing you mentioned above.
Currently I manually click the "Open in Excel" button under "Responses" Tab. There is a macro that copies the data from sheet 1 into sheet 2 and does some re-formatting and parsing of image urls etc. Then it takes the values from each field and places them into specific bookmarked fields in a word template to build a standardized report. As of right now I have to manually dl the excel file after each submission then manually enter the store number to choose which row to use to build the correct report.
I would like to just be able to link the table in excel to the data produced by clicking the button. But even if I could just automate the process of "open in excel" it would help tremendously. I am stuck here and quite frustrated. I have tried power automate but get lost pretty quickly.
Could you share your methodology? I would truly appreciate it.
Thanks in advance!
At this point my need to use the Form has evaporated, so I haven't done anything with it lately. The process I ended up with still had a couple manual steps, and as they were very application-specific, I doubt that it would help you much.
I abandoned the attempt to use the API, because it would only work when I was already online and authenticated in a browser (and couldn't use it a server-based web app). There was another post in this thread that had a workaround for this, but it seemed too complicated for me based on the temporary nature of my app.
My manual process was to download the spreadsheet with form results, then import it into a SQL Server table using BCP. The download and BCP import were manual steps that only took a minute to run, but I had to do it every day to refresh the data (so I never did get to realtime form results). Once it was in a SQL table in raw form, I had some other automated steps that transformed the raw data, linked it with other tables in the database, and became the data source for a .Net Core web app.
Sorry I don't have more helpful advice. Honestly, it would have been easier to just develop a custom web app from scratch than try to incorporate the Forms data (but using Forms for my particular use case was "suggested" by management).