Unable to Get Lookup name

(0) Share

Report

Posted on by O365BSD

Data Sources:

Devices
Device License Plates

Unable to get lookup name.

Getting Error:

Delegation warning: The Lookup part of this formula might not work correctly on large data sets.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

WarrenBelz 155,554 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @O365BSD ,
Yes, complex field types are not Delegable Filters
LookUp( 'Device License Plates Registration Number' = Thisltem.Device.'Device License Plates', 'Registration Number' )
the problem is Device.'Device License Plates'
What type of field is Device in your data set?

Was this reply helpful? Yes No
NeerRaw 6 on at

Like (0)

Report
Copy link

Link copied!

Maybe I'm not understanding the data, but I don't think delegation is the problem, just a smoke screen. It looks like you want to return the registration number of a device based on the license plate. I think your function is looking for the registration number to match the license plate number, and none of them would match, so it is just constantly returning blank.

Was this reply helpful? Yes No
O365BSD 20 on at

Like (0)

Report
Copy link

Link copied!
@WarrenBelz The datasource Connection is CDS, These are three entities, I am using custom view in a gallery list.
Device
Device License Plates
Logistics
Lookup of 'Device License Plates' is in the Device Entity.

LookUp('Device License Plates', 'Registration Number' = "XYZ" ,'Registration Number') -->Fpr Static value its working perfectly but in case of dynamics lookup value
LookUp('Device License Plates','Registration Number' = ThisItem.Device.'Device License Plates','Registration Number')--> For this case, can't access the name of the lookup which is equal to "XYZ"
The field 'Registration Number' is unique identifier of Entity 'Device License Plates'

Other than creating view it there any other way to manipulate fields of more than one related Entities

Was this reply helpful? Yes No
WarrenBelz 155,554 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

OK @O365BSD ,
You did not mention this in your post and I responded as this appeared to be a SharePoint issue. I am not a CDS user, so will tag one of my colleagues @PowerAddict who may be able to assist.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thanks @WarrenBelz.

@O365BSD, just to make sure I understand this code works?
LookUp('Device License Plates', 'Registration Number' = "XYZ" ,'Registration Number')

And this doesn't?
LookUp('Device License Plates','Registration Number' = ThisItem.Device.'Device License Plates','Registration Number')

Questions:
1. Where is this above code? Is it inside a gallery?
2. Do you get any errors or do you just not get anything returned?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
O365BSD 20 on at

Like (0)

Report
Copy link

Link copied!

@PowerAddict

Yes, It is insight gallery
I am trying to get the name of the loopup field to display in the list but it doesn't work

ThisItem = LogisticsEntity
Device = DeviceEntity its lookup in the Logistic Entity
Device License Plates = It is the lookup field in the Device
LookUp('Device License Plates','Registration Number' = ThisItem.Device.'Device License Plates','Registration Number')

if i use only this expression to get lookup GUID it display error of expecting text value
ThisItem.Device.Device License Plates

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Before we go further, for the error message you attached, try this:

ThisItem.Device.'Regarding number plate'.'Registration Number'

Also, in your App Settings, see if the following setting is checked, if it is, then uncheck it:

Explicit column selection

Let me know the answers to these and we can take this further.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
O365BSD 20 on at

Like (0)

Report
Copy link

Link copied!

@PowerAddict
i unchecked the Explicit column selection option in advance setting & using the following expression but getting error messesge.

Multiple levels of Many-to-One relationship expension are not supported.
here is the expresson.
ThisItem.Device.'Regarding number plate'.'Registration Number'

For the testing purpose i tried to get other lookup which are in Device entity but can't get lookup name.I think its a Syntex problem.
But if its working in the case of simple field like text or datetime.

ThisItem.Device.'other text field' =>its working fine..
ThisItem.Device.'lookup field' => its not work 😞

Was this reply helpful? Yes No