Power Platform Community Forum Thread Details

Hi,

I'm building an app for our service engineers and I'm struggeling with collecting data to a table.

In an initial screen they can fill out a timesheet:

All this is temporally saved in a collection (collDocumentation) and after submitting it is added to a table (tblOperationalDocumention):

ClearCollect(collDocumentation; tblOperationalDocumentation);;
....
data is saved in the collection each time a row is added in the timesheet
....

Submit button:

Collect(tblOperationalDocumentation; Filter(collDocumentation;ID <> 9999));;

This works fine so far. Afterwards the timesheet is checked and approved or rejected. In case it is rejected, the respective dataset is loaded into the collection again:

If(ThisItem.cr82d_status = 'StatusOD (tblOperationalDocumentation)'.Rejected;
ClearCollect(collDocumentation;Filter(tblOperationalDocumentation;cr82d_odid = ThisItem.cr82d_odid)));;

Now it can be adapted again (change data or add / delete rows). All changes are saved in the collection again and all changes can be found when I check the collection. At the end the user pushes a submit button:

First, all "old" items are removed:

removeIf(tblOperationalDocumentation;ODID = TextBoxODID_1.Value);;

All items are added to the table with collect:

Collect(tblOperationalDocumentation;collDocumentation);;

Now my problem: Not all rows of the collection are added to the table. Only new added rows, not the existing ones. I have no idea why.

Any ideas? Thanks for help.

Categories:

Building Power Apps