list advance formatting based on value from another layer

[DionysiosKerasidis1]

Hi Community

May i please ask for a suggestion/advice. i am trying to create a list with advanced formatting which will read 2 layers and colour code the records based on if a record from one table found in the other one.

In other words, i have created a field app which captures data on site and i have a lookup table, need to compare if an ID is found from the lookup table and colour it green as an example.

[jcarlson · Accepted solution]

The Arcade profile for advanced formatting in a list is limited to only looking at a single feature's attributes at a time.

The only way to join data from separate layers like that is to use a Data Expression.

[DionysiosKerasidis1]

Thanks Josh 

i was expecting that would be the case.