cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Multipatch database in excel and gallery

 
I hope you can help me, I already checked some forums and there is a solution, but I cannot apply it.
I'm trying to patch the same amount to a database with the same concept, so as not to make the explanation so complicated, I copied the data from the powerapps example for the use of the PATCH function, which is:
DIego_Canales_0-1572457869026.png

 

I created it from data and put it in an Excel file with the name "ICECREAM".
I need that all the names in the "FLAVOR" column with the concept "CHOCOLATE" be saved with the same amount.
For this, I made a gallery with the name "BrowseGallery4"

DIego_Canales_1-1572458028372.png

 

 The "MULTI" button, I try to make this PATCH, but when executing it only changes the first cell it finds.

 

Spoiler
ForAll(BrowseGallery4.AllItems;Patch(ICECREAM;LookUp(ICECREAM;FLAVOR=Title1.Text);{QUANTITY:TextInput4_1.Text}))

 

 

DIego_Canales_2-1572458115798.png

 

 This resulted when I execute it.
 
DIego_Canales_5-1572458234521.png
 
But I want to change all the concepts with "CHOCOLATE" with the amount of 300

I hope you can support me, when this problem will be resolved, my project will be completed.

Thanks and greetings to all.
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Multipatch database in excel and gallery

Hi @DIego_Canales ,

 

I think UpdateIf function can get what your want easily.

Please try this:

UpdateIf(Icecream,Flavor=Title1.Text,{Quantity:TextInput4_1.Text})

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Multipatch database in excel and gallery

Hi @DIego_Canales ,

 

I think UpdateIf function can get what your want easily.

Please try this:

UpdateIf(Icecream,Flavor=Title1.Text,{Quantity:TextInput4_1.Text})

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

View solution in original post

Highlighted
Frequent Visitor

Re: Multipatch database in excel and gallery

Thank so much, this is the ideal solution.

 

thanks for all.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,951)