Hi all,
I have two fields where the user selects a numerical values via a combox list (source is SharePoint List picklist). A third field has a simple multiplication based on the DataCardValue of the two combo boxes. Based on the numerical value of that third field I want to update a forth field with a text value. This will then allow me to submit the form and have all four records update.
The forth field is traditionally a combo box too but I can't get the formula to work based on the DataCardValue of the 3rd number value, instead I have to select from source which seems means the save doesn't update the SP List value of the 4th field
When trying a simple trial, If(DataCardValue381 < 6, "Low", "Medium"), I get an invalid argument type, expecting a Number value.
What am I doing wrong?
If(
Value(ThisItem.'Int Score') < 6,
(Filter(
Choices([@'Register'].'Int Rating'),
Value = "Low"
)),
If(
Value(ThisItem.'Int Score') > 9,
(Filter(
Choices([@'Register'].'Int Rating'),
Value = "High"
) ),
(Filter(
Choices([@'Register'].'Int Rating'),
Value = "Medium"
))))
