Lookup error -This formula uses scope, which is not presently supported for evaluation

(0) Share

Report

Posted on by WebPortal

2,297

My app is connected to 2 sharepoint lists: Contactos and Entidades

I have a gallery whose "Items" property is Contactos, and it works fine.

But, I need to lookup the name of the entity in the "Entidades list", so the "Text" property of the label I'm trying to create is:

LookUp(Entidades, ID1 = ThisItem.ID_Entidade)

This makes a lot of sense to me and I'd expect to work without any issues.

However:

"Lookup error -This formula uses scope, which is not presently supported for evaluation"

I have no idea what this means and what the lookup is supposed to do..

Any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@WebPortal

You are referring to the formula editor information. The Formula editor cannot evaluate a value that uses a scope such as Gallery. So, in other words, if you have a label with ThisItem.Name (for example) in the Text property of the Label, when you click on that in the formula editor, it will give you that message because it has no idea what ThisItem is...ThisItem is in the scope of the Gallery so it cannot evaluate it. If it could, which record would it show?

However, I am guessing that you are drawn to this because you are not getting what you want in your Label Text property. This is because you are setting the Text property to a record...this will not work. You need to specify which column of your record you want to be displayed in the text.

So for example, if Name was a column in your datasource and that is what you wanted to display, then this is what you want:

LookUp(Entidades, ID1 = ThisItem.ID_Entidade, Name)

I hope this is helpful for you.

Was this reply helpful? Yes No
WebPortal 2,297 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes

Thank you so much! Now it makes sense that I was missing what field I need to extract from the record (it is Desingação), so this expression worked:

LookUp(Entidades,ID1 = ThisItem.ID_Entidade).Designação

Was this reply helpful? Yes No
ankurvadher 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you ! it works

Was this reply helpful? Yes No