Auto Increment Id in a Collection, and update collection via that Id.

[Tom_Slosse]

Hey all

Before I start of things, I already made this work with a SQL table, but now I want to recreate this but with a collection, to have faster loadings and just to test it out in general.

But Im struggling with the following, I want to add tasks to a collection with a Id that auto increments everytime a new task is created.

What also needs to possible is that a task can be modified and can be deleted.

Now the incrementing Id works fine only passing that Id to a new task doenst seem to work.

I hope the screenshots below make it a bit more cleat what I try to achieve.

Kind regards

Tom

New Task screen

FIrst task saved in the collection, makes a blank record with itTasklist view

OnHidden NewTask

OnVisible of the NewTask ScreenUpdatecontext IdUpdated IdTaskCollection, where only two tasks can be added apparentlyI

[v-monli-msft]

Hi @Tom_Slosse,

Would you please shared the formula you used to create the collection? 

Regards,

Mona

[Tom_Slosse]

Hey @v-monli-msft

I solved my problem by adding some more screens to my app. So I have one for a New Task and one for Edit Task now and it works fine. I guess the auto increment Id wasn't the problem but the resetting of the field won't work and I think that messed it up. 

But thanks for the reply.

Kind regards

Tom