Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - GCC, GCCH, DoD - Federal App Maker...
Answered

Customized SharePoint Form - Edit Error: Form is saving over data with a blank

(0) ShareShare
ReportReport
Posted on by 10

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.

  • C_Salm Profile Picture
    10 on at
    Re: Customized SharePoint Form - Edit Error: Form is saving over data with a blank

    it was the append changes - once I turned it off everything worked fine. Thank you.

  • Verified answer
    jwillisrosemsft Profile Picture
    Microsoft Employee on at
    Re: Customized SharePoint Form - Edit Error: Form is saving over data with a blank

    Q: If you look at the data in SharePoint, is the data stored from the initial save?  If so, try filing out the field again and save your changes.  Do you see both the original and new text in the multi-line field?  If so, the problem is "Append changes to existing text".  You can either turn that off, or consider adding a read only control with the multi-line text field above or below the editable control. 

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics