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:

Building Power Apps

All responses (7)

Answers (0)

Sort by

developingteal 392 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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.