web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Deleting values in Edi...
Power Apps
Unanswered

Deleting values in Edit Form not working

(0) ShareShare
ReportReport
Posted on by 519

Hello,

My form has multiple screens (tabs). When a form is submitted it is assigned to someone.  When the form is assigned and the  assignee updates the form, it updates the values in the SharePoint list as well.  The edit form has fields which show or hide based on values in a dropdown.  I noticed that if an assignee fills out a field and submits, then for some reason reopens the form because the selection they made was incorrect, if they delete the current info. in the text field and choose another value from the dropdown and other respective text fields show and they fill those out, and return to the previous dropdown value, the text they deleted still shows, although I have setup an OnChange "Reset" formula for that field.  Can anyone advise how to rectify this.  I am also seeing this behavior with other fields on the edit form.  Thanks.

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @joshieboy 

    You don't need the OnChange Reset bit...

    Go to your Advanced Settings in your app and turn on Formula-Level Error Management.

     

    I hope this is helpful for you.

  • joshieboy Profile Picture
    519 on at

    Thanks @RandyHayes for the prompt feedback.  I tried this but still the same behavior.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @joshieboy 

    Can you provide a screenshot or more with some visual on what is happening?

  • joshieboy Profile Picture
    519 on at

    Sure @RandyHayes - In the First Aid Screen shot, when a user selects First Aid from the Incident type-Sub Category field, the "please provide additional details" field is displayed.  Note: There are several options under Sub Category which link to this same "Please provide additional details field", however, as mentioned before, I included an OnChange reset function which should reset this field if the sub category changes.  A saved form was reopened and the sample text in the screenshot "This is a First Aid incident" was deleted and another value selected from the dropdown which shows different fields like "Please include approximate value."  When I update those fields which are shown, and go back to the "First Aid" in the dropdown, the deleted text still remains, so its saving that text back to SharePoint again, although I did not want it to.

    FirstAid.jpg
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @joshieboy 

    Okay...putting the pieces together a bit more...

     

    So how are you saving the data in the form?  I assume a SubmitForm ??

     

     

  • joshieboy Profile Picture
    519 on at

    @RandyHayes  - yes that's correct.  A Submit form

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @joshieboy 

    Very good, then let's get some formulas:

    - What is the Item property of the Form?

    - What is the OnSelect formula where you SubmitForm?

    - What other formulas have you put in this form to perhaps change visibility or any thing else?

  • joshieboy Profile Picture
    519 on at

    Sure.

    @RandyHayes - the info requested:

    Item property:  LookUp('Initial Incident Notification',ID=EditFormID) -where Initial Incident Notification is the SharePoint list 

    OnSelect formula:  SubmitForm([@EditForm1])And Navigate(UpdateIIN_ThankYouScreen,ScreenTransition.Fade)

     

    Other formulas are:  Specific fields show/hide based on selection from the dropdown.  eg:  currentTab="UpdateIncident" And (If(IsBlank(IncidentType_SubCategory.Selected.'Sub Category'),ThisItem.'Incident type - Sub Category'.Value,IncidentType_SubCategory.Selected.'Sub Category') in ["Equipment Failure","Process upset","Safety Critical Equipment and Systems","Indoor air quality","First Aid","Communicable disease","Ergonomic","Heat Illness","Lost Time Injury - Hospital Stay > 5 days","Lost Time Injury - Hospital Stay 1-5 days","Vehicular","Medical Treatment","Personal Non-Occupational","Personal Occupational","Procedural deviation","Process Incident","Tier 1","Tier 2","Breach in Procedure","Restricted Work Case","Vehicular (Non-Preventable)","Vehicular (Preventable)","Personal Safety","Non-Occupational Personal Safety Incidents (Near misses or accidents)","Fatality","Cyber attacks","Threat","Unauthorised Intrusion","Tier 3","Tier 4","Activated","Failure In Service","Failure on Demand","Failure on Demand (testing)"])

     

    Whereby if the sub category dropdown is any of the values above, then show the "Please provide additional details field."

     

    Also, on the Sub Category OnChange property there is:  Reset(CMMS_SAPWorkOrder);Reset(ProvideAdditionalDetails);Reset(DescribeProperty_MaterialDamaged);Reset(IncludeApproxValue);Reset(IncludeChemicalDesc);Reset(SizeOfSpill);

    To clear the original values from the field if the user changes their mind and chooses another sub category.

     

    That's it for the most part.

  • jojos_iq Profile Picture
    90 on at

    Hey, did you manage to solve this at all? I am having the same issues that you are 😞

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard