Reset lines Collection

[Eliot_DECRION]

Hi

I have a problem. I have a button with this in the Onselect function

Remove([@Table_Data_Planif_Outillages]; ThisItem);; 
ClearCollect(colDeletePart;ThisItem)

 So when I select it, it delete my part of my first table and it send it in the collection. 

The problem is when i restart my app the lines of my collection are remove and I don't know why

Can someone help me please ? 

[v-qiaqi-msft]

Hi @Eliot_DECRION,

Your logic has something wrong, once you remove this item, it is deleted, so it could not be collected.

[Eliot_DECRION]

Hi @v-qiaqi-msft 

No I delete it from Table_Data_Planif_Outillage but I collect it in my collection : colDeletePart

What's wrong I don't understand

[v-qiaqi-msft]

HI @Eliot_DECRION,

You refer to ThisItem, remember?

ThisItem represents a record in your Table_Data_Planif_Outillage, unless Table_Data_Planif_Outillage  is not the data source you populate the Gallery with, other wise, you have deleted this item from your data source, so that you could not collect this deleted item into a collection.

[Ethan_R]

Hi @Eliot_DECRION ,

Let's clear your confusion,

1. You should store data in collection before doing the delete operation, since deleting from source will refresh and you might not get that record. So, use ClearCollect before Remove

2. When you restart your App, none of the values/variables/collection will store your previous session's data. So, you cannot get your content back once you exit the App or refresh it.

Therefore, commit changes and then proceed to close/restart App.

Hope this helps

[Eliot_DECRION]

Hi @Ethan_R 

So if I have 3 lines in my collection and I exit the app, when I log in, there will be nothing?

[Ethan_R]

Yes @Eliot_DECRION , that's correct.

Unless you save the collection item to any data source, collection is temporary data holder in the App.

You get data in collection and you perform operation then save the data back to server or data source. Later you can close/exit the App.

When you load the App again, you need to get data from the Source into your collection.

Hope this helps

[Eliot_DECRION]

ok thank you

How can I link my collection to a excel table ?

[Ethan_R · Accepted solution]

Hi @Eliot_DECRION ,

You need to fetch the records from your Excel data-source and then create a Collection based on that data-source.

Excel can be stored on OneDrive or SP and then you can add the Excel source in the App (under Data-Source from left while Editing App)

Later, you can load data into collection as

ClearCollect(
   colExcelData,
   'Excel Table'
);

Hope this sample syntax helps