Forms Spreadsheet question

%3CLINGO-SUB%20id%3D%22lingo-sub-1931338%22%20slang%3D%22en-US%22%3EForms%20Spreadsheet%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1931338%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20am%20trying%20to%20use%20forms%20for%20COVID%20notification%20submission.%26nbsp%3B%20I%20have%20requested%20that%20each%20one%20of%20my%20school%20buildings%20enter%20information%20regarding%20their%20staff%20of%20needing%20to%20take%20time%20for%20a%20COVID-related%20issue%20(quarantine%2C%20illness%2C%20childcare%2C%20etc).%26nbsp%3B%20I%20added%20two%20questions%20at%20the%20end%20of%20the%20survey%20for%20my%20use%20only.%26nbsp%3B%20The%20goal%20is%20to%20share%20this%20list%20with%20my%20payroll%20department%20so%20that%20they%20know%20who%20may%20be%20eligible%20for%20COVID%20reimbursement.%26nbsp%3B%20Unfortunately%2C%20I%20cannot%20figure%20out%20how%20to%20go%20into%20each%20survey%20submitted%20to%20add%20responses%20so%20that%20that%20they%20appear%20on%20the%20generated%20excel%20spreadsheet.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1931338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936191%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Spreadsheet%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881518%22%20target%3D%22_blank%22%3E%40Hugh681%3C%2FA%3E%26nbsp%3Bnot%20with%20Forms%20on%20its%20own.%20What%20I%20do%20in%20these%20circumstances%20is%20to%20save%20the%20response%20to%20a%20list%20in%20SharePoint%20via%20flow%20in%20Power%20Automate%20(we%20always%20do%20this%20anyway).%20You%20would%20have%20one%20column%20in%20the%20list%20for%20each%20question%20and%20a%20column%20for%20each%20of%20the%20supplementary%20questions.%20You%20could%20either%20go%20into%20the%20list%20regularly%20or%20have%20the%20flow%20notify%20you%20by%20email%20of%20the%20new%20form%20submission.%20I%20would%20then%20add%20another%20single%20line%20of%20text%20column%20which%20is%20formatted%20with%20JSON%20to%20trigger%20an%20email%26nbsp%3B%20of%20the%20details%20of%20that%20item%20in%20the%20list%20(including%20your%20answers)%20to%20the%20payroll%20department.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So I am trying to use forms for COVID notification submission.  I have requested that each one of my school buildings enter information regarding their staff of needing to take time for a COVID-related issue (quarantine, illness, childcare, etc).  I added two questions at the end of the survey for my use only.  The goal is to share this list with my payroll department so that they know who may be eligible for COVID reimbursement.  Unfortunately, I cannot figure out how to go into each survey submitted to add responses so that that they appear on the generated excel spreadsheet.  Any ideas?

1 Reply

@Hugh681 not with Forms on its own. What I do in these circumstances is to save the response to a list in SharePoint via flow in Power Automate (we always do this anyway). You would have one column in the list for each question and a column for each of the supplementary questions. You could either go into the list regularly or have the flow notify you by email of the new form submission. I would then add another single line of text column which is formatted with JSON to trigger an email  of the details of that item in the list (including your answers) to the payroll department.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User