cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DIego_Canales
Level: Powered On

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
v-siky-msft
Level 10

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
v-siky-msft
Level 10

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

DIego_Canales
Level: Powered On

Re: Multipatch database in excel and gallery

Thank so much, this is the ideal solution.

 

thanks for all.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 299 members 5,787 guests
Please welcome our newest community members: