Filling a Template from Microsoft Form

%3CLINGO-SUB%20id%3D%22lingo-sub-2074878%22%20slang%3D%22en-US%22%3EFilling%20a%20Template%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074878%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20know%20how%20to%20set%20up%20the%20automation%20to%20fill%20a%20template%20from%20a%20microsoft%20form%20submission.%20What%20I%20wanted%20to%20know%20is%2C%20when%20the%20form%20is%20submitted%2C%20there%20are%20a%20few%20fields%20automatically%20generated%20by%20the%20system%20into%20the%20excel%20file%20that%20houses%20the%20responses%2C%20namely%20%22ID%22%20and%20%22Completion%20Time%22.%20I%20wanted%20to%20know%20if%20it%20were%20possible%20to%20pull%20those%20two%20fields%20into%20a%20template%2C%20I%20have%20not%20been%20able%20to%20figure%20this%20out%20as%20it%20doesn't%20seem%20to%20work%20the%20same%20way%20that%20a%20user%20input%20field%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EMichael%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2074878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2075211%22%20slang%3D%22en-US%22%3ERe%3A%20Filling%20a%20Template%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2075211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879234%22%20target%3D%22_blank%22%3E%40Santiman21%3C%2FA%3E%26nbsp%3Ba%20template%20for%20what%3F%20Word%3F%20PDF%3F%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%3CLINGO-SUB%20id%3D%22lingo-sub-2075379%22%20slang%3D%22en-US%22%3ERe%3A%20Filling%20a%20Template%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2075379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20a%20fillable%20word%20document.%20I%20can%20get%20all%20the%20user%20entered%20fields%20in%20the%20microsoft%20form%20to%20come%20over%2C%20but%20not%20those%20automatically%20generated%20ones%20that%20are%20in%20the%20excel%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2079793%22%20slang%3D%22en-US%22%3ERe%3A%20Filling%20a%20Template%20from%20Microsoft%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879234%22%20target%3D%22_blank%22%3E%40Santiman21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20input%20on%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

So I know how to set up the automation to fill a template from a microsoft form submission. What I wanted to know is, when the form is submitted, there are a few fields automatically generated by the system into the excel file that houses the responses, namely "ID" and "Completion Time". I wanted to know if it were possible to pull those two fields into a template, I have not been able to figure this out as it doesn't seem to work the same way that a user input field works.

 

Any help would be greatly appreciated.

 

Best,

Michael

3 Replies

@Santiman21 a template for what? Word? PDF?

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

 

It is a fillable word document. I can get all the user entered fields in the microsoft form to come over, but not those automatically generated ones that are in the excel file.

@Santiman21 

 

 

Anyone have any input on this?