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, t...
microsoft lists
SharePoint Online
Rob_Elliott's avatar
Rob_Elliott
Silver 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