Answered

Clear multiple collections with one function and also collect multiple collections with one function

(0) Share

Report

Posted on by GoGorilla

160

In the OnVisible property of a form, if form mode is NOT New then collect multiple collections with one Collect function, but if form mode IS new use Clear function to clear multiple collections with one function. I know that my syntax is off but I am not finding a solution out there. The following is my function:

If(
 frmEditDisplayAll.Mode <> New,
 Collect(
 (colMgrPMCorpContract,
 Gallery1.Selected.MgrPMCorpContractEmp)
 &&
 (colMgrPMContractOnly,
 Gallery1.Selected.MgrPMContractEmp) 
 &&
 (colMgrPMOfficersStaff,
 Gallery1.Selected.MgrPMOfficersStaff)
 ),

Clear(
 (colMgrPMCorpContract) && (colMgrPMContractOnly) && (colMgrPMOfficersStaff)
 )
)

Thank you in advance for your assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report
This syntax should work better:

If( frmEditDisplayAll.Mode <> New, Collect (colMgrPMCorpContract, Gallery1.Selected.MgrPMCorpContractEmp); Collect (colMgrPMContractOnly, Gallery1.Selected.MgrPMContractEmp); Collect (colMgrPMOfficersStaff, Gallery1.Selected.MgrPMOfficersStaff) );, Clear(colMgrPMCorpContract); Clear(colMgrPMContractOnly); Clear(colMgrPMOfficersStaff); )

Bryan

Was this reply helpful? Yes No
GoGorilla 160 on at

Like (1)

Report

Thank you!!

Was this reply helpful? Yes No
GoGorilla 160 on at

Like (0)

Report
@BCLS776 Hi, there. I marked you answer as a solution which it does work except I just now thought about testing it when I uncheck an item. It works properly in the data card but it is just appending the collection with the items that remain checked or the newly checked items. This, of course, is pushing the whole collection with the items appended to the SharePoint list. I have OnUncheck property of the check box populated as follows:
Remove(colMgrPMCorpContract,ThisItem)

And the OnCheck property of the check box is as follows:
Collect(colMgrPMCorpContract,ThisItem)

I need the function in the OnVisible property of the form to hold the values if necessary, but I also need the ability to remove items from the collection to update the SharePoint List and to not continue to append to the collection if no changes have been made to that field.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (1)

Report

Hmm, I don't see anything about working with a check box in last weeks' conversation, so I am at a loss as to how to help with that functionality. Check boxes have two separate, useful behavior properties (OnCheck & OnUncheck) that are great for performing actions as a user clicks on that control. Perhaps using one or both of those properties to modify your collection is your solution?

ClearCollect() does a Clear() followed by a Collect() so the effect is to empty the collection completely of all records before collecting new ones. I am not sure if that fits with your app logic, but if you tell us more about how your app works then we might be able to guide you better.

It may also work better to post this question separately and include a link back to this thread.

Bryan

Was this reply helpful? Yes No