Unanswered

Making changed on several item

(0) Share

Report

Posted on by cabutbul

Hi
I'm using the below code (in Save button) to update field changes in Status column in my SharePoint list which called Vacations.
It's works, but it's allow me to update one field at a time.
How can I updated changes in multiple fields by one click on Save button?

Patch(
Vacations,
Gallery6.Selected,
{ Status: ComboBox_Status.Selected }
);

Refresh(Vacations)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 155,679 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cabutbul ,

How are you identifying which records to update ?

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report
Copy link

Link copied!

After the changes by the user, it is okay that clicking the Save button will update all the records in the gallery

Was this reply helpful? Yes No
WarrenBelz 155,679 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@cabutbul ,

Is ComboBox_Status inside or outside of the gallery ?

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report
Copy link

Link copied!

inside

Was this reply helpful? Yes No
WarrenBelz 155,679 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @cabutbul ,

You did not state your data source, but if SharePoint the Identifier can be the ID field.

ForAll( Gallery6.AllItems As _Data, Patch( Vacations, LookUp( Vacations, YourIdentifier = _Data.Identifier ), {Status: _Data.ComboBox_Status.Selected} ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
joao_guerreiro 56 on at

Like (0)

Report
Copy link

Link copied!
Hello catbulbul;

Here's my solution for your problem.

ForAll(Gallery6.AllItems; If(ThisRecord.Status.Value = "Free"; Patch( Vacations; LookUp(TestPatch; Title = Title1.Text); { Status: ComboBox1.Selected.Value } );; ; false ) )

I hope it helped you and have a excelent day!

Don't forget to give kudos and mark this as solution if it helped you ❤️

Was this reply helpful? Yes No