New SharePoint form integration problem

[sergeluca]

Hello,

I have the following SharePoint List :

Only the fields City, Amount and Category can be edited. Status can only be seen.

To do so I've created 2 forms : 1 form with the 3 fields (the form name is "SharePointForm_Add_Edit") and 1 form with the 4 fields (the form name is SharePointForm_View as described below :

The SharePointIntegration component has been defined like this :

My Problem is when I edit my items in SharePoint (add, new) I get the correct form, but when I view the item I  also Get the SharePointForm_Add_edit instead of the SharePointForm_View.

Any idea ?

[v-micsh-msft · Accepted solution]

Hi @sergeluca,

I think the issue should be the landing screen is always the first screen (in your case, it should be the FormScreenAdd ).

If you would like to view the second screen, you should first navigate to that screen.

Have you checked the following article for how the OnView of the SharePointIntegration control works?

SharePoint custom forms: Build separate forms to create, show or edit the list item

Please follow the instructions under Step 4, to configure the screen navigation.

Specially for the OnView, the formula should be in the format below:

OnView - Set(SharePointFormMode, "ShowForm"); ViewForm(ShowItemForm); Navigate(ShowScreen, ScreenTransition.None)

Regards,

Michael

[sergeluca]

Thank you for this !

I didn't see this nice blog post.

Cheers

Serge Luca

[SonjaK]

Hi,

I have rebuild this mentioned example but get error warnings by inserting the formulas for OnNew/OnEdit/,...

Set(SharePointFormMode; "CreateForm"); NewForm(CreateItemForm); Navigate(CreateScreen, ScreenTransition.None)

1st: issue by putting the first comma right before "CreateForm" >> expected "ParenClose,.... more I cannot read because the Set Formula explaination is overlaying the info   ----    I have changed this to a comma and red underline disappears

(I am working with a "german" powerapps webbrowser version - we detect this sometimes, that such things needs to be changed :-()

2nd: the "CreateForm" is red - no comment - but if I try to enter the text I am not getting the function/field in the proposal list as I do get if for example for CreateItemForm....

3rd: the ; after "CreateForm") is red underlined and I receive a "unexpected token" infor - changing to comma does not help in this case...

Same issues for all the other formulas like OnEdit, OnView,...

Thanks and regards,

Sonja

[SonjaK]

Hi, I have solved the issue with the formula be changing the unexpected token to "||"

regards

Sonja

[Anonymous]

Hi Sonja,

I followed your instructions and get ride of the warnings but still not able to load the customized New form. i always get the ShowScreen Form.

[JoanaVB]

Hi Sonja, I had to use ;; in Portugal instead of "||" between each command and also ; instead of ,.

[Anonymous]

make sure that you:  Change the double quotation marks to the ASCII equivalent in NOTEPAD   -- I had this issue because I copied the documentation to MS Word and then copied the formula to the SharePoint Integration tool. The double quotation in word (") are a different ASCII character than the double quotation in notepad.  As an old timer programmer, this was a common mistake and was corrected by simply putting the code in notepad, changing the quotation marks, and then by copying that code back to the development tool (in this case the "SharePoint Integration" tool.