Unanswered

Patch and unpatch checkbox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to patch and unpatch checkbox selections directly to my datasource. The problem is with my uncheck, it will only uncheck the first thing. How can I fix the uncheck so this will work?

Default - LookUp(TestResponses, Title=vUserMail && ListID = Text(ThisItem.C1)).CheckValue

OnCheck - Patch(TestResponses,
Coalesce(LookUp(TestResponses, Title=vUserMail && ListID=Text(ThisItem.C1)),
Defaults(TestResponses)
),
{Title: vUserMail, ListID: ThisItem.C1, CheckValue: Checkbox3.Value}
); UpdateIf(collTestMasterData, C1=ThisItem.C1, {C3:Self.Value})

On UnCheck - Remove(collTestMasterData, BrowseGallery1.Selected); Remove(TestResponses, LookUp(TestResponses, ID = BrowseGallery1.Selected.C1)); ClearCollect(collTestResponses, TestResponses);

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

as i read your post , my suggestion and approach is below.

So
1. Approach - of you want to simply remove the Record from the Souce on Uncheck then use code like below -
Remove(TimeSheetEntryBook,ThisItem);
2. Approach -

if you want to Update the Uncheck status at source then you can use the Code like below -
Patch(SouceName,ThisItem,{ColumnsName:"Valueneed2Update"})
Thanks,
Hope this will help you to resolve your issue.

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."-Vijay

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am confused what should mine look like? I tried to modify both formulas. Both formulas said they had invalid arguments. Also, wouldn't I need to use a lookup or remove based on the persons email? Many people will be using the app so it needs to be removed just for that person. @VijayTailor

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I don't know the difference. I just need it to be removed from the datasource and the collection. @VijayTailor

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Then use like below.
For remove from the Source List

Remove(TimeSheetEntryBook,ThisItem);

For Removing from the collection.

Remove(CollectionName,ThisItem);
Thanks,
Vijay

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It says that the type is incompatible and the function remove has invalid arguments. The item removed needs to be based on that persons email C1 also gets the ID number of that item @VijayTailor

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

In this requirement , Wrap the Remove function with if condition with the user and other validation true then only you can remove.

For Error Part can you please mention here which place and for which source you getting error?

Thanks,
Vijay

Was this reply helpful? Yes No