Hello Community,
I have a power apps,
My requirement: I have columns with Headers With name 1 to 10,
I want to update few columns with different values For that I Built an app with 3 fields (Start Column, End Column, Value)
Lets Say for example I want to Update the columns from 1 to 6 with value '999' and then I want to update values 7 to 10 with '123'
For this I used formula on the Update Button
ClearCollect(
colTemp,
ForAll(
Sequence(10), // Create a sequence from 1 to 10
{
Id: Value,
Value: If(
Value(ST_1.Text) <= Value && Value(ET_1.Text) >= Value,
Value(ValueT_1.Text),
Blank() // If the condition is not met, store a blank
)
}
)
);
UpdateIf(
TenderCosting,
ID = Gallery1.Selected.ID,
{
'1': LookUp(colTemp, Id = 1).Value,
'2': LookUp(colTemp, Id = 2).Value,
'3': LookUp(colTemp, Id = 3).Value,
'4': LookUp(colTemp, Id = 4).Value,
'5': LookUp(colTemp, Id = 5).Value,
'6': LookUp(colTemp, Id = 6).Value,
'7': LookUp(colTemp, Id = 7).Value,
'8': LookUp(colTemp, Id = 8).Value,
'9': LookUp(colTemp, Id = 9).Value,
'10': LookUp(colTemp, Id = 10).Value
}
);
Result: When I try updating the Values I was able to do it for the 1st time then as stated in above example I was able to Patch value from 1 to 6 as '999'. But when I update 7 to 10 as '123', Then I lost the value '999' from 1 to 6 columns.
Could someone please help me with this requirement?
Thanks in advance
@WarrenBelz
@LaurensM
@Amik
@DJ_Jamba
Please Help
@
