cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Resolver II
Resolver II

SharePoint Integration OnSave Formula

Hi,

 

Can someone help me? I have a customize form in SharePoint List using Power Apps. I three forms which are FormScreen_New, FormScreen_Edit and FormScreen_Display. Now I need to change the OnSave formula which currently set to the default SubmitForm(SharePointForm1). I encountered error using Save button in SharePoint list when the form is in FormScreen_Edit. 

 

jaina_0-1636428194219.png

 

 

How do I set the OnSave action which can capture both FormScreen_New & FormScreen_Edit conditionally?

 

jaina_1-1636428340395.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @jaina ,

First, conditional formulas in SharePoint Integrated controls, particularly on Multi-screen apps have a habit of not returning the expected result, particularly when you try to base the formula on Variables. They were simply not designed with this in mind. Also why are you using separate screens - the three functions can be done with one.

I generally treat anything multi-screen as a canvas app and provide the users buttons for (in particular) save and simply disable OnSave by making it false.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

View solution in original post

2 REPLIES 2
WarrenBelz
Super User
Super User

Hi @jaina ,

First, conditional formulas in SharePoint Integrated controls, particularly on Multi-screen apps have a habit of not returning the expected result, particularly when you try to base the formula on Variables. They were simply not designed with this in mind. Also why are you using separate screens - the three functions can be done with one.

I generally treat anything multi-screen as a canvas app and provide the users buttons for (in particular) save and simply disable OnSave by making it false.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

View solution in original post

jaina
Resolver II
Resolver II

I have different screens since there are conditional formulas when it comes to required and visible function per screen.. I already has submit buttons per screen. It just that the user has confusion since there is already a buttons presented in sharepoint such as save and cancel button... 

 

 

but anyway, thanks for suggesting to make OnSave false value.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,006)