Multiple Record Selection Combo Box Modifying All Select Records

(0) Share

Report

Posted on by benchjeff

I have a combo box that filters through a list of records in a form.

I need a button or something to modify an attribute of these selected records.

In this picture, I have selected 3 records by their ID number.

I have a column called Authorization and in that column I want their Authorization to go from Approved to Rejected from a possible button press.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@benchjeff

If you have the ID number (primary key) of the records in your Items property of the combobox, then you simply need the following on a Button OnSelect action:

Patch(yourList, ForAll(yourComboboxName.SelectedItems, {ID: ID, Authorization: "Rejected" } ) )

This assumes that your Authorization column is a single line of text.

If it is something different, then that part of the formula needs to reflect the correct data type for that column.

I hope this is helpful for you.

Was this reply helpful? Yes No
benchjeff 39 on at

Like
a
(0)

Report
Copy link

Link copied!

The authorization column is a choice column.
I am getting a invalid argument error. (Table) Expecting a record instead.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@benchjeff

The message is misleading - it is telling you that because your columns do not match the correct types.

If it is a choice column, then change your formula to the following:

Patch(yourList, ForAll(yourComboboxName.SelectedItems, {ID: ID, Authorization: {Value: "Rejected"} } ) )

Was this reply helpful? Yes No
benchjeff 39 on at

Like
a
(0)

Report
Copy link

Link copied!

We got something going.

However, it looks like it patches new entries instead of modifying the existing ones.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@benchjeff

What is the Items property of the Combobox?

Was this reply helpful? Yes No
benchjeff 39 on at

Like
a
(0)

Report
Copy link

Link copied!

ComboBox1 Items

Filter('PTF41004Data',Authorization.Value="Approved").Identification

Button OnSelect

Patch('PTF41004Data',ForAll(ComboBox1.SelectedItems,{Identification : Identification , Authorization: {Value: "Rejected"}}))

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@benchjeff

You are missing the primary key of your data!

Your Items formula is only providing the Identification column from your list. You need the ID (the primary key).

Your Items property formula should be:

Filter('PTF41004Data',Authorization.Value="Approved")

And your Button OnSelect action should be:

Patch('PTF41004Data',ForAll(ComboBox1.SelectedItems,{ID : ID, Authorization: {Value: "Rejected"}}))

If you do not provide the primary key, then Patch will create records. If you provide the primary key, then patch will update records.

Was this reply helpful? Yes No
benchjeff 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Also it does not work if I try

ComboBox1 Items

Filter('PTF41004Data',Authorization.Value="Approved").Title

Button OnSelect

Patch('PTF41004Data',ForAll(ComboBox1.SelectedItems,{Title: Title , Authorization: {Value: "Rejected"}}))

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@benchjeff

When you put a .Identifier or a .Title after a table (Filter returns a table), then PowerApps will throw out all other columns except the one you specify. In your case you need the ID. It is the primary key.

Was this reply helpful? Yes No