cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mcollins Resolver I
Resolver I

Is it possible to access data fields that come from a LookUp within a LookUp?

Bit of a confusing question here.....I know. Let me explain my scenario as I'm currently stumped on how to access the specific data I am looking for. 

 

**PLEASE LOOK AT IMAGE ATTACHMENT FOR REFERENCE**

 

This Assignments app filters Data to only show technician assignments that are associated with a specific technician, utilizing their AzureAD email. 

 

Filter('FCO Assignments', cr4c8_technicianemail=ThisUser.altEmail)

 

However, some of the missing fields within the Gallery come from entity relationships that pertain to Work Orders, and is dynamic based on the workorderID that is associated with that Gallery item. 

 

I have 3 levels of Entity relationships - (FCOAssignments --> FCOWorkOrders --> FCOCustomerSites)

 

In this App, I'm trying to access the 'sitename' of the FCOCustomerSite LookUp Field within the Work Order(FCOWorkOrder) Entity. 

 

The code I'm trying to use to access this data is :

LookUp('FCO Work Orders', _workorderguid=ThisItem._workorderid)._FCOCustomerSite._sitename

 

which searches for the correct WO based on the workorderguid and return the sitename from the CustomerSite LookUp Record that's associated with that WO. 

 

This LookUp function has no errors, but none of the correct data comes through. 

 

So my question is.......Is this even possible? Can I transcend that many levels and still receive data?

 

I've tried to think of other ways that I could potentially create a collection on start with the necessary data, but nothing has panned out due to the dynamic nature of the workorderID's from the Gallery.

 

Any help is greatly appreciated!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Is it possible to access data fields that come from a LookUp within a LookUp?

Hi @mcollins,

 

Do you want to access data fields from a LookUp column which references value from another LookUp column in different entity?

 

I have made a test on my side, if you want to access data fields from a LookUp column which references value from another LookUp column in different entity within your app, I afraid that there is no way to achieve your needs in PowerApps currently.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Is it possible to access data fields that come from a LookUp within a LookUp?

Hi @mcollins,

 

Do you want to access data fields from a LookUp column which references value from another LookUp column in different entity?

 

I have made a test on my side, if you want to access data fields from a LookUp column which references value from another LookUp column in different entity within your app, I afraid that there is no way to achieve your needs in PowerApps currently.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Users online (6,224)