I have a project request form for one of the engineering groups I work with. It's a customized SharePoint form, very simple - one screen, one Edit Form input. And the stupid thing won't work and I can't figure out why.
The only unique feature of this form, and why it was customized instead of using JSON to format in SharePoint, is a small number of fields that are set to only be viewable by the four admins for the program, and at the bottom of the screen is a space where the information the admins can edit is viewable (but not editable) by anyone looking at the project.
Issue 1: This is the low hanging fruit one - if I can fix it, great, if not they get plain text fields instead of rich text.
When setting a Field control type to "Edit Rich Text" the form will work for the initial entry. If you go into edit it's fine. But if you go into edit a second time without refreshing your screen the editable rich text fields disappear, although the options for rich text editing still appear.
The only thing I have found that is different than what I googled to try and resolve this is under the Form Item field it auto populated with this:
If(IsBlank(SharePointIntegration.Selected) || false,
First('TST REQUEST SERVICES'),
SharePointIntegration.Selected )
Instead of:
If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected), First('*YourListName*'), SharePointIntegration.Selected )
But I checked a few other customized forms I've done and they all have the first iteration, not the one that Microsoft recommends for Sharepoint Integration. I did try to change it and got a red squiggle at IsEmpty(SharePointIntegration.Selected under .Selected so I changed it back to what SharePoint set me up with to begin with.
Issue 2: This is the "Big Deal" problem
When entering information into a multi-line field the form will work for the initial entry. If you go into edit it's fine - shows up, doesn't disappear when you save. But if you go into edit a second time to edit something everything that has been inputted during prior edits is gone from the multi-line text fields. This does not happen with any other type of field - choice, number, single line of text, date or people pickers. Only multi-line text fields.
The columns where multi-line text is needed are all set to "Append changes to existing text" . As mentioned for Issue 1, neither OnSave or OnEdit have been adjusted in any way from what exists automatically with a SharePoint integration.
The SharePoint list will still indicate there is information in the columns, but nothing shows up when the item is opened using "edit".
Please help. The Engineers are getting cranky.