Expert Advice Needed: Update a record in an Excel Online table with multiple Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-857462%22%20slang%3D%22en-US%22%3EExpert%20Advice%20Needed%3A%20Update%20a%20record%20in%20an%20Excel%20Online%20table%20with%20multiple%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857462%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20am%20using%20a%20MS%20Form%20(say%20Form1)%20to%20input%20data%20from%20an%20external%20client%20through%20a%20public%20form%20(this%20is%20key%20-%20they%20are%20not%20guest%20users).%20I%20store%20the%20responses%20in%20a%20central%20Onedrive%20Excel%20sheet.%20The%20info%20collected%20is%20for%20requesting%20extra%20resources.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20these%20extra%20resources%20are%20deployed%2C%20the%20client%20verifies%20the%20extra%20resources%20physically.%20The%20client%20now%20wants%20to%20have%20another%20form%20which%20allows%20them%20to%20say%20%22Y%2FN%22%20for%20the%20received%20resources.%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%20I%20want%20to%20append%20this%20column%20to%20the%20original%20excel%20table%2C%20but%20maintaining%20the%20accuracy%20of%20each%20record%20(no%20values%20should%20be%20edited.%20Y%2FN%20verification%20should%20apply%20to%20the%20right%20record%2Forder).%20Is%20there%20a%20way%20I%20can%20append%2Fpatch%20this%20single%20column%20to%20an%20existing%20Excel%20sheet%3F%3C%2FP%3E%3CP%3EIf%20MS%20Forms%20is%20not%20the%20right%20tool%2C%20can%20you%20please%20suggest%20something%20preferably%20free%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20I%20am%20not%20an%20IT%20guy.%20I%20am%20a%20manufacturing%20engineer%20trying%20to%20digitize%20a%20process%20with%20above%20avg%20understanding%20of%20O365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUpdate%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858622%22%20slang%3D%22en-US%22%3ERe%3A%20Expert%20Advice%20Needed%3A%20Update%20a%20record%20in%20an%20Excel%20Online%20table%20with%20multiple%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20potentially%20automate%20this%20use%20case%20with%20Microsoft%20Flow%20and%20using%20the%20pre%20made%20templates%20-%20please%20refer%20to%20the%20following%20blog%20post%20-%20%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fbuilding-scratch-forms-responses%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fbuilding-scratch-forms-responses%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409699%22%20target%3D%22_blank%22%3E%40NachiketD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858641%22%20slang%3D%22en-US%22%3ERe%3A%20Expert%20Advice%20Needed%3A%20Update%20a%20record%20in%20an%20Excel%20Online%20table%20with%20multiple%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F102179%22%20target%3D%22_blank%22%3E%40Paras%20Dodhia%3C%2FA%3E%26nbsp%3BIn%20effect%20I%20am%20doing%20something%20like%20this.%20But%20my%20question%20refers%20to%20the%20next%20phase.%20Once%20I%20have%20a%20table%20of%2C%20say%2C%209%20columns%2C%20I%20want%20to%20append%20a%2010th%20column%20which%20verifies%20receipt.%20I%20want%20this%20verification%20field%20to%20apply%20exactly%20to%20the%20right%20row%20(which%20is%20a%20project%2Forder).%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. The info collected is for requesting extra resources. 

When these extra resources are deployed, the client verifies the extra resources physically. The client now wants to have another form which allows them to say "Y/N" for the received resources. 

Ideally I want to append this column to the original excel table, but maintaining the accuracy of each record (no values should be edited. Y/N verification should apply to the right record/order). Is there a way I can append/patch this single column to an existing Excel sheet?

If MS Forms is not the right tool, can you please suggest something preferably free?

 

P.S. I am not an IT guy. I am a manufacturing engineer trying to digitize a process with above avg understanding of O365.

2 Replies

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/

 

@NachiketD 

@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).