Power Platform Community Forum Thread Details

Hi,

i have the weirdest experience with my app.

i have an excel data source, which the user can update form the app, to add a comment.

when I'm doing the patch the data is not reflected in the gallery although I'm recollecting it right after the patch, but wait this is still not the wired part (or weirdest) .

the excel is updated correctly in timely manner so after I'm refreshing the dataset and run the on start i can see the items but with a -2 items offset i.e. if i updated item #6 i will see it on #4!!!

when checking in the collection view, i can see it is actually collected on the wrong number, seems like there are 2 missing items.

this is my formula from the on select:

Patch(
 Table17,
 LookUp(Table17,IncidentIdentifaier=varThisItem.IncidentIdentifaier),
 {
 Comment:TextInput3.Text
 }
);
ClearCollect(IncidentsDB,SortByColumns(Table17,"CreatedOn",SortOrder.Ascending));

i use the am clear collect formula on the app on start

some screenshots:

in the dataset it looks like this: