Hi I am trying to look in my related table where I have a column expression that is a concatenate which will show a "ERROR : COLUMN NAME" if there is something wrong with the value.
On the parent I would like to have a concatenate that is looking at the related table and if there is any errors in the column I mentioned above it should highlight it using a concatenate expression of its own.
I used the expression below but it returns "Proceed to copy" even though there are columns with Errors, which are being highlighted in the [Error_Message] column.
if(CONTAINS([Related Previews][Error_Message], "ERROR"),"Please Review Your CSV records in the table below as their is an error with one or more of them","Proceed to copy" )
Please help with the expression?
Try wrapping your dereferenced list with concatenate to turn it into text?
if(CONTAINS(CONCATENATE([Related Previews][Error_Message]), "ERROR"),"Please Review Your CSV records in the table below as there is an error with one or more of them","Proceed to copy" )
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |