Dynamic filter search

(0) Share

Report

Posted on by Community Power Pla...

hi Expert,

i am tryin to create a lookup in text input field.

but for result i want to exclude anything from specific country lets say singapre

my current code to look up the client info in two db, now i want to add filter condition in this code. can you help

the code in default of the textinput is mentioned below.

If(TextInput1_11.Text<>"" ||TextInput1_11.Text=Blank(),
If( LookUp(CLIENT_INFO,Source_Client_ID= TextInput1_11.Text).Client_DOB<>Blank() || LookUp('gci.tbl_client_policy_pii_raw','Source Client ID'= TextInput1_11.Text).'Date of Birth'<>Blank() ,Coalesce( LookUp(CLIENT_INFO,Source_Client_ID= TextInput1_11.Text).Client_DOB,LookUp('gci.tbl_client_policy_pii_raw','Source Client ID'= TextInput1_11.Text).'Date of Birth'),
 Blank()))

please help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

Assuming the country is in both data sets. Depending on your Data Source, you may have Delegation issues with this added filter

With( { _Info: LookUp( CLIENT_INFO,Source_Client_ID = TextInput1_11.Text && Country <> "Singapore" ).Client_DOB, _Policy: LookUp( 'gci.tbl_client_policy_pii_raw', 'Source Client ID' = TextInput1_11.Text && Country <> "Singapore" ).'Date of Birth' }, Coalesce( _Info, _Policy ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
HI Warren
Thank you for the quick response but its showing error

With( { _Info: LookUp( CLIENT_INFO,Source_Client_ID = ClientID2.Text && Issue_Country <> "Singapore" "//Error message: Incopmpatible type of comparision. These type cant be compared. Table, text" ).Client_DOB, _Policy: LookUp( 'gci.tbl_client_policy_pii_raw', 'Source Client ID' = ClientID2.Text && 'Source Country' <> "Singapore" ).'Date of Birth' }, Coalesce( _Info, _Policy ) )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
@Anonymous ,

What type of fields are 'Issue Country' and 'Source Country' ? If a Choice or Lookup column

With( { _Info: LookUp( CLIENT_INFO,Source_Client_ID = ClientID2.Text && Issue_Country.Value <> "Singapore" ).Client_DOB, _Policy: LookUp( 'gci.tbl_client_policy_pii_raw', 'Source Client ID' = ClientID2.Text && 'Source Country'.Value <> "Singapore" ).'Date of Birth' }, Coalesce( _Info, _Policy ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No