Microsoft Forms - Modifying O365 form data file

Question

I currently have the requirement to obtain information from the field and enter into a custom table. I have created a form in Microsoft Forms which suits my requirement perfectly for the user input.

I would like to know if anyone has had success with modifying the data file to include additional columns for data not obtained by the form.

I have found once columns are manually added the data from the submitted form no longer behaves correctly and not all submitted data inputs to the table.

There appears to be no consistency in regards to the behavior as some fields fill and some don't.  Is there any way to map the correct columns from the field back to the correct column in the table? This way we can operate on the data file online via SharePoint and have all the required data in the one place.

The workaround I have at the moment is I have to manually copy form responses into another working file.

Thanks

Leigh

Answer 1

Hi Leigh,

Did you need further help? Do you have any updates?

Regards,

Qing

Answer 2

Hi Leigh,

Thanks for your updates.

The Excel file only display the responses of the Forms, we didn’t edit the file normally.

According to your description, do you mean that you want to edit or add the response in Excel file and display on Forms?

If so, it is not feasible to meet it. You also can feedback through User Voice.

Besides, you also can confirm if Webbrewers3’s suggestion can meet your requirement.

If this is not your situation, could you please provide the detailed description about the situation?

Regards,

Qing

Answer 3

If what you want is to edit certain fields after a user submits an entry, the simple answer is don't use Forms which is simply an Excel extension. Use a SP list and the associated form it creates automatically.

Answer 4

Hi Leigh,

Thanks for sharing your experience on our forum.

According to your description, my understanding is that you want to add the column on Excel file, then displaying the new question on Forms.

If so, we only can review the responses on Excel. We can’t add question via the Excel file.

As a workaround, you can open the Excel file on Excel online, then select Forms to open it, you can continue adding question via Forms.

Given the situation, we welcome and encourage you to share your ideas through User Voice. It is the best way to perfect our products and services. Many features have been developed or upgraded directly from your ideas.

Thanks for your understanding.

Qing

Hello

Thank you for your reply. After adding the column I do not require the question on the form as I am attempting to track additional information after the form is submitted in the table that relates to the line data. 

Regards

Leigh

Answer 5

Hi Leigh,

Thanks for sharing your experience on our forum.

According to your description, my understanding is that you want to add the column on Excel file, then displaying the new question on Forms.

If so, we only can review the responses on Excel. We can’t add question via the Excel file.

As a workaround, you can open the Excel file on Excel online, then select Forms to open it, you can continue adding question via Forms.

Given the situation, we welcome and encourage you to share your ideas through User Voice. It is the best way to perfect our products and services. Many features have been developed or upgraded directly from your ideas.

Thanks for your understanding.

Qing