Forum Discussion

Logtbv's avatar
Logtbv
Copper Contributor
Feb 03, 2024

SP Survey to SP list

How can I change a SharePoint survey into a SharePoint list? I would like to use the sp list to fill in with a powerapp. Tried to export the sp survey to excel and then start a new list from excel, tried the iqy and csv extensions. Can anybody help me out? Thank you.

microsoft lists
SharePoint Online
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Feb 04, 2024

    Logtbv have you thought of using Microsoft Forms for your survey instead? The submissions can then be picked up easily by a flow in Power Automate and saved into SharePoint list.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • Logtbv's avatar
      Logtbv
      Copper Contributor
      Feb 04, 2024

      Hi Rob, thanks for your response.

      Maybe I could have added more information.

      We have 5 years of filled in surveys with SharePoint Surveys. With MS lists or SP Online it looks like a SharePoint list but I’m not able to link this to PowerApps as a datasource, same when I try to create an app directly. Making a new SharePoint list from an excel file doesn’t work either.

      What I want is all the data from the past 5 years in the “new” SharePoint list or changing the survey to a list.

       

      EDIT: No I haven’t thought about MS Forms since I don’t have a lot of knowledge of power automate.

Resources