Power Platform Community Forum Thread Details

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!

Categories:

Microsoft Dataverse with Power Apps