No warning or error message is displayed when the user uploads a file containing duplicate advisor code and Line of business.
I need validation message when I am uploading more than 1 entry with same data. that is if the excel consists same line of business and advisor code then I need this validation messagea!forEach(items: local!constructData,expression: if(count(index(fv!item[local!constructData.advisorCode],wherecontains(fv!item[local!constructData.lineOfBusiness],tostring(local!constructData)))) > 1,"Duplicate Line of business",null)),
Discussion posts and replies are publicly visible
Made few tweaks to your code. Try the below
a!forEach( items: local!constructData.lob, expression: if( count( index( local!constructData.advisorCode, wherecontains( fv!item, local!constructData.lob ) ) ) > 1, "Duplicate Line of business", "" ) )
Few notes : tostring(local!constructData) will cast your entire data into a single text and wherecontains() won't work appropriately.