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

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @vribeiro ,'

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.

View solution in original post

4 REPLIES 4
WarrenBelz
Super User
Super User

Hi @vribeiro ,

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.

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 VerificationSpecific 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 ' Atividades Template'

 

Data from List ' Executar Atividades Geradas'Data from List ' Executar Atividades Geradas'

 

I appreciate the help with this!

 

Hi @vribeiro ,'

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.

View solution in original post

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 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,721)