Conditional Text Formatting in Operations Dashboard List
%20-%20Copy.png "JasonCyphers"){kind=avatar}
Hi Jason,
You can join your layer and your table to create a dynamically updating feature layer view layer. In this way, as each of the sources update, the view layer updates.
You can perform the join using the Analysis tool in the Map Viewer. Follow the steps outlined in this doc, making sure to check the box at the end to create a feature layer view.
Create results as hosted feature layer view allows the data to stay up-to-date as the source data changes. Hosted feature layer views containing joins will be read-only and do not consume credits for analysis and storage. Creating results as a hosted feature layer view is only available for attribute joins. If statistics are included as part of the output, the hosted feature layer view will contain an extra table layer in the view with the statistics. Additionally when storing results as a hosted feature layer view Use current map extent is unavailable.
This layer is the feature layer view in the video. As can be seen in the item details, it is a result of joining two other layers.
I think you were able to figure out how to reference it in the HTML/CSS. Just don't forget the "#" if you are using hex colors.
<p style="color:{my_color_field}">My Text</p>
As for doing it via a related table, it might work in the pop-up but it is not supported in the List element at this time.
In the future, we will be providing a way for you to do conditional formatting right in the List via an Arcade expression.
All the best
I am able to add a related table with html color codes, and can format text color in the map pop up. Any way to replicate this in a dashboard list?
I can put the same html code into the list source, but don't get the formatting:
