cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diegomarino
Frequent Visitor

problem on lookup on three tables

hi,

i have a problem on lookup formula

i have three tables

 

1) Candidati (applicants), in which i have a IDCandidato and an ComuneID (which is the city)

2) Comuni, in which i have all the cities and the column IDcomune is the primary key for ComuneID present in Candidati table

3) calendario, in which i store every task related to my applicants, so there is a date and a CAndidatoID that's the foreign key for IDcandidato, so i can relate a task to an applicants

 

i wrote this formula

 

LookUp(
    Comuni;
    LookUp(
        Candidati;
        Candidato = IDcandidato;
        ComuneID
    ) = IDComune;
    Comune
)

i lookup in the CIties table (comuni) the ComuneID (that's the city related to an applicant) and i retun the "comune" column that's the city name

 

now, this formula gives me "false" as result, but if i just lookup for comuneiD i have the right result

LookUp(
    Candidati;
    Candidato = IDcandidato;
    ComuneID
)

why?

thanks

 

2 REPLIES 2
Community Support
Community Support

Re: problem on lookup on three tables

Hi @diegomarino ,

 

The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria. So your first formula that use a Lookup inside another Lookup does not make sense as one Lookup will already return a single record.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
diego_marino Helper III
Helper III

Re: problem on lookup on three tables

thanks so what you suggest? maybe i should cut distance by storing th ComuniID in the calendar and then use lookup?

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,689)