Recently I raised a topic and did get an answer. Unfortunately my if statement now has more if statements. I have not been able to update the provide response to fit these new If statements. The datasource for my app is a SPO list called Requests.
I have another SPO list called DLAPath with columns DLA Name, DLAMinAmount, DLAMaxAmount
This specifies who can approve something depending the value amount.
I am trying to set a value forDataCardValueDLAPath to the DLA Name from the SPO list depending on the value in DataCardValueNetBookValue field AND whatever is selected from the Select L2 Approver choice field. If there is no selection in the Select L2 Approver choice field then only DataCardValueNetBookValue is used to lookup the SPO list.
The Select L2 Approver is disabled unless the DataCardValueNetBookValue amount is >50000 and <= 100000. Then it is enabled.
Sample SPO list
| DLA Name | DLAMinAmount | DLAMaxAmount |
| Board | 5000001 | 100000000 |
| CFO | 100001 | 5000000 |
I am not sure if actually need the list if I can hard code the nested If statements to return values.
Example
DataCardValueNetBookValue = 100500
Therefore DataCardValueDLAPath would be "CFO"
DataCardValueNetBookValue = 50001 and ETMembers.selecteditem = CIO
Therefore DataCardValueDLAPath would be "CIO"
The if statements I need converted to one default of the text field txtDLAPath are:
If Net Book Value = 0 to 50,000 then Disposal DLA Path = GFC,
If Net Book Value > 50,001 and <= 100,000 and Select L2 Approver = MD Markets then DataCardValueDLAPath = MD Markets,
If Net Book Value > 50,001 and <= 100,000 and Select L2 Approver = COO then DataCardValueDLAPath = COO,
If Net Book Value > 50,001 and <= 100,000 and Select L2 Approver = CIO then DataCardValueDLAPath = CIO,
If Net Book Value > 100,001 and < = 2,000,000 then DataCardValueDLAPath = CFO,
If Net Book Value > 2,000,001 and < = 2,500,000 then DataCardValueDLAPath = CEO,
If Net Book Value > 2,500,001 and < = 1,000,000,000 then DataCardValueDLAPath = Board
Any assistance would be greatly appreciated. Thank you
