Converting Microsoft Forms to Sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1950976%22%20slang%3D%22en-US%22%3EConverting%20Microsoft%20Forms%20to%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1950976%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20Sharepoint%20list%20and%20a%20Microsoft%20Form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20power%20automate%20I%20am%20trying%20to%20automatically%20populate%20the%20Sharepoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20if%20the%20whole%20form%20is%20not%20completed%20it%20won't%20populate%20the%20list%20in%20Sharepoint%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1950976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1951091%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Microsoft%20Forms%20to%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1951091%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F889206%22%20target%3D%22_blank%22%3E%40Untechsavy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understood%20well%2C%20the%20data%20of%20the%20form%20will%20be%20storage%20in%20the%20SharePoint%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20yes%2C%20the%20power%20automate%20flow%20need%20a%20trigger%20and%20that's%20when%20you%20submit%20the%20responses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20have%20more%20details%20about%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EJM%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-1951127%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Microsoft%20Forms%20to%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1951127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608854%22%20target%3D%22_blank%22%3E%40jmaradiagaio%3C%2FA%3E%26nbsp%3Byes%20what%20you%20said%20is%20correct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20the%20form%2C%20Sharepoint%20and%20flow%20set%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20if%20the%20person%20fills%20in%20every%20box%20on%20the%20form%20it%20populates%20Sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20person%20doesn't%20fill%20in%20one%20of%20the%20boxes%20then%20it%20throws%20an%20error%20and%20the%20information%20doesn't%20flow%20through%20to%20Sharepoint.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1951132%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Microsoft%20Forms%20to%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1951132%22%20slang%3D%22en-US%22%3EDo%20you%20have%20a%20screenshot%20of%20the%20issue%3F%3C%2FLINGO-BODY%3E
New Contributor

I have created a Sharepoint list and a Microsoft Form.

 

Using power automate I am trying to automatically populate the Sharepoint list.

 

The problem is if the whole form is not completed it won't populate the list in Sharepoint at all.

 

Please help

7 Replies

Hello @Untechsavy 

If I understood well, the data of the form will be storage in the SharePoint list?

 

If yes, the power automate flow need a trigger and that's when you submit the responses.

 

Let me know if you have more details about it.

 

Regards,

JM

 

 

@jmaradiagaio yes what you said is correct.

 

I have done the form, Sharepoint and flow set up.

 

The problem is that if the person fills in every box on the form it populates Sharepoint.

 

If the person doesn't fill in one of the boxes then it throws an error and the information doesn't flow through to Sharepoint.

Do you have a screenshot of the issue?

Hi @Untechsavy , you can fill your SP List with a Power Automate Flow to get your Forms Data into it. There is no direct connection so far between SP, Excel and Forms automatically. But it is always a good idea (in my eyes) to do it with SharePoint and not with Excel.

pls. go to "flow.microsoft.com" or with the office tile to the Power Automate Icon Start. I send you here attached a screenshot of this flow, a very easy one. Save it and start a new item in your list then, witch the adopted properties in your SP List and Tenant. Hope that helps. If so, give a LIKE. 

I've got the flow created but if one of the cells isn't populated on the form it throws and error and doesn't populate the Sharepoint table.

 

If all the cells on the form are completed then I have no problems.

@Untechsavy then you can specify directly in your Forms-Form, which field has to be filled. For this to do you have to edit your Forms Fields, if they are mandatory or not. And if they have to be filled, just change this property to mandatory. 

 
 

 

@Untechsavy you also could add a condition action in your flow, to review IF a field content is unequal to Null... only an idea. Screenshot here attached for you.

 

All the best, Eva.