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 / Repeating table removi...
Power Apps
Answered

Repeating table removing previous records information

(0) ShareShare
ReportReport
Posted on by 1,176

Hi,

I have a repeating table but I'm missing something as when I create a new record some of my previous records data disappears.

 

For my navigation button the the screen i have

 

ClarkyPA365_0-1649947039531.png

 

 

Add a name in

 

ClarkyPA365_1-1649947039532.png

 

 

Select Add New Person icon

ClarkyPA365_2-1649947039534.png

 

 

+ formula 

ClarkyPA365_3-1649947039538.png

 

 

What I'm I missing??

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    156,277 Most Valuable Professional on at

    Hi @ClarkyPA365 ,

    I am a bit confused here - you are initially creating a new blank new collection, but then patching to the collection and then immediately clearing it. You do not need the last step if you want to subsequently add more items to it - or have I misread your post?

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Chris1968 Profile Picture
    1,176 on at

    Hi @WarrenBelz 

    The ClearCollect is attached to my button on the Home screen

    ClarkyPA365_0-1650010141402.png

    The Patch and collect formula is related to the Add New Person icon on another screen.

    Hope that helps?

    Regards

    Chris

     

  • WarrenBelz Profile Picture
    156,277 Most Valuable Professional on at

    Hi @ClarkyPA365 ,

    OK I see it now (I did misread it - brain was not fully engaged) , but asked the wrong question - how are you then saving the collection to your data source and what is it that goes missing?

  • Chris1968 Profile Picture
    1,176 on at

    Hi,

    I'm saving it as a collection ExemptionItems but when I select the Add New Person the name previously selected, 1st record, no longer shows in the Combobox even though information has been saved. even though is the wrong information needed.

    ClarkyPA365_0-1650013208183.png
    Also in my collection the data being stored for Staff Name is displaying as the Email and not name

    ClarkyPA365_1-1650013625260.png

     

     

     

  • WarrenBelz Profile Picture
    156,277 Most Valuable Professional on at

    @ClarkyPA365 ,

    What are the Items of the gallery and the Text(Labels) or Default  (or DefaultSelectedItems for Combo Boxes) of the controls you are writing to?

  • Chris1968 Profile Picture
    1,176 on at

    Hi Warren,

    The Items I'm writing to is a collection

    ClarkyPA365_0-1650194410578.png

    And nothing for the ComboBox, DefaultSelectedItems

    ClarkyPA365_2-1650194576921.png
    The txtbox as two ""

    ClarkyPA365_4-1650194726200.png

    I have nothing in Default for either Gallery or Combobox

    ClarkyPA365_1-1650194492421.png


    ClarkyPA365_3-1650194644571.png

     

     

     

  • WarrenBelz Profile Picture
    156,277 Most Valuable Professional on at

    @ClarkyPA365 ,

    I was really after the field names and types you are reading from/writing to and you did not give me the Items of the Combo Boxes, but I can work most of this out from your original post.
    The reason that your data is "disappearing" is that you need to set the DefaultSelectedItems (Combo Box), DefaultDate (DatePicker) or Default(Text Boxes and a few other controls) to show the data in the field you have just saved. I will post below all the possible fields you are writing to

    DefaultSelectedItems
    of your Combo Boxes

    ComboStaffName - I am guessing the output as you have not given me the Items

    {'Staff Name':ThisItem.'Staff Name'}

    DrpExempReason

    {Value:ThisItem.'Exemption Reason'}

    DefaultDate of your Date Picker DateExemp

    ThisItem.'Date Exemption'

    Default of Text Box txtOtherReason

    ThisItem.'Other Reason’

    Please also remember in future to post in Text also and watch spelling above as I had to OCR it.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Chris1968 Profile Picture
    1,176 on at

    Hi Warren,

    I've managed to get the 'staff name' to display the actual name and not the Email address in the Collection (ExemptionItems)

    ClarkyPA365_0-1650358109196.png

    Replaced PrincipalUserName with DisplayName  ('Staff Name': ComboStaffName.Selected.DisplayName 


    Still not seeing the names in the fields after adding a new person??

    ClarkyPA365_1-1650358374379.png

     

    The Items (ComboStaffName)

    ClarkyPA365_2-1650358490009.png

     

  • WarrenBelz Profile Picture
    156,277 Most Valuable Professional on at

    @ClarkyPA365 ,

    This is the first you have mentioned a Person field (I simply do not use them). I suspect the Items will involve DisplayName, so your DefaultSelectedItems will also refer to that.

  • Chris1968 Profile Picture
    1,176 on at

    Hi,

    Sorry thought I had,  Sorry if I'm confusing the matter

    The scenario is that the supervisor can select a number of people who may have an exemption to having a meeting but the exemption reason can be a different.  So instead of adding them one by one the group exemption table is used.

    When I try and use 'DisplayName' the option does not appear after ThisItem??
    I've tried this formula {'Display Name':ThisItem.IsSelected} and get no error??  But still the name disappears when selecting Add New Person icon

    What would you use for this scenario?? 

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 396 Most Valuable Professional

#2
11manish Profile Picture

11manish 134 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 101 Super User 2026 Season 2

Last 30 days Overall leaderboard