Power Platform Community Forum Thread Details

Ugh. This is my first time performing a mass update to a DB2 table and its proving very challenging. If anyone can assist, I'd be very thanful!

Scenario:

There are 5 blank columns in a DB2 table of 20 fields. We need user input for the 5 blanks columns
User filters the table by selecting from Dropdown controls in the app. (<--this works fine)
Results are displayed in a Gallery(<--this works fine)
User selects records to edit using a Checkbox next to each Record in the Gallery
- OnCheck Property set to Collect ThisItem (the entire selected record) (<--this works fine, but is it the correct approach?)
- We end up with a Collection of all items to be Patched to the DB2 table
Once all Records are selected, User selects a value, from a Dropdown menu (outside of Gallery) to apply to ALL SELECTED RECORDS
- OnChange Property sets this selected Value to a variable.
- We grab the remaining 4/5 fields on the back end (User().Name/Email/etc).

I'm having trouble tying it all together with Patch or UpdateIf statement.

The DB2 table DOES NOT have a Primary Key set so this may be blocking us, but if you could weigh in with your best practice/approach here, it would be very awesome.

Thank you!

Categories:

Building Power Apps