Refresh() function and ClearCollect function of SharePoint list

(0) Share

Report

Posted on by Community Power Pla...

Hello guys!

I'm struggling to find a solution for this and if you could do I really appreciate!!!

I have two SharePoint Lists: one called "Contracts" and other "Document List".

The first one has contract request information and the second one is a list of documents that people may add related to contract request information. I separated in two lists because I had several problems on attaching lots of documents per list item, so in "Document List" I add one file per item when attaching.

The thing is: I created a button inside a gallery to ocasionally delete some list items, but every time I remove and then click on a Refresh button, the item appears again in the gallery.

Here's what I did:

1. in Screen:

OnVisible: Set(_Loading;true);ClearCollect(colAttachments, Filter('Document List';'ID Contract'= SelectedItem.ID));Set(_Loading;false)

2. in Remove Item Button:
OnSelect: Remove('Document List',First(Filter('Document List',ID = ThisItem.ID)));
Remove(colAttachments,ThisItem);
Refresh('Document List')

3. in Refresh Gallery Button:

Refresh('Document List');

ClearCollect(colAttachments,Filter('Document List','ID Contract' = SelectedItem.ID))

How can I avoid that delay? Users is often saying that in the first time they press Refresh Button, the item appears again.

I really appreciate if you experts guys could help!

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (2)

Report

Hi @Anonymous ,
Not sure why the remove item from collection is not working, but I would do this in Step 2:

OnSelect: Remove('Document List',First(Filter('Document List',ID = ThisItem.ID)));
Refresh('Document List');
ClearCollect(colAttachments,Filter('Document List','ID Contract' = SelectedItem.ID))

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up.

Was this reply helpful? Yes No
Keith-Whatling 41 on at

Like (0)

Report

Might be that SharePoint is taking some time to move the item to the recycle bin, how about putting the refresh on a timer like give it say 1.5 seconds and call refresh.

The other issue might be the First() call, so you'd only remove the first item in the list of documents that has that list ID. You could have a gallery in a gallery to show the files as a subset of the Contracts. Does that make sense?

Then you could drill in and remove a specific document. You could also use RemoveIf() to remove all documents related to a Contracts item.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Keith-Whatling ,
Yes, all of that would probably work. I as a rule refresh & re-collect every time I add or delete a SharePoint list or library item and have never had an issue.

Was this reply helpful? Yes No
Keith-Whatling 41 on at

Like (0)

Report

If it does not work drop me a shout and we can have a quick teams call and get you unblocked.

Was this reply helpful? Yes No