Unanswered

Edit form connected to OneDrive Excel

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Quick question I hope someone can help me with.

If I create an online form in Office365 from a OneDrive Excel file, once I there are several responses submitted from the form and therefore the form's questions have been automatically added as columns into the excel in OneDrive, can I edit the form (i.e. adding/deleting questions or sections?

I created a form and submitted several responses which were added to the excel. then I wanted to change the form (add more questions, move section around....) so deleted all the excel columns (including the top row with the column names). To my disappointment, once I did that and submit a new response in the form the excel didn't get update so my doubt is whether is possible to edit forms and still get the responses added to the excel.

Many thanks in advance for your help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-litu-msft on at

Like (1)

Report

Hi @Anonymous,

Yes, you could edit the form, and add the new form response to the Excel table.

After you edit the form and delete the columns of Excel, you should delete the add a row into a Excel table action in Flow and recreate a new one with newly excel table. Or it will report such as excel table couldn't found error.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-litu-msft thank you for your response.

I tried building a new flow for creating a table in Excel from a form response but Im struggling to get it right. How can I turn the form response format into a excel table format?

See my try

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report

Hi @Anonymous,

Thanks for your reply, you could refer to the following steps:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-litu-msft That works!! Thanks a lot 🙂

Was this reply helpful? Yes No