ForAll/UpdateIf-challenge

[JHL1]

Hi everybody,

I have a tricky scenario I am unable to solve myself. This is its background:

I have a Collection called CollProductLinesDistributor in which my App users store information about specific Product Lines and the regions those products are being sold at. In some cases it occurs that users will identify the same Product Line and a differing region. So the result will be:
Product X, Region X

Product X, Region Y 
Product Y, Region Z

Later on in the App I need to collect a key target value that applies to only the overall Product Lines.

So I therefore do not want to show the users the entire collection stated above, but only distict Product Lines.

Product X
Product Y

I therefore group the collection by Product Line and display this group in a gallery. In the gallery included a textinput in which the users can enter the key target value related to the individual Product Line.

And this my issue:
I do not succeed writing back the individually identified key target values and put them back into the CollProductLinesDistributor.

I experimented a lot with a ForAll(UpdateIf), ForAll(Collect(Filter) and their combinations yet do not succeed.

Any help much appreciated:

Thank you and best regards

JHL  

[RandyHayes · Accepted solution]

@JHL1 

ForAll is a function that returns a table, so if you're looking at it as a for loop - it is not.

In your scenario, you are grouping the records to display them and then seeking input from the user to update....what?  The target value they are entering will be applicable to what in your list?  The list is now grouped together and thus is essentially a Distinct list.  So, if there are 20 records associate with the Product, what is it that you want to update?

[JHL1]

Quick Update:
I was able to write in the textinput's content to the Parent Item shown in the grouped gallery via:

ForAll(RenameColumns(Gallery3_3.AllItems,"ProductLine","PRODUCTLINE2"),
Patch(CollProductLineDristributor,LookUp(CollProductLineDristributor,ProductLine=PRODUCTLINE2),{TurnoverTarget:TextInput3.Text}))

Now I am facing the challenge of also passing on the values to the other Child items of the Grouped Collection:

[JHL1]

Hi @RandyHayes ,

Thank you for your response and trying to wrap your head around it. Much appreciated!

Please take a look at my additional post. I hope this makes things a bit clearer. 

BR

JH

[RandyHayes]

@JHL1 

Sure no problem.  

I have a question though, are you trying to do this for the entire Gallery?  I notice you have a Button in the gallery row...is this the place you are trying to do this operation?

[JHL1]

@RandyHayes ,
No this is only for testing. I will place it later on on the OnChange property of the textinput.

BR

JHL

[RandyHayes]

@JHL1 

So then for your OnChange Action on the textinput, simply put this formula:

UpdateIf(ColProductLineDristributor, 
    ProductLine = PRODUCTLINE2,
    {TurnoverTarget: Self.Text}
)

[JHL1]

Hi Randy,

again thank you for your very valuable input on this.

I assumed that you nestedt your Update if within the ForAll ending up in the following result that I at first placed on the OnChange of the Textinput:

ForAll(RenameColumns(Gallery3_3.AllItems,"ProductLine","PRODUCTLINE2"),
UpdateIf(CollProductLineDristributor, 
    ProductLine = PRODUCTLINE2,
    {TurnoverTarget: TextInput3.Text}
))

If I do that however it results in bulk updating the last input to all and not distinguishing between the different Product Lines.

What I did then is placing the shown code on the Button and selecting it when all fields are filled in. Then it works the way it should.

As my logic throughout the App is that people type in the textinput and this will be stored to the collection, the Button-Solution only is my second choice.

Do you have another suggestion to make the update work individually OnChange of the Textinput opposed to hitting the button at the end of putting everything in?

Looking forward to your response a lot!

Thank you and best regards

JHL 

[JHL1 · Accepted solution]

So I ended up solving this based on the solution that you supplied me with @RandyHayes.

ForAll(RenameColumns(Gallery3_3.AllItems,"ProductLine","PRODUCTLINE2"),
UpdateIf(CollProductLineDristributor, 
    ProductLine = PRODUCTLINE2,
    {TurnoverTarget: If(TextInput3.Text=Blank(),0,TextInput3.Text),
     Edited:true}
));

For whom might be interested:
In the next step I had to add up the grouped Sums via Sum, here having the challenge of adding only the distinct values and not all values of the entire column. So I build another collection on top of CollProductLineDistributor:

ClearCollect(Coll_ProductLineSums,Distinct(CollProductLineDristributor,{ProductLine:ProductLine,Sum:TurnoverTarget}))

Cheers and thanks again Randy for pointing towards the right solution💪💪💪😊.

JHL