Answered

Collection

(0) Share

Report

Posted on by Moira0509

150

I am using this formula for removing the items from the collection as well as from gallery and then updating the collection but this is not removing the items.

RemoveIf(colLocationinfoWithNumber,ID<=24);

Collect(colLocationinfoWithNumber,colLocationinfoWithNumber)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moira0509 - the code which you have written should work. can I know what is the issue that you're facing?

Was this reply helpful? Yes No
Moira0509 150 on at

Like
a
(0)

Report
Copy link

Link copied!

yeah it is removing the items from collection but why it is not updating.
I mean why remaining items id is not getting start from 1.

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moira0509 I can see you are just removing the records <=24. No where the existing record ID's are been updated. If you want to start every time with 1, then every time you remove the records from collection, you need to even update all records ID value, then only it will work.

Was this reply helpful? Yes No
Moira0509 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Even if I am using code like this it is not removing and updating

RemoveIf(colLocationinfoWithNumber,ID<=24);
Collect(colLocationinfoWithNumber,colLocationinfoWithNumber);
ClearCollect(
colLocationinfoWithNumber,
ForAll(
Sequence(CountRows(collocationinfo)),
Patch(
Index(
collocationinfo,
Value),{ID: Value})));

Was this reply helpful? Yes No
Verified answer

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moira0509 Use the below code this should work.

RemoveIf(colLocationinfoWithNumber,ID<=24);
Collect(colLocationinfoWithNumber,colLocationinfoWithNumber);
ClearCollect(
colLocationinfoWithNumber,
ForAll(
Sequence(CountRows(colLocationinfoWithNumber)),
Patch(
Index(
colLocationinfoWithNumber,
Value),{ID: Value})));

Was this reply helpful? Yes No
Moira0509 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah it work thanks

Was this reply helpful? Yes No