web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Mass Update records fr...

Power Apps

Answered

Mass Update records from grouped gallery

(0) Share

Report

Report

Posted on by neill_long

728

Hi

I have a gallery which groups records together based on the field in the SP List called Period.

The items are listed as mmm yyyy

What I was looking to do, was add a checkbox to the gallery so that when it is checked, it should update all records that match the field Period and update the column called Invoice to say "Yes".

This is what the gallery is showing:

So when i check the box under Oct 2023, it should locate all the records in the SP List where Period matches 'Oct 2023' and update the relevant fields. But it should not update the records where Period is 'Nov 2023'.

Is this possible, and if so, what formula can i use on the OnCheck option?

thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

QuentinDURIEZ 577 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

You can use this code for OnCheck/OnUncheck of your checkbox

Patch( [DATASOURCE], ForAll(Filter([DATASOURCE], Period = ThisItem.Period ), Patch( ThisRecord, { Invoice : true //Or Yes value } ) ) )
This code will bulk patch all your items where the column Period is equal to your galley item period, you will still need correct this part of the code for your specific case, but "ThisItem" is important to have the good period context

Regards,

Join the conversation