Collection regenerating sequence number

(0) Share

Report

Posted on by chow0724

Hi Community,

I've the simple collection which will increasing and index, which currently is working fine.

I have the function for the delete the row of the collection, which the sequence number need to regenerate it, how to regenerate the sequence of the number?

Below are the code i use:

OnVisible:

ClearCollect(AssetCollection,{LineItem:"Notebook",LineSerialNumber:"",LineSignOutRemarks:"",LineReturnRemarks:"",LineIndex:Value(Last(AssetCollection).LineIndex)

Add Row:

Collect(AssetCollection,{LineItem:"Notebook",LineSignOutRemarks:"",LineReturnRemarks:"",LineIndex:Value(Last(AssetCollection).LineIndex)+1});

Remove Row in Gallery:

Remove(AssetCollection,ThisItem)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @chow0724 :
Do you want to regenerate the LineIndex field based on the deleted record?
This function can be achieved through the updateIf function:
Remove Row in Gallery:

UpdateIf(AssetCollection,LineIndex>ThisItem.LineIndex,{LineIndex:LineIndex-1});Remove(AssetCollection,ThisItem);

I think this link will help you a lot:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif
Best Regards,
Bof

Was this reply helpful? Yes No
chow0724 4 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft it worked! thanks for providing the solution, will also explore the update if function

Was this reply helpful? Yes No