cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dyee4613
Level 8

Patch Help (Solved)

I'm having a lot of problems with this.  I have some fields for people to put data in two areas single item and multi item.  The single item works fine but I'm struggling with the multi-item one.  Here is what I want to do.  They input information and the app does the following calculations.  

 

ItemUnitsTimeRewardUnits x Reward% of Total
A12111%
B1040.553%
C10060.252517%
D100080.1212080%

After they finish updating all the items, for all multi-items I want to patch in the highest units and time. 

ItemUnitsTimeRewardUnits x Reward% of Total
A100080.220014%
B100080.330021%
C100080.440029%
D100080.550036%

 

I know the formula is something like ForAll(Filter(Data,MultiItem = True),Patch(Data,???,Max(Filter(Data1,Multipack = true),Units))).

 

Edit: I'm now thinking UpdatedIF is better suited for this.  I'm playing with that right now.

Edit#2: UpdateIF works.  I'm good. 

1 ACCEPTED SOLUTION

Accepted Solutions
myke_deabreu
Level 8

Re: Patch Help (Solved)

Hi Dyee4613,

 

Have you resolved this or can I help?

View solution in original post

2 REPLIES 2
myke_deabreu
Level 8

Re: Patch Help (Solved)

Hi Dyee4613,

 

Have you resolved this or can I help?

View solution in original post

dyee4613
Level 8

Re: Patch Help (Solved)

I was able to figure it out with the updatedif.  Thank you!

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.

Top Kudoed Authors (Last 30 Days)
Users online (4,597)