Previous entries disappear after adding a new one.

Like (0) Share

Report

Posted on 18 May 2024 13:25:45 by xvzms

Hi,
I've a gallery grid connected to SP list.

When I try to add a new row, my previous row disappeared.

Could you please help me, what the problem is?

OnSelect property on Add button:

ForAll(
 Sequence(NumberInput1.Value),
 Patch(
 TableList,
 Defaults(TableList),
 {
 Column1: "",
 Column2: "",
 Column3: "",
 GUID_Form: DataCardValue5.Text
 }
 )
);
Set(varReset, false);
Set(varReset, true);

Categories:

Connecting to Data

General Questions

All responses (2)

Answers (0)

Sohan 151 on 18 May 2024 at 16:36:04

Like (0)

Report

Re: Previous entries disappear after adding a new one.

Hello @xvzms,
You may create a collection for that, like you have created a collection in the app on start, and then you may patch the value in this collection, and this collection will be used as a data source. I hope this will help you. Please accept as a solution if it's helpful to you. Thanks!
App's on start collection:
ClearCollect(
colSheetData,
{ID: 1}
);

Screen's on visible property collection:
If('galTimeSheetNewEntry'.AllItemsCount = 0 , Patch(
colSheetData,
Defaults(colSheetData),
{
ID: If('galTimeSheetNewEntry'.AllItemsCount = 0 , 1, Last(colSheetData).ID + 1)

}
));

+ or Add line button collection code:
Patch(
colSheetData,
Defaults(colSheetData),
{
ID: If(
'galTimeSheetNewEntry'.AllItemsCount = 0,
1,
Last(colSheetData).ID + 1
)
}
);

Delete or remove line collection:

Remove(//If delete icon was selected
colSheetData,
LookUp(
colSheetData,
ID = galTimeSheetNewEntry.Selected.ID
)
);
Sohan 151 on 18 May 2024 at 14:37:38

Like (0)

Report

Re: Previous entries disappear after adding a new one.

Hello, @xvzms You may create a collection for that, like you have created a collection in the app on start, and then you may patch the value in this collection, and this collection will be used as a data source. I hope this will help you. Please accept it as a solution if it's helpful to you. Thanks!

App On start's Collection:
ClearCollect(
colSheetData,
{ID: 1}
);

Screen's on visible property:
If('galTimeSheetNewEntry'.AllItemsCount = 0 , Patch(
colSheetData,
Defaults(colSheetData),
{
ID: If('galTimeSheetNewEntry'.AllItemsCount = 0 , 1, Last(colSheetData).ID + 1)

}
))

+ Add button code:
Patch(
colSheetData,
Defaults(colSheetData),
{
ID: If(
'galTimeSheetNewEntry'.AllItemsCount = 0,
1,
Last(colSheetData).ID + 1
)
}
);

Remove line code:
Remove(//If delete icon was selected
colSheetData,
LookUp(
colSheetData,
ID = galTimeSheetNewEntry.Selected.ID
)
);