LOOKUP ID FROM A COLLECTION

(0) Share

Report

Posted on by YamiteKudasai

195

Hello Everyone,

Good day!

I have a question. I want to get the ID from a collection. I'm using the code below.

LookUp('Data Source', ID = LookUp(colRequestLeaders, ThisItem.ID = Request.Id).'Service Region Market'.Id).'PPL Leader'.DisplayName

But I'm having a delegation warning. Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 152,851 Most Valuable Professional on at

Like (0)

Report
Re: LOOKUP ID FROM A COLLECTION

Hi @YamiteKudasai ,

Try this

With( { wID: LookUp( colRequestLeaders, Request.Id = ThisItem.ID ).'Service Region Market' }, LookUp( 'Data Source', ID = wID.Id ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

Re: LOOKUP ID FROM A COLLECTION

Hello sir @WarrenBelz , still having delegation warning in wID part.

Was this reply helpful? Yes No
WarrenBelz 152,851 Most Valuable Professional on at

Like (0)

Report
Re: LOOKUP ID FROM A COLLECTION

Hi @YamiteKudasai ,

Try the below, but if it does not work, there is no way of doing a Delegable query with your structure as this is a Relational Query and SharePoint is not a Relational Database

With( { wID: LookUp( colRequestLeaders, Request.Id = ThisItem.ID ).'Service Region Market'.Id }, LookUp( 'Data Source', ID = wID ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 152,851 Most Valuable Professional on at

Like (0)

Report

Re: LOOKUP ID FROM A COLLECTION

Hi @YamiteKudasai ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No