cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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
Dual Super User

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
Helper IV
Helper IV

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,099)