Repeating table removing previous records information

[ClarkyPA365]

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

Add a name in

Select Add New Person icon

+ formula 

What I'm I missing??

[WarrenBelz]

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

[ClarkyPA365]

Hi @WarrenBelz 

The ClearCollect is attached to my button on the Home screen

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

Hope that helps?

Regards

Chris

[WarrenBelz]

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?

[ClarkyPA365]

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.

Also in my collection the data being stored for Staff Name is displaying as the Email and not name

[WarrenBelz]

@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?

[ClarkyPA365]

Hi Warren,

The Items I'm writing to is a collection

And nothing for the ComboBox, DefaultSelectedItems

The txtbox as two ""

I have nothing in Default for either Gallery or Combobox

[WarrenBelz]

@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

[ClarkyPA365]

Hi Warren,

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

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

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

The Items (ComboStaffName)

[WarrenBelz]

@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.