web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Look up Name in two da...
Power Apps
Answered

Look up Name in two database and display if found in any

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

hi Expert 

 

I am trying to do a lookup in multiple database and if found  in any info than display the name 

Client id acrros the databases for the customer is same. 

Like below: 

pokhani_1-1702000616005.png

 

 

if i enter the client id in text  1 than it will look the value in both the database, if record match than display name in the client Name box 2 and if no records found than it will display no result found. 

 

please help

 

 

 

Categories:
Building Power Apps
I have the same question (0)
  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    I create the test data by Button-OnSelect:

    ClearCollect(database1, {'Client Id':1,Name:"Sam"}, {'Client Id':2,Name:"Ram"}, {'Client Id':3,Name:"DamUpdate"}, {'Client Id':4,Name:"Tam"});
ClearCollect(database2, {'Client Id':1,Name:"Sam"}, {'Client Id':2,Name:"Ram"}, {'Client Id':3,Name:"Dam"}, {'Client Id':4,Name:"Tam"},{'Client Id':6,Name:"Bam"},{'Client Id':7,Name:"Fam"})

    vyueyunmsft_0-1702001766632.png

    We can use code in the TextInput2-Default:

    If(TextInput1.Text<>"" ||TextInput1.Text=Blank() , 
If( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name=Blank() ||LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name=Blank() ,"no result found." ,
If( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name = LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name , LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name
, "no result found.") ))

     

    Best Regards,

    Yueyun Zhang

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I am confused with your code as in last you are trying to match the records between two table. I dont want to have, it will try to check the value in two database and display if found in any 

     

     

     

    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'=Value( TextInput1_11.Text)).'Date of Birth'=Blank() ,"no result found." ,
If( LookUp(CLIENT_INFO,Source_Client_ID= TextInput1_11.Text).Client_DOB = LookUp('gci.tbl_client_policy_pii_raw','Source Client ID'=Value( TextInput1_11.Text)).'Date of Birth', LookUp(CLIENT_INFO,Source_Client_ID= TextInput1_11.Text).Client_DOB
, "no result found.") ))

     

    pokhani_1-1702002715751.png

    for the cleint name i was using the following code 

    If(
 TextInput1_11.Text in CLIENT_INFO.Source_Client_ID, /* <-- Check the entered ClientId is valid (existed in your SQL Table already) */
 LookUp(CLIENT_INFO, TextInput1_11.Text in Source_Client_ID,Client_Name),"No Records Found"
)||If(
 TextInput1_11.Text in 'gci.tbl_client_policy_pii_raw'.'Source Client ID', /* <-- Check the entered ClientId is valid (existed in your SQL Table already) */
 LookUp('gci.tbl_client_policy_pii_raw', TextInput1_11.Text in 'Source Client ID','Client Full Name'
),"No Records Found")

    but its giving false result

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    Thanks for your quick response! Sorry for i may misunderstand your need , you can try to use this code :

    If(TextInput1.Text<>"" ||TextInput1.Text=Blank(),
If( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name<>Blank() || LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name<>Blank() ,Coalesce( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name,LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name),
 "no result"))

     

     

     

    If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.


    Best Regards,

    Yueyun Zhang

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    i am trying to build an app to create as case and  while creating the case  it will check if the record for the customer ever exist in the past. so before creating it will search the Name based on the client id in two database. if any of the record matches in either database it will fetch the client information and poupulate in respective field. 

     

    for example: 

    i have a client id as 7. 

    pokhani_0-1702003796281.png

    no it will look the client id in both the database and if it matches than it will display the cleint name else it will display "No result found" 

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 
    Yes, in my above code , it is looking for the Name if contains in the one of your database:

    vyueyunmsft_0-1702004033133.png

     

    If(TextInput1.Text<>"" ||TextInput1.Text=Blank(),
If( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name<>Blank() || LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name<>Blank() ,Coalesce( LookUp(database1,'Client Id'=Value( TextInput1.Text)).Name,LookUp(database2,'Client Id'=Value( TextInput1.Text)).Name),
 "no result"))

     

     

     

    If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.


    Best Regards,

    Yueyun Zhang

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    its not fetching the date value, error is in yellow highlighted field and it says 

    pokhani_1-1702004895257.png

    i used the following code and even tried using value option. it says Value "no result cannot be converted to number

     

    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'),
 "no result"))

     

     

    pokhani_2-1702004936296.png

     however if i use the follwing code than there is no error. 

    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'),
 Value("")))

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    Can you try to use this code in your side ?

     

     

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

     

    For this error code , it seems your Clirnt_DOB column is a Date type , so we can not return the different type result in the If() function. 

    And what is your ClientID column Type , if it is a number instead of the Text , you need to add the Value():

    Value( TextInput1.Text)

     

    Best Regards,

    Yueyun Zhang

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    the data type is date for DOB and client id is alphanumeric

  • Verified answer
    v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    Yes , you can try to use this code :

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

     

    Best Regards,

    Yueyun Zhang

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hi 

    if i had to add the a filter in above than 

    lets say 

    i dont want to display the result if the data is from singapore. where do i add the 

    pokhani_0-1702660861295.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans