Hi @Anonymous :
Do you want to update the Level field of multiple records?
Please consider take a try with ForAll function to achieve your needs.
I’ve made a test for your reference:
My data source: ‘List A’
Case1:Use forall and patch
1\Add a DropDown control(Customerid)
Items:
Distinct('List A',Customer_ID)
2\Add a DropDown control(thelevel)
Items:
["Low","Medium","High"]
3\Add a button
OnSelect:
ForAll(
RenameColumns(
Filter(
'List A',
Customer_ID = Customerid.SelectedText.Value
),
"ID",
"TheID"
), /* Change the field name to eliminate ambiguity*/
Patch(
'List A',
LookUp(
'List A',
ID = TheID
),
{
TheLevel: thelevel.SelectedText.Value,
TheDate: Today()
}
)
)
Case2:Use update if
1\Add a DropDown control(Customerid)
Items:
Distinct('List A',Customer_ID)
2\Add a DropDown control(thelevel)
Items:
["Low","Medium","High"]
3\Add a button
OnSelect:
UpdateIf(
'List A',
Customer_ID = Customerid.SelectedText.Value,
{
TheLevel: thelevel.SelectedText.Value,
TheDate: Today()
}
)
Best Regards,
Bof
