Forum Discussion
NachiketD
Sep 16, 2019Copper Contributor
Expert Advice Needed: Update a record in an Excel Online table with multiple Forms
Hello! I am using a MS Form (say Form1) to input data from an external client through a public form (this is key - they are not guest users). I store the responses in a central Onedrive Excel sheet....
Paras Dodhia
Sep 17, 2019Iron Contributor
Hi,
You could potentially automate this use case with Microsoft Flow and using the pre made templates - please refer to the following blog post - https://flow.microsoft.com/en-us/blog/building-scratch-forms-responses/
- NachiketDSep 17, 2019Copper Contributor
Paras Dodhia In effect I am doing something like this. But my question refers to the next phase. Once I have a table of, say, 9 columns, I want to append a 10th column which verifies receipt. I want this verification field to apply exactly to the right row (which is a project/order).