Forum Discussion

Untechsavy's avatar
Untechsavy
Copper Contributor
Dec 03, 2020

Converting Microsoft Forms to Sharepoint list

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...
forms
Eva Vogel's avatar
Eva Vogel
Iron Contributor
Dec 03, 2020

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. 

  • Untechsavy's avatar
    Untechsavy
    Copper Contributor
    Dec 03, 2020

    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.

Resources