adding and deleting records and creating unique IDs ( countRow )

(1) Share

Report

Posted on by Palucci12

Hello,

I have an application that adds a new record to the list using Icon on OnSelect.

OnSelect:

Set(varRespond, Slide14Addrow.Run(
 CountRows(ev_List_Sharepoint_MilestonTopIssue) + 1,
 "KXEO-01700"
));

But in the photo, as you can see, I also have a "X" to delete records, how can I do it (it can also be done using flow) so that these records are recalculated and show the rows in the POS column anew, i.e. when I delete 1, row 2 becomes 1.

Thanks !

Categories:

General Questions

All responses (7)

Answers (0)

developingteal 392 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

yeah, you need to make the POS column in sharepoint a calculated column - i believe there is a built in pkey like column which would meet your needs. It might be called autonumber but that could be dataverse and me getting things mixed up.
Palucci12 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

They are to be saved in SharePoint again, these are the values entered in the POS column in SharePoint
developingteal 392 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

is that for display or are you talking an column in a db? If it's just display you need to reset your display
Palucci12 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

I don't think we fully understood each other. I delete the row using Power Automate or Patch(). I have POS 1 POS 2 POS 3, I remove POS 2 and I am left with POS 1 and POS 3, . I would like to make POS 1 and POS 2. For example, using count rows it would count how many rows there are and update the item. or patch
developingteal 392 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

I think you are using sharepoint as your data source - you can make a calculated column inside of sharepoint to recalculate it.
Palucci12 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

but what should I put in the POS column? in input ? I don't understand it well, the only problem is how to recalculate the number of rows in the list and change the values
developingteal 392 on at

Like (1)

Report

Re: adding and deleting records and creating unique IDs ( countRow )

use a patch function to delete the records, then reset the list or display you are using (or both) using Reset()