web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to save form conte...
Power Apps
Answered

How to save form contents to multiple sharepoint list and edit it later

(0) ShareShare
ReportReport
Posted on by 6

I have a power apps - canvas that serves as a questionnaire

 

It has multiple screens, each screen contains one question - each question has multiple fields. either textbox/es and radio button/s

 

How can I save these to a SharePoint list wherein one question = 1 or more sharepoint column

 

and how can I edit it later on? do I need to create a gallery so that users can see all items and they can edit their own (created) forms. What I am planning is to have a SharePoint list webpart with a link to edit that specific list item in PowerApps.

 

 

Categories:
I have the same question (0)
  • BenFetters Profile Picture
    on at

    You could try using the Patch function and referencing several different controls throughout your app. You could use the patch function as many times as you need to submit the data to as many forms as you need. An example could be:

    Patch(DataSource1,Default(DataSource1),{Anwer1:TextInput1.Text});Patch(DataSource2, Default(DataSource1),{Answer2: DropDown1.Selected.Value})

     

    Does that help at all?

     

    Kind regards,

    Ben Fetters

     

  • Verified answer
    v-xida-msft Profile Picture
    on at

    Hi @tonton ,

    How do you list the Questions within the multiple screens of your app? From your SP List?

    Could you please share a bit more about the data structure of your SP List?

    Further, do you want to save the multiple fields of one question into a SP list? Do you want to save all Questions & Answers into single one same SP list or individual SP List (multiple SP lists)?

     

    If you want to save all Questions & Answers into single one same SP list, I have made a test on my side, please take a try with the following workaround:

    Patch(
     'YourSPList',
     Defaults('YourSPList'),
     {Title: "Questionnaire Test", QuestionTitle: "Question1", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...},
     {Title: "Questionnaire Test", QuestionTitle: "Question2", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...},
     {Title: "Questionnaire Test", QuestionTitle: "Question3", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...},
     ...
    )

    If you want to save all Questions & Answers into individual SP List (multiple SP lists), I agree with @BenFetters 's thought almost. Please take a try with the following formula:

    Patch(
     'YourSPList1',
     Defaults('YourSPList1'),
     {Title: "Questionnaire Test", QuestionTitle: "Question1", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...}
    );
    Patch(
     'YourSPList2',
     Defaults('YourSPList2'),
     {Title: "Questionnaire Test", QuestionTitle: "Question2", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...}
    );
    Patch(
     'YourSPList3',
     Defaults('YourSPList3'),
     {Title: "Questionnaire Test", QuestionTitle: "Question3", QuestionProperty1: TextInput1.Text, QuestionProperty2: TextInput2.Text,...}
    );
    ...
    

    More details about Patch function, please check the following article:

    Patch function

     

    In addition, if you want to edit the forms you created, I agree with your thought almost. You could consider add a Gallery control to list all items, then you could filter your own items based on some filter condition, then you could edit it.

     

    Best regards,

  • Community Power Platform Member Profile Picture
    on at

    Thanks for posting in the community @tonton - can you review the above replies and update the thread on if they were helpful? 

     

    Thank you,

     

    @Anonymous 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard