Excel Forms with approval column?

%3CLINGO-SUB%20id%3D%22lingo-sub-327229%22%20slang%3D%22en-US%22%3EExcel%20Forms%20with%20approval%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327229%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20keen%20to%20use%20digital%20forms%20to%20replace%20the%20many%20form%20systems%20in%20place%20including%20paper%20forms%20and%20sharepoint%20forms.%20Excel%20forms%20look%20ideal%20as%20they%20could%20easily%20be%20set%20up%20by%20users%20with%20very%20little%20training%20(utilising%20the%20form%20with%20a%20sharepoint%20list%20would%20be%20too%20difficult%20for%20ad-hoc%20forms)%20but%20struggling%20to%20add%20an%20approval%20response%20to%20the%20Excel%20Sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20set%20up%20a%20flow%20I%20can%20get%20the%20approvals%20but%20I%20can't%20write%20the%20approval%20comment%20or%20(approved%2Frejected)%20as%20there%20is%20no%20unique%20ID%20for%20the%20submitted%20form%20in%20the%20automatically%20created%20form%20table.%20Other%20than%20searching%20the%20excel%20table%20for%20a%20unique%20combination%20of%20all%20the%20answers%20in%20all%20the%20columns%20(once%20again%20difficult%20for%20a%20standard%20user%20to%20understand)%2C%20is%20there%20any%20other%20options%20with%20Excel%20Forms%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW-%20I%20tried%20the%20submission%20date%20column%20but%20that%20is%20represented%20differently%20in%20Excel%20to%20Forms%20and%20so%20the%20Excel%20lookup%20won't%20find%20the%20correct%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eapproval%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Form%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327235%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Forms%20with%20approval%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327235%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPost%20this%20in%20the%20Excel%20forum%20as%20well%20for%20best%20response!%20Also%20mentioning%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%20Adam%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I am keen to use digital forms to replace the many form systems in place including paper forms and sharepoint forms. Excel forms look ideal as they could easily be set up by users with very little training (utilising the form with a sharepoint list would be too difficult for ad-hoc forms) but struggling to add an approval response to the Excel Sheet.

 

If I set up a flow I can get the approvals but I can't write the approval comment or (approved/rejected) as there is no unique ID for the submitted form in the automatically created form table. Other than searching the excel table for a unique combination of all the answers in all the columns (once again difficult for a standard user to understand), is there any other options with Excel Forms?

 

BTW- I tried the submission date column but that is represented differently in Excel to Forms and so the Excel lookup won't find the correct row.

 

 

1 Reply
Highlighted

Hi!

 

Post this in the Excel forum as well for best response! Also mentioning @Eva Vogel !!

 

/ Adam