web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps autogenerating /number...

Power Apps

Answered

autogenerating /number sequencing in PowerApps

(0) Share

Report

Report

Posted on by PallaviSW

10

I have a collection with column sequence number(hardcoded numbers) and item name. collection gets the data from excel . Now I have a use case where on button click random number(start, end) gets generated ,it selects the sequence number and item name accordingly and it removes that particular record from collection .

e.g.

sequence number item name

1 item 1

2 item 2

3 item 3

if the generated random number is 2 ,it will remove that particular record from collection .

sequence number item name

1 item 1

3 item 3

Now the issue is if click that button again ,sometimes its generating same random number again .in this case 2 .but now particular record with that number doesn't exists. so how can I sequence that sequence number column in order to avoid this issue.

Thanks in advance

@RezaDorrani your suggestion do matter 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Pablo Roldan 316 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi, you could place a check condition before remove the element
here the code, it's a concept but you need adapt it
If(!IsBlank(Filter('YourCollection',ID = YOURIDGENERATED),Remove('YourCollection',ITEM_TO_REMOVE))
regards

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PallaviSW :

I've made a test for your reference:

1\I assume there is a table

ClearCollect( TheCollection, {'sequence number':1,'item name':"item 1"}, {'sequence number':2,'item name':"item 2"}, {'sequence number':3,'item name':"item 3"} )

2\You could use this formula to remove a row randomly.

With( {DeleteRowNumber:RandBetween(1,CountRows(TheCollection))}, Remove( TheCollection, Last(FirstN(TheCollection,DeleteRowNumber)) ) )

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation