MS FORM to list - date , time, name, submission date and time.... how to

%3CLINGO-SUB%20id%3D%22lingo-sub-1349416%22%20slang%3D%22en-US%22%3EMS%20FORM%20to%20list%20-%20date%20%2C%20time%2C%20name%2C%20submission%20date%20and%20time....%20how%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1349416%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20created%20a%20MS%20Form%20for%20registration%20and%20I%20noticed%20that%20MS%20Form%20will%20auto%20capture%20the%20following%20into%20excel%20spreadsheet%3C%2FP%3E%3CP%3Ename%2C%20Start%20and%20end%20time%2C%20email%20address%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20use%20the%20same%20MS%20Form%20to%20work%20with%20SharePoint%20workflow%20to%20capture%20all%20these%20data%20into%20SP%20list%20without%20creating%20the%20same%20field%20to%20be%20filled%20in%20the%20FORM%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20it%20in%20the%20workflow%3F%26nbsp%3B%20%26nbsp%3BCan%20someone%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I%20also%20need%20to%20have%20the%20date%20and%20time%20that%20should%20be%20auto%20generated%20from%20MS%20Form%20into%20the%20list%20as%20a%20record.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2nd%2C%20I%20want%20to%20input%20a%20short%20sentence%20that%20is%20for%20read%20only%20.%26nbsp%3B%20how%20can%20I%20not%20have%20the%20fill%20in%20box%20show%20up%20at%20the%202nd%20section%20of%20the%20text%3F%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EPlease%20help.%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1349416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERegistration%20workflow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1350461%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20FORM%20to%20list%20-%20date%20%2C%20time%2C%20name%2C%20submission%20date%20and%20time....%20how%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1350461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612792%22%20target%3D%22_blank%22%3E%40bbsin%3C%2FA%3E%26nbsp%3Byou%20can%20do%20this%20with%20a%20flow%20in%20Power%20Automate.%20At%20its%20simplest%20it%20just%20needs%20a%20Forms%20When%20a%20new%20response%20is%20submitted%20trigger%20follwed%20by%20actions%20to%20get%20the%20response%20details%20then%20create%20a%20new%20item%20in%20the%20SharePoint%20list.%20You%20can%20add%20other%20actions%2C%20for%20example%20send%20the%20answers%20to%20the%20questions%20back%20to%20the%20responder%20by%20email%20which%20we%20always%20do%20in%20our%20company%20as%20a%20confirmation%20the%20form%20has%20been%20received.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22simpleForm-SP.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F187945iCD4FF5045C9E7677%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22simpleForm-SP.png%22%20alt%3D%22simpleForm-SP.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20your%20second%20question%2C%20the%20only%20way%20to%20add%20some%20read-only%20text%20is%20by%20adding%20a%20new%20section%20and%20putting%20in%20the%20text%20in%20the%20description%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22read-only%20text.png%22%20style%3D%22width%3A%20859px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F187946i7C9E17A10DF3DED3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22read-only%20text.png%22%20alt%3D%22read-only%20text.png%22%20%2F%3E%3C%2FSPAN%3E%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1357060%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20FORM%20to%20list%20-%20date%20%2C%20time%2C%20name%2C%20submission%20date%20and%20time....%20how%20to%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1357060%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%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20if%20there%20any%20way%20to%20create%20a%20registration%20first%20and%20after%20it%20is%20submit%2C%20the%20page%20should%20open%20or%20go%20to%20a%20new%20page%20that%20has%20the%20event%20link%20for%20them%20to%20click%20to%20enter%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWill%20MS%20Form%20be%20able%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%20to%20feedback%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

hi,

 

I had created a MS Form for registration and I noticed that MS Form will auto capture the following into excel spreadsheet

name, Start and end time, email address

 

Now I want to use the same MS Form to work with SharePoint workflow to capture all these data into SP list without creating the same field to be filled in the FORM again.

 

How can I do it in the workflow?   Can someone advice.

 

And I also need to have the date and time that should be auto generated from MS Form into the list as a record.

 

2nd, I want to input a short sentence that is for read only .  how can I not have the fill in box show up at the 2nd section of the text??


Please help. thanks.

2 Replies

@bbsin you can do this with a flow in Power Automate. At its simplest it just needs a Forms When a new response is submitted trigger follwed by actions to get the response details then create a new item in the SharePoint list. You can add other actions, for example send the answers to the questions back to the responder by email which we always do in our company as a confirmation the form has been received.

 

simpleForm-SP.png

 

For your second question, the only way to add some read-only text is by adding a new section and putting in the text in the description field.

 

read-only text.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

 

@Rob Elliott 

 

Thank you

 

Do you know if there any way to create a registration first and after it is submit, the page should open or go to a new page that has the event link for them to click to enter??

 

Will MS Form be able to do it?

 

Anyway to feedback?