Answered

How to update multiple rows in a SharePoint List using a ComboBox

(0) Share

Report

Posted on by JFrenchKruse

Hello,

I'm currently trying to update multiple rows in a SharePoint List "Toolbox Talks - Data" based off of the information given in a ComboBox. I have my rows, "Name", in the SharePoint List, and each column is designated as Sep. Week 1, Sep. Week 2, etc. I also have a ComboBox, "SelectedEmployees". I want the user to be able to select as many employees as they want, and then mark down in that column that all of those employees are marked as true. The following expression I have created creates two new rows, and marks down every column as true, so I know I've got something right, just not all the way:

ForAll(SelectedEmployees.SelectedItems.'Name (Title)',Patch('Toolbox Talks - Data', {'Dec. Week 4': true}))

The Collect function works identically, so I'm at a loss as what to do, and no other forum post seems to match my predicament (at least what I could find after half an hour). In the photo I've provided, the timestamp rows are irrelevant.

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JFrenchKruse

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance.

However, in your case, it is the UpdateIf function that will fit the need.

But, what is the condition of your Patch? As you have it now, it would only serve to create new records.
JFrenchKruse 13 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
I want it to only update a single column of data per row specified within the ComboBox. I apologize if I can't answer your question fully, I've only started with PowerApps around a month ago. Thanks for the response!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JFrenchKruse

Well, this is more of a data source question.

If you have, let's say, 300 records in your datasource - which one of them would you want to update with the combobox selection??
JFrenchKruse 13 on at

Like
a
(0)

Report
Copy link

Link copied!

I want the ComboBox to correlate to the Names row within the List. My main issue is that I want to update more than one Name at a time.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JFrenchKruse

Sure...what is the Items property of SelectedEmployees?
JFrenchKruse 13 on at

Like
a
(0)

Report
Copy link

Link copied!

The same SharePoint list that the columns I want to update are in - 'Toolbox Talks - Data'.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@JFrenchKruse

Very good. Then, (the most important part) your items has the primary Keys of the records (the ID column).

Therefore, your formula would be:

Patch('Toolbox Talks - Data', ForAll(SelectedEmployees.SelectedItems, {ID: ID, 'Dec. Week 4': true } ) )
JFrenchKruse 13 on at

Like
a
(1)

Report
Copy link

Link copied!

Upon testing that code, it works wonderfully! Thanks so much for your help, I've been stuck on this for the better part of a couple days. You're amazing!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JFrenchKruse

Yes...not a problem. Just remember - a ForAll is NOT a For Loop. It is a table creating function.

In the formula I provided, we are supplying Patch with a table of records that have an ID and the other column you want to change. Patch is smart enough to know that if you provide the primary key (ID in this case) that it will update the associated record for that ID.

So, the ForAll creates the table of records to change and passes that to Patch which then acts on the table.