cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
Super User
Super User

Edit Form saving an empty value

Good morning.

I have this issue and I hope someone could give me an advice.

I have my gallery connected with my share Point List. I have a button "Editform" and I can edit my fields in the form. Another button saves the data typed back to my list "Submitform"

 

I have several Text Input fields but for instance if I type in one of the fields "2000", save. then I need to delete that value and leave the field empty nothing happens. Can't get the field be empty again only change for another value.

 

any help please?

 

Thank you kindly

 

1 ACCEPTED SOLUTION

Accepted Solutions

@sajarac 

 

Under Settings/Advanced settings; enable "Formula-level error management" and try again.

View solution in original post

9 REPLIES 9
mdevaney
Super User
Super User

@sajarac 
I don't understand what you want to do here.  Can you please try to explain again?  Screenshots also help.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Sorry for the confusion.

In my edit form I have a text input.

If I save a value for the first time it is saved in my SPL. but if I don't want to have a value in that field I edit the form clear the value and save the current value saved in my SPL comes back.

 

My current value in the SPL:

Capture1.PNG

 

Form in edit mode, deleting the value and saving:

Capture2.PNG

 

After save the value retuns

Capture1.PNG

One more thing to consider. Just notice but not sure if this is right or not. The fields that I can not clear the content and save back are number fields. I just did a test with a text field put some data save, edit, clear the content save again and the content is gone. Is weird no?

@sajarac 
Try this:

 

Put this code in the Update property of the Card holding the text input

If(TextInput_Quantity.Text=Blank(), Blank(), Value(TextInput1_Quantity.Text))

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

Nothing.

😞

 

Capture3.PNG

@sajarac 

What’s in the Default property of the Card?

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Default = ThisItem.Quantity

@sajarac 

 

Under Settings/Advanced settings; enable "Formula-level error management" and try again.

This worked for me, but I am confused as to why I had to explicitly turn it on. Does this mean that any apps where users will need to clear numeric values it must be turned on?

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,585)