Fetching Items Failed on Lookup but it is working, lots of notifications for users

[Anonymous]

I'm getting an error on a Lookup that is properly working and the users are getting lot of error notifications when load the page, try to convert types but without success.

Any idea on that? Print Attached

[WarrenBelz]

Hi @Anonymous ,

I cannot see your data, but logically you have two lookups

"Responsave1";
Lookup(
   'Atividades do Template';
    Atividade_ID=ID;
    ResponsavelpelaAtividade.Email
)

which works and

"Dependencia";
Lookup(
   'Atividades do Template';
    Atividade_ID=ID;
    Title
)

 which does not. The only difference is the reference to Title, rather than ResponsavelpelaAtividade.Email

You might have a look at that field as it must be the error.

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.

[Anonymous]

Thanks for the answer @WarrenBelz , but to give a little bit more context, I got the mentioned error on the code attached, and when I try to verify this specific Lookup is red underlined seems that where is the problem

Specific Error Line Highligthed by the Verification

So to give more context, below the data where I have ID from 'Atividades do Template' and Atividade_Dependente_ID from 'Executar Atividades Geradas' being compared on the Highlighted LookUp that the Verify is saying where the execution error comes from.

I'm using the same code to populate other components, and even the error is showed when executed, they are working still...

Data from List ' Atividades Template'

Data from List ' Executar Atividades Geradas'

I appreciate the help with this!

[WarrenBelz · Accepted solution]

Hi @Anonymous ,'

The red line actually indicates it is valid - it is under a control reference that PowerApps can access. The "squiggly" red lines are the error and I can see the issue. Your table 'Atividades do Template' does not have a Title field - it is over in 'Executar Atividades Geradas', which is not referenced in the Lookup, so 

"Dependencia";
Lookup(
   'Executar Atividades Geradas';
    Atividade_Dependente_ID=ID;
    Title
)

would be valid, assuming the ID is correct.

Without seeing your logic, it is a bit hard to comment on whether the result is what you need.

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.

[Anonymous]

So I really can't understand why it gives the error, but following your last idea, I just remove the LookUp for "Depedencia" Column, and now its is ok, still working without the error message.

Thanks for your time! @WarrenBelz