Answered

Checkbox is patching unchecked records

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

This is my patch statement which is on a button. Currently every record is being patched whether checked(true) or unchecked (false). Is there a way to only patch the checked records?

Navigate(Screen2,Fade);ForAll(BrowseGallery1.AllItems, Patch('CCB Voting', Defaults('CCB Voting'), {Title:Name, Answer: Checkbox3.Value,Name_:User().FullName, Date:Today(), Country:(First(Office365Users.SearchUser({searchTerm:User().Email}).Country).Country)}))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Consider changing your formula to the following:

Navigate(Screen2, Fade); ForAll( Filter(BrowseGallery1.AllItems, Checkbox3.Value), Patch('CCB Voting', Defaults('CCB Voting'), {Title:Name, Answer: Checkbox3.Value, Name_:User().FullName, Date:Today(), Country: Office365Users.UserProfileV2(User().Email).country } ) )

That should give you what you are looking for. Also, with the bonus of simplifying the country lookup.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Also add to the last post. You will want to do the User() function once if you can. The function has a hit on performance.

Consider this formula instead of the one I mentioned last.

Navigate(Screen2, Fade); With({UserEmail: User().Email, UserName: USer().FullName}, ForAll( Filter(BrowseGallery1.AllItems, Checkbox3.Value), Patch('CCB Voting', Defaults('CCB Voting'), {Title:Name, Answer: Checkbox3.Value, Name_:UserName, Date:Today(), Country: Office365Users.UserProfileV2(UserEmail).country } ) ) )

This will do only two calls to the user function instead of two for each record you are patching.

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

Like
a
(1)

Report
Copy link

Link copied!

Works perfectly!

Was this reply helpful? Yes No