cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

Integrating SharePoint List with PowerApps

Also on the app, there are so many fields in just one page is there a way to split the fields into daily screens but the records will still come out as one record. 

 

Screenshot (113).png

 

Screenshot (114).png

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: Integrating SharePoint List with PowerApps

You can split the fields across multiple pages, but that means using two forms, which will complicate saving the data since you won't be able to just use SubmitForm().  You'll need to use Patch() to save the record.  But its definately possible.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Frequent Visitor

Re: Integrating SharePoint List with PowerApps

Hello Sr,

I recently made an application with some SharePoint lists that worked perfectly.

But I went to do another one in the same way and it generates an error
the programming used was:

 ClearCollect(LastItem;Patch('R1_FIMDEVIDA(DesbasxFibraxFlap)';{Title:T1_CLI.Text;zkrl:'T1_E-'.Text;OData__x006f_i47:T1_APLI.Text;l3o4:T1_MAT.Text})) 

 

the following error happened:

Highlighted
Community Support
Community Support

Re: Integrating SharePoint List with PowerApps

Hi @SandraAkujobi ,

Do you want to split your SP List fields into multiple Edit forms in different screen, and want these multiple Edit forms save data to single one record in SP list rather than separated rows?

 

Based on the needs that you mentioned, I think the Patch function could achieve your needs. The user @Wozza and @calvares have faced similar issue with you, please my response within the following thread:

https://powerusers.microsoft.com/t5/Creating-Apps/Multiple-screen-app-looks-nice-for-the-user-proble...

https://powerusers.microsoft.com/t5/Creating-Apps/Multiple-forms-to-one-item-sharepoint-list/m-p/142...

 

On your side, you could add multiple screens in your canvas app, add one Edit form in each screen, connect these Edit forms to same SP list. Add a "Submit" button in the last screen, and "Next" button in the rest of screens.

Set the DefaultMode property of all Edit forms to following:

FormMode.New

Set the OnSelect property of the "Submit" button to following:

Patch(
       'Your SP List',
        Defaults('Your SP List'),
        EditForm1.Updates,
        EditForm2.Updates,
        EditForm3.Updates,
        ...
        ...
)

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Partisan
Post Partisan

Re: Integrating SharePoint List with PowerApps

Hi @v-xida-msft Access was denied with the two links you sent. But I will try doing what you recommended and let you know of the progress. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,736)