Announcements
I am using this formula RemoveIf(colterm, ID> 24 &&ID < 49);
And i want that after this collection to get refresh how can I do this.
And also how to remove only 2nd row of collection.
Hi @Moira0509
A collection is a local in-memory structure of data and therefore, it does not need to refreshed because it is always up to date. Perhaps you can clarify more precisely the refresh problem that you are facing.
To remove the 2nd row, you can use this syntax.
Remove(colterm, Index(colterm,2) )
When i am deleting the items from the collections it is not getting updated like I am using a code removeif(collection,id is greater than 24&& id less than 73 then it is deleting the item from the collection but the items that are starting from id : 74 are not getting updated. The item from id:74 has to be start from 24 but it is not updating.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 296 Most Valuable Professional
11manish 224
Valantis 181