cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jk213
Frequent Visitor

Forall and Patch Gallery items issue

Hi All,

i am trying to patch all the gallery records through my patch function. What i am currently doing is there is a select all button which selects all the records of the gallery and while doing the patch i am filtering the gallery based on checkbox true value. Now the only problem that i am facing is that Forall(Gallery1.Allitems is just patching first 100 records however there are more than 100 records to be patched. How can i patch all the records in gallery1 which have been checked.
I am not creating a collection as i am facing the same issue there, when i click on select all checkbox only first 100 records are getting created in the collection.

How can i fix this issue or anyone has an alternative approach for this?

1 REPLY 1
RandyHayes
Super User
Super User

@jk213 

No collection is needed.  Your formula to patch the selected items is quite simple and should be this:

Patch(yourDataSource,
    ForAll(Filter(yourGallery.AllItems, yourCheckBox.Value),
        {ID: ID,
         othercolumn: othercolumnValue
        }
    )
)

 

If you have trouble incorporating this in to what you have, please provide the formula(s) that you are working with.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,318)