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 / Fields going blank in ...
Power Apps
Answered

Fields going blank in the form after saving them to Sharepoint list

(0) ShareShare
ReportReport
Posted on by 860

So i have two fields that are having this behaviour: 

1- A text Sharepoint field that I have it to "Update" from a selection of a ComboBox in PowerApps. The items that this comboBox uses are the items in an Excel column. Everything shows up nicely and it does save it into the Sharepoint list. However when I go to open this item is goes back to blank. If I save again to a diferent item it does save to Sharepoint the Update part of the code is fine. 

I had a similar problem for another field so I tried using the same solution that worked that time. Changing the DefaultSelectedItems of the comboBox:

 

{'Name of Sharepoint Column': Parent.Default}

 

The Default of that DataCard is: 

 

ThisItem.'Name Of Sharepoint Column'

 

2- Same issue. My sharepoint column is also of type text and the Update property is set to the Text of a Text label. This is a dynamic label that changes depending on what was selected on another ComboBox. That other ComboBox has its Items drawn as well from an Excel Table that has two columns: Client name and Country Code. So, in the other comboBox you select the Client and this text changes automatically to whatever Country Code that corresponds with that Client Name. 
I got that to work with Coalesce and UpdateContext. The problem isn't here, as it does what's needed and Updates accordingly. 

The Text Label has in its Text property the following:

 

ComboBox3.Selected.'Country Code'

 

The DataCard has: 

 

Label15.Text

 

Again, if i changing the ComboBox3, the text changes. So don't think the problem is there. The problem is with PowerApps remembering that text.

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @WorkingRicardo ,

     

    For the Combo box, please try below in DefaultSelectedItems:

    {'Name Of Excel Column': Parent.Default}

     

    For the Label, you need to get the default value based on the list item than the other combo box selected Client Name because I think Client Name is blank when you open the form:

    Coalesce(ComboBox3.Selected.'Country Code', Parent.Default)

     

    Best regards,

  • WorkingRicardo Profile Picture
    860 on at

    hey @v-jefferni ty for your continued support and fast reply 😄

    The Label was fixed! Yay. But I had that same code you sugested on the ComboBox for its DefaultSelectedItems property, but nope. Still only updates the Sharepoint list, but when you go back to edit it, goes back to blank

    WorkingRicardo_0-1704958516919.png

    The strange thing is that editing in PowerApps it does recognise whatever is selected for that particular item, because false is what is written on Sharepoint right now for that item.

    What other code I could try?

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @WorkingRicardo ,

     

    I don't understand. Why using a Boolean column as Items of the Combo box? There are only true or false values. 

     

    Best regards,

  • WorkingRicardo Profile Picture
    860 on at

    @v-jefferni Oh no no! It's not false as in boolean for true or false. It's what was written as one of the options for the Excel table. Sorry for the confusion. What i wanted to show with the image is that in PowerApps by that code, it does recognise what it was written at that time in the DataCard.

  • WorkingRicardo Profile Picture
    860 on at

    I changed some other things in PowerApps and Excel file and magically fixed itself 😄 so I'll mark it as solved. Thanks!

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @WorkingRicardo ,

     

    Parent.Default = false, and these codes in formula bar was just telling you that it's a record with column name and column value = false. If this record cannot be found in Items of Combo box, it will not display.

     

    So, what's exactly in Items of Combo box? 

     

    Best regards,

  • WorkingRicardo Profile Picture
    860 on at

    hey @v-jefferni In comboBox i have just the name of the Excel table. Now everything is working, thanks 😄

    Well, I do have another issue with the search function of this combobox. I posted it on Re: Error in the search function of a Combobox - Power Platform Community (microsoft.com)
    Would love your input on that!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard