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 !
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.
They are to be saved in SharePoint again, these are the values ​​entered in the POS column in SharePoint
is that for display or are you talking an column in a db? If it's just display you need to reset your display
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
I think you are using sharepoint as your data source - you can make a calculated column inside of sharepoint to recalculate it.
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
use a patch function to delete the records, then reset the list or display you are using (or both) using Reset()