regarding validations in excel

Question

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)),

harshas2775 · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO