Hello Team,
I have a task that does the following:
1. Two lists TestPS and 'Test IE'
2. If the OBS column in 'Test IE' is found in OBS column of TestPS, the field_5 value in 'Test IE' should be set to "Urgent"
3. If the OBS column in 'Test IE' is blank or not found in OBS column of TestPS, the field_5 value in 'Test IE' should be set to "Normal".
::::::::::::::::::::::::::::::::::::::::::::::
OBS_x002f_Invoice is from the 'Test IE'
OBS/Invoice# is from TestPS
The code below is what I have used:
// Update records in TestIE based on conditions
ForAll(
TestPS,
If(
OBS_x002f_Invoice = "OBS/Invoice#",
UpdateIf(
'Test IE',
OBS_x002f_Invoice = "OBS/Invoice#",
{ field_5: {Value: "Urgent"} }
),
UpdateIf(
'Test IE',
IsBlank(OBS_x002f_Invoice) || !(OBS_x002f_Invoice = "OBS/Invoice#"),
{ field_5: {Value: "Normal"} }
)
)
)
Error message is that OBS_x002f_Invoice from the If statement says: Name is not valid, OBS_x002f_Invoice is not recognized.
How do I fix this or is there a better way?
