cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

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

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

 

NewTask.PNGNew Task screen

TaskListBlankRecord.PNGFIrst task saved in the collection, makes a blank record with itTaskListView.PNGTasklist view

 

 

 

 

NewTaskOnHidden.PNGOnHidden NewTask

 

 

 

 

NewTaskOnvisible.PNGOnVisible of the NewTask ScreenTaskListId.PNGUpdatecontext IdTaskListId2.PNGUpdated IdTaskListCollection.PNGTaskCollection, where only two tasks can be added apparentlyI

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @Tom_Slosse,

 

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

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,919)