cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PytByt
Post Prodigy
Post Prodigy

How to Distribute 1 SP List into Multiple Edit Form

Hi all..

 

i want to know how am i suppose to properly distributes a single SP Lists Which contain a 110 fields, into multiple edit form?

 

the idea is, after the user submit all the fields, they want to review it again, so i need to display it again in and edit form. the problem is, i have to devide it into a few (10) different form because there's too much field to show.

 

this is the continuity from my previous thread here, which is already solved with Master @yashag2255 .

 

i open to any suggestion right now for i am desperate.

 

thanks,

 

regards.

pytbyt

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @PytByt ,

I've tested the formula in the issue that you posted, it works.

So if you want to create a record by using 10 forms, I suggest you use 

Patch(
          'SP List-1',
           Defaults('SP List-1'),
           Form1.Updates,
           Form2.Updates,
           Form3.Updates,
          ...
          ...
          Form9.Updates,
          Form10.Updates
)

In this issue, do you want to edit the 10 forms and submit them to the same record?

Try this:

SubmitForm(Form1);SubmitForm(Form2);.......;SubmitForm(Form10) 

Set all the form's Item to the same Item and DefaultMode to FormMode.Edit.

 

 

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yutliu-msft
Community Support
Community Support

Hi @PytByt ,

I've tested the formula in the issue that you posted, it works.

So if you want to create a record by using 10 forms, I suggest you use 

Patch(
          'SP List-1',
           Defaults('SP List-1'),
           Form1.Updates,
           Form2.Updates,
           Form3.Updates,
          ...
          ...
          Form9.Updates,
          Form10.Updates
)

In this issue, do you want to edit the 10 forms and submit them to the same record?

Try this:

SubmitForm(Form1);SubmitForm(Form2);.......;SubmitForm(Form10) 

Set all the form's Item to the same Item and DefaultMode to FormMode.Edit.

 

 

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yutliu-msft 

 

Im using your formula and went great. 

 

But...

I have a road bump here when i try to add each attchment data card in every form (10 form i've got) so, there's 10 attachement total distributed in each form.

 

The problem is, the attachment from each form (form 1 through 10) NOT SAVING to the SP list. i already tried almost everything in the forum.

 

I wanna know, is there something i missing out that makes the attachment not working?

here is a few image reference for my distributed from with each attachment data card:

att-1.pngatt-2.pngatt-3.png

 

And this is the exact formula i use in Button Save (for all the form obviously):
Patch('_Onboarding List', Gallery2.Selected, FormTab1.Updates, FormTab2.Updates, FormTab3.Updates, FormTab4.Updates, FormTab5.Updates, FormTab6.Updates);
Notify("Data Updated successfully", NotificationType.Success);
Navigate(LandingPage, ScreenTransition.CoverRight);

 

Please tell why the attachment wont save to my SP List? i need to get the attachment work ASAP.

 

Thanks.

 

Regards,

pytbyt

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,187)