Duplicate Error

Sirfyaad · 07-22-2022 03:50 AM

How can i fix this error.

Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)

ISBLANK(
  FILTER(
    ""CAMPUS SCAN SHEET",
    ([_THIS] = [GATE ENTRY NO])
  )
  - LIST([_THISROW])
),
  "Already Scanned This Shipment","Wrong Gate Entry No"))
Expression 'ISBLANK( FILTER( ""CAMPUS SCAN SHEET", ([_THIS] = [GATE ENTRY NO]) ) - LIST([_THISROW]) ), "Already Scanned This Shipment","Wrong Gate Entry No"))' was unable to be parsed: Number of opened and closed parentheses does not match.

Valid If formula for column GATE ENTRY NO (Yes/No,List)

ISBLANK(
  FILTER(
    "Campus scan sheet",
    ([_THIS] = [GATE ENTRY NO])
  )
  - LIST([_THISROW])
)

Note: This expression could impact performance.

((The list of values of column 'GATE ENTRY NO'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
....The value of column 'GATE ENTRY NO')) is empty
Test
open_in_new

Aurelien

Hi @Sirfyaad

What about this ?

Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)

IF(
  ISNOTBLANK(
    FILTER(
      "CAMPUS SCAN SHEET",
      [_THIS] = [GATE ENTRY NO]
    )
    - LIST([_THISROW])
  ),
  "Already Scanned This Shipment",
  "Wrong Gate Entry No")
)

Valid If formula for column GATE ENTRY NO (Yes/No,List)

ISBLANK(
  FILTER(
    "Campus scan sheet",
    [_THIS] = [GATE ENTRY NO]
  )
  - LIST([_THISROW])
)

Sirfyaad

Hi @Aurelien

Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)

Showing error

Aurelien

You can read the error message...

I forgot to remove one parenthesis. This one.

Sirfyaad

Hi @Aurelien

Both Expression are Done. but Duplicate error but showing why.

Valid If formula for column GATE ENTRY NO (Yes/No,List)

ISBLANK(
  FILTER(
    "CAMPUS SCAN SHEET",
    [_THIS] = [GATE ENTRY NO]
  )
  - LIST([_THISROW])
)
Note: This expression could impact performance.

((The list of values of column 'GATE ENTRY NO'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
....The value of column 'GATE ENTRY NO')) is empty


Error_Message_If_Invalid formula for column GATE ENTRY NO (Text)

IF(
  ISNOTBLANK(
    FILTER(
      "CAMPUS SCAN SHEET",
      [_THIS] = [GATE ENTRY NO]
    )
    - LIST([_THISROW])
  ),
  "Already Scanned",
  "Wrong Gate Entry No")


Note: This expression could impact performance.

IF this condition is true: 
....This statement is false:
........((The list of values of column 'GATE ENTRY NO'
............from rows of table 'CAMPUS SCAN SHEET'
............where this condition is true: ((The value of column 'GATE ENTRY NO') is equal to (The value of column 'GATE ENTRY NO')) - LIST(
............The value of column 'GATE ENTRY NO')) is empty
THEN use the value of: 
...."Already Scanned"
ELSE use the value of: 
...."Wrong Gate Entry No"

Aurelien

question: as you have only one condition in the valid_if expression, why don't you just put :

"Already Scanned"

in your error message ?

Sirfyaad

If the user enters Wrong Gate Entry, then "Wrong Gate Entry No" has to be shown for him. And if someone re-enters one entry then "Already Scanned" will appear.

Aurelien

Thank you for the explanation.

The error message, with the IF() expression, suggests your valid_if expression can have two situations. Currently, it only deals with one.

You may want to make these two fields to match.

Sirfyaad

AND(NOT(
AND([_THIS]<1984990,
[_THIS]>1984990
)),
ISBLANK(
FILTER(
"CAMPUS SCAN SHEET",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
))



IFS (
NOT(
AND([_THIS]<1984990,
[_THIS]>1984990
)
),
"Invalid Gate Entry No",
ISBLANK(
FILTER(
"CAMPUS SCAN SHEET",
([_THIS] = [GATE ENTRY NO])
)
- LIST([_THISROW])
),
"Already scan your shipment"
)