web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / New Form opens first o...
Power Apps
Unanswered

New Form opens first on edit

(0) ShareShare
ReportReport
Posted on by 26

Hi Sorry if this has been asked before but I couldn't find it.

 

We have separate forms for new, edit and view.

When editing a record the New form opens then pauses then opens to Edit form.

The forms are quite large and the pause can be 30s on a busy day.

Ideally we would like the edit form to open first and load.

Another option I'm thinking of is a welcome screen with a loading message.

 

Thanks in advance..

 

Categories:
  • WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    Hi @jimitodd ,

    I assume you are talking about the SharePoint Integration PowerApps for,

    Can you please send the code in the SharePointIntegration area for OnView, OnEdit and OnNew as well as the DefaultMode of the SharePointForm1.

     

  • jimitodd Profile Picture
    26 on at

    No problem.

    The forms are for new employee and updated employee details submitted from departments.

    We have 5 forms for different types of contracts.

    The initial "action screen" has a dropdown menu which loads the selected new input form.

    When you choose to edit a form the "action screen" opens, waits then the edit form loads.

     

    The edit form has extra fields for HR and Payroll to input progress information some of these fields are on separate lists.

     

    Hope this info makes sense and helps.

     

    Default mode is new

     

    New.

    Set(SharePointFormMode, "CreateForm"); NewForm(Newform1); Navigate(ActionTypeScreen, ScreenTransition.Fade)

     

    Edit.

    Refresh(Connect);   // Add this formula
    Set(SharePointFormMode, "EditForm");
    If(SharePointIntegration.Selected.'Action Type'.Value = "05) Leaver",
       EditForm(EditLeaversFormv2);Navigate(EditLeaversScreenv2,ScreenTransition.Fade),SharePointIntegration.Selected.'Action Type'.Value = "01) Change of Position - Teaching",
       EditForm(EditCOP_TeachingForm_1);Navigate(EditCOP_TeachingScreen_1,ScreenTransition.Fade),
    SharePointIntegration.Selected.'Action Type'.Value = "02) Change of Position - Non Teaching",
       ViewForm(EditCOP_NonTeachingForm_1);Navigate(EditCOP_NonTeachingScreen_1,ScreenTransition.Fade))

     

     

    View.

    Set(SharePointFormMode, "ViewForm"); If(SharePointIntegration.Selected.'Action Type'.Value = "05) Leaver",
       ViewForm(ViewLeaversFormv2);Navigate(ViewLeaversScreenv2,ScreenTransition.Fade),
    SharePointIntegration.Selected.'Action Type'.Value = "01) Change of Position - Teaching",
       ViewForm(ViewCOP_TeachingFormOLD);Navigate(ViewCOP_TeachingScreenOLD,ScreenTransition.Fade))

  • eka24 Profile Picture
    20,925 on at
    If you want to open the form as edit on default: Select the form, then on the Defaultmode property change it to DisplayMode.Edit


    If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution
  • WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    Hi @jimitodd ,

    OK - I see the issue here - you have created a multi-screen form in the SharePoint Integration facility.

    I can only relate to my experience on this, however I have found that once you go past one screen, the default behaviours of the in-built controls don't seem to "play nicely".

    What I do (which seems to work) is have all the New/Edit/View controls on the forms themselves and tell users to ignore the inbuilt items. You can exit the whole facility with  RequestHide().

    I found this also easy as almost all of my forms are standalone apps forms copied and pasted into the SP Integration and already have all this functionality.

    It is great to see you have this almost working. I have tagged @v-xida-msft of the Microsoft team to see if they can add any wisdom to this.

     

     

     

  • jimitodd Profile Picture
    26 on at

    We are going to go with a loading screen for now as it works beter for us.

     

    Navigate(WelcomeScreen, ScreenTransition.Cover); at the beginning of New, Edit and View.

    Then prior to request hide on submit so it loads the last screen you were on.

     

    Unless @v-xida-msft has any better ideas

  • WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    Ok @jimitodd ,

    That should certainly work as designed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard