Answered

Open List item directly into Edit form/mode

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

That worked! Thank you.

Was this reply helpful? Yes No
NM4 6 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU22072135-7 on at

Like (1)

Report
Copy link

Link copied!
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": [

...

...

Was this reply helpful? Yes No
Sn3l on at

Like (1)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Mo78 249 on at

Like (0)

Report
Copy link

Link copied!

This answer helped me with multiple projects. Thanks a lot

Was this reply helpful? Yes No