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

Sharepoint list form over mutiple pages

I have a sharepoint list with lots of columns - when I open the edit/new form in PowerApps (to make some tweaks to the functionality), there are too many to fields to fit on the form.  How can I spread the fields over two forms, and switch between them,  and both submit when the standard sharepoint save button is pressed (or any other solution?

 

Happy to watch videos/read training sites if there are any that will help 🙂

 

cheers

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Generally reducing the height of datacardvalues to say 30 or less depending on the font size inside the datacardvalues will enhance the form look s.

 

However if that doesn't work then work this on Tabs for two or more for

https://youtu.be/if_mFIfi5PM

https://youtu.be/N8AsxE__Mw8

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

2 REPLIES 2
Super User III
Super User III

Generally reducing the height of datacardvalues to say 30 or less depending on the font size inside the datacardvalues will enhance the form look s.

 

However if that doesn't work then work this on Tabs for two or more for

https://youtu.be/if_mFIfi5PM

https://youtu.be/N8AsxE__Mw8

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Community Support
Community Support

Hi @StevieC ,

Do you customize a form for your SP list using PowerApps?

Do you want to split your multiple SP List columns into multiple Edit forms?

 

Based on the needs that you mentioned, I think PowerApps could achieve your needs. You could consider add additional Edit forms in your custom form app, and make all of these Edit forms connect to same SP List data source (Set DataSource property of these Edit forms to your same SP List).

 

Then within each Edit form, enable desired fields. Add a "Next" button in your first Edit form screen, set the OnSelect property to following:

Navigate(SecondEditFormScreen)

press the "Next" button to navigate to second Edit form screen.

 

Set the OnSave property of SharePointIntegration control to following:

Patch(
      'Your SP List',
      If(
           EditForm1.Mode = FormMode.New && EditForm2.Mode = FormMode.New,
           Defaults('Your SP List'),
           EditForm1.Mode = FormMode.Edit && EditForm2.Mode = FormMode.Edit,
           SharePointIntegration.Selected
      ),
      EditForm1.Updates,            // EditForm1 represents the First Edit form in your app, please replace it with actual form name
      EditForm2.Updates             // EditForm2 represents the Second Edit form in your app, please replace it with actual form name
);
ResetForm(EditForm1);ResetForm(EditForm2);
RequestHide()

Set the OnNew property of SharePointIntegration to following:

Refresh('Your SP List');
NewForm(EditForm1);
NewForm(EditForm2)

Set the OnEdit property of SharePointIntegration to following:

Refresh('Your SP List');
EditForm(EditForm1);
EditForm(EditForm2)

Set the OnView property of SharePointIntegration to following:

Refresh('Your SP List');
ViewForm(EditForm1);
ViewForm(EditForm2)

Note: For submitting multiple Edit form data into single one record in your SP list, I think SubmitForm function could not achieve your needs, instead, please use Patch function to submit your Edit form data

 

More details about split Edit form fields into multiple screen, please also check the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Is-it-possible-to-split-the-Edit-Form-into-m...

 

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (49,891)