Open List item directly into Edit form/mode

[Anonymous]

When items are opened from my SharePoint list, I'd like the form to open directly into edit mode. Previously they were opening to the View Form, but now after some changes the Edit Form is the one that opens, but I am still required to click "Edit All" at top of the page before making changes. If I don't click the Edit All, I can't change any items. I'd like to be able to make changes directly after clicking the list item. Below is the current forumla I have in the SharePoint Integration "On Edit" and "On View" screens.

Set(SharepointFormMode,"EditForm")&EditForm(SharePointForm_Edit)&Navigate(FormScreen1_1,ScreenTransition.Fade)

Also, the DefaultMode is Edit. 

[RandyHayes · Accepted solution]

@Anonymous 

Please consider changing your Formula to the following:

Set(SharepointFormMode,"EditForm");
EditForm(SharePointForm_Edit);
Navigate(FormScreen1_1,ScreenTransition.Fade)

You are using the & which concatenates strings.  If you want multi line commands, separate with the semicolon.

I hope this is helpful for you.

[Anonymous]

That worked! Thank you.

[NM4]

Are there other settings that can affect this? I have the same formula in OnEdit and OnView under SharePointIntegration, with: 

Set(SharePointFormMode,"EditForm"); EditForm('My Form Name'); Navigate('My Screen Name',ScreenTransition.None)

but when I open a list item from SharePoint it still always opens with the "Edit All" button at the top. It's a real problem because my users can edit the fields, and if they don't then click "Edit All" and then "Save", they lose all their information. 

[stevegeall]

Had the same problem, ended up formatting a column to display like a button that used a customRowAction of "editProps" which opens the form in edit mode in SharePoint.

{

"_comment": "A button to open the edit form",

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "button",

"customRowAction": {

"action": "editProps"

 },

"attributes": {

"class": "ms-fontColor-white ms-fontColor-black--hover"

 },

"style": {

"border": "none",

"cursor": "pointer",

"background-color": "transparent"

 },

"children": [

 {

"elmType": "div",

"attributes": {

"class": "ms-bgColor-gray120 ms-bgColor-gray40--hover ms-fontColor-white ms-fontColor-black--hover"

 },

"style": {

"font-size": "12px",

"font-family": "arial",

"border-radius": "12px",

"padding": "5px 8px 5px 8px"

 },

"children": [

 {

"elmType": "div",

"attributes": {

"iconName": "NavigateBackMirrored"

 },

"style": {

"display": "=if('NavigateBackMirrored' != '','inline-block','none')",

"vertical-align": "middle",

"padding-right": "5px"

 }

 },

 {

"elmType": "div",

"txtContent": "=if('' != '',' EDIT',' EDIT')",

"style": {

"display": "inline-block",

"font-family": "arial",

"vertical-align": "middle"

 }

 }

 ]

 }

 ]

}

I also set this in a board view, so selecting the item on the board opened it in edit mode:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/board-formatting.schema.json",
"hideSelection": true,
"formatter": {
"elmType": "div",
"customRowAction": {
"action": "editProps"
},
"attributes": {
"class": "sp-card-container sp-card-container-noPadding"
},
"children": [


...

...

[Sn3l]

Hi Stevegeall. 

This work great if you work directly in the list. 

What If you add the list as a webpart to a page and want to edit from there.   (With the menu disabled)

If I double click it opens in a new window in view mode.  

Any thoughts on initiating an edit from there (even if it does open in a new window)