Entry Based on Matched Conditions

[Sayad]

I have tried to explain to you through the help of an image, I want that if all the conditions are met here, entry should be allowed, otherwise not.

form pageref match table

Please help me create this expression. I will be grateful to you.

[Sayad]

I am searching for a solution to this. Please help me fix it. I have a lot of hope in you.

@Suvrutt_Gurjar @Joseph_Seddik @WillowMobileSys @AleksiAlkio 

[Sayad]

Please support me 🙏

[AleksiAlkio]

More details would be needed. Please try to explain your need with your own words, thanks.

[Sayad]

Hi @AleksiAlkio 

I have a table containing the details of all [channels] and [courier names] of [AWB lengths] Number. I want to create an expression that involves [AWB No] length + [courier name] + [channel] and then match it with a reference table. The goal is to check if an entry exists based on this expression in the reference table.

[Sayad]

Hi @AleksiAlkio I'm awaiting for your response 

[AleksiAlkio]

Still need some details.. like what column types these 3 columns have?

[Sayad]

I have given you the images of both the sheets. 

This is Ref table 

 

 This is Scan Table . I want to put expression in [awb no] column of this table. 

[AleksiAlkio]

Probably something like..

LEN([AWB No]=
ANY(SELECT(Scan Sheet Contains[Quantity],
AND(
[Courier Name]=[_THISROW].[Courier Name],
[Channel]=[_THISROW].[Channel]
)
))

[Sayad]

Hi @AleksiAlkio  Thank you for your response. Showing, LEN function is used incorrectly

[AleksiAlkio]

The ")" was missing from the formula. Use..

LEN([AWB No])=

[Sayad]

@AleksiAlkio Okay, 👌 but there's one issue. I want to show an error message when the wrong [Channel] is selected, otherwise no

[AleksiAlkio]

From here..

[Sayad]

Please Explain Expression 

[AleksiAlkio]

There is no need. Just type it. If the validation is false, it will show your message.

[Sayad]

@AleksiAlkio I don't no why showing "This entry is invalid" 

I want that when I select the [channel] only then the error message should be shown.  some mistake in this expression. Give me one more help in this.

IF(
  AND(
    ISNOTBLANK([_THISROW].[Channel]),
    LEN([AWB No]) <> 
    ANY(
      SELECT(
        Scan Sheet Contains[AWB LENGTH],
        AND(
          [REF_COURIER NAME] = [_THISROW].[Courier Name],
          [REF_CHANNEL] = [_THISROW].[Channel]
        )
      )
    )
  ),
  "AWB length does not match",
  "")

[AleksiAlkio]

Add the condition to your validation.. then you can just write your warning message without any formula.

[Sayad]

ISNOTBLANK([_THISROW].[Channel])

I have set the condition but not Working properly. Please provide expression 

[Sayad]

@AleksiAlkio 

I want that when someone scans [awb no], no error message should be shown.