Patching multiple rows from a selected item in a Gallery

(0) Share

Report

Posted on by shibathedog

Hi, I have some issues with figuring out the patching formula so any help would be appreciated!

I have a table (named Projects) in excel which I connected to a gallery.

This is the example table:

Company	Project	Finished?
A	One
A	Two
B	Three
B	Five
B	Four
B	Six
C	Eight
C	Ten
C	Nine

And I have a Gallery (named GalleryCompany) which shows the items A and B.

I want to make a button that would patch all of the Projects under company A or B, depending on which one is selected in the GalleryComapany. That means if I select the C (Title1 of GalleryCompany) in the list and click the button, the projects Eight, Nine and Ten should get a "Yes" Tag in the Finished? column.

This is the code I've been trying to apply but without success:

ForAll(Projects.Project,
Patch(Projects, LookUp(Projects, Company = Title1.Text),
{Finshed?: "Yes"}
))

EDIT: I also tried with this but the same happens (just the first value gets updated):

ForAll(Projects.Project,
Patch(Projects, LookUp(Projects, Company = GalleryCompany.Selected.Result),
{Finshed?: "Yes"}
))

Only the first record (Eight) gets tagged. I also tried with the UpdateIf formula but that didn't write anything. I also tried changing the ForAll source to the gallery but didn't get anything.

Any suggestions or help would be great! I am still very new and learning the ropes of PowerApps 🙂

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @shibathedog ,

According to your description, I've made a test for your reference:
1\ This is my table ‘Table1’.

2\ Add a button control and set its onselect property to:
ClearCollect(AAA,Table1) // This step cannot be omitted

3\ Add a combo box control ‘ComboBox3’ and set its Items property to:
Distinct(Table1,Company)

Set the combo box control’s DisplayFields property to:
["Result"]

4\ Add a gallery control 'Gallery5' and set its items property to:
Ungroup(ForAll(ComboBox3.SelectedItems,Filter(AAA,Company=Result)),"Value")

5\ Add a button control and set its onselect property to:
ForAll(Gallery5.AllItems.Project As ABC,Patch(Table1,LookUp(Table1,Table1[@Project]=ABC[@Project]),{'Finished?':"Yes"}));ClearCollect(AAA,Table1)

6\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
shibathedog 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,
I am so sorry, I just now have seen that I didn't reply to you nor accept this as the solution! I thought I did but guess I forgot. Thank you for this, it was very helpful in building what I wanted but this unfortunately cannot be replicated in my app because I have to have 1 gallery and 1 button, nothing else. But this helped me in many other ways so thank you very much!! 🙂

Kind regards!

Was this reply helpful? Yes No