Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

unable to save the empty records for text field

(0) ShareShare
ReportReport
Posted on by 19

Hi, 

 

In my power app edit screen, for textinput field unable to save the empty records.

 

When adding a new record, if the text field is blank, the data is saved in share point list without any issues.

 

We can update the date time data in the text field and we can edit the data also without any issues.

The real problem is I saved an item to the SharePoint list and later decided to remove data from some fields (Date field etc).  Edit the item and delete the field value and Save it back to the data source (SharePoint list)

 

Issue:  PowerApps does not update the field to empty / null value. The field value remains as such in the list.

 

I am using the default value for the text field as Coalesce(Parent.Default, Blank()) and using submit form button to store the data.

 

Could you please help?

 

  • BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: unable to save the empty records for text field

    Hi @Nikilp ,

     

    The type and formatting of your values shouldn't be relevant for this to work or not. Have you tried restarting the Power Apps studio? 

     

    If all of this fails, you may have to submit a ticket with MS because this is supposed to work. 

  • Nikilp Profile Picture
    Nikilp 19 on at
    Re: unable to save the empty records for text field

    Dear @Drrickryp  & @BCBuizer ,

     

    Good day!

     

    Thanks for your replay,

     

    I have turned on the Formula-Level Error Management option and changed the Default to Parent.Default.

     

    But I Still facing the same issue, now, I am unable to save the empty record also.

    For this text field, I am using the date-time format in the SharePoint list.

     

     

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: unable to save the empty records for text field

      What he said.

  • BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: unable to save the empty records for text field

    Hi @Nikilp ,

     

    Try turning on Formula-Level Error Management in the settings:

     

    BCBuizer_0-1675889946054.png

     

    Ps. You can just leave the Default at Parent.Default. The Coalesce function will return the first non blank value, so the second argument (Blank()) will never be returned.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard