Answered

ID number

(0) Share

Report

Posted on by Community Power Pla...

Hey, I need little help from someone who knows these things little better. I am building an app, that user puts values in, on couple of field, and then tey move to google shetts spreadsheet, and they get an id pased on the previous number. Everything else works fine, but when I delete one of the records, lets say one from the middle, the id numbers after the deleted one stay the same. For example, lets say that we have id numbers 15,16,17. And we delete the 16. After that, it says 15,17. And i want it to be 15,16. Can someone help me on how to do that? Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous

Please try the following (change table, column names as applicable),

ForAll(Filter(yourtable, ID>IDoftheDelectedrecord), Update(yourTable, ThisRecord, {ID:ThisRecord.ID-1}) )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @CNT . Looks like it might work, but for some reason I haven`t got it to work yet. But I will try again

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@CNT Finally got it working. Had to change your answer just a little bit.
ForAll(Filter(yourtable, ID>IDoftheDelectedrecord),
Patch(yourTable, ThisRecord, {ID:ThisRecord.ID-1})
)

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous Gald it works!

Was this reply helpful? Yes No