Dashboard list expression - Fields not available "Invalid property identifier"

[David_Tipping]

Hi - In dashboard I am trying to build a list expression to display bathing water quality. The data is from an AGOL Feature Layer (hosted view) and is in a related table showing latest records only. 

The table has many fields containing tidal information, beach usage as well as analysis values for Escherichia Coli and Intestinal Enterococci which are added when the lab analysis is complete. These 2 fields are small integer fields and would typically have values between 3 and maybe 250.

My currently working list shows the symbology, Beach name, sample date and time as well as the actual values for Escherichia Coli and Intestinal Enterococci - as shown. 

I want to add an Arcade expression that uses the same coli values to create a "Bathing water condition" like I have created for the symbology that equate to Excellent ***, Good** or Poor (no stars). When I come to use the fields already displaying coli values above, they are just not available in the selection list in Advanced Formatting and if I manually enter them, I get an "Invalid property identifier" error as shown below:

So they work for simple lists but not available in Arcade for advanced formatting. 

Does anyone have ideas why this is so?

Thanks

David Tipping 

[jcarlson · Accepted solution]

I don't see why those fields would be giving you trouble, but sometimes dot notation doesn't work. I prefer using brackets to access field values.

Try $datapoint['EscherichiaColi'], does that behave any differently?

[David_Tipping · Accepted solution]

Bingo - It works

Thank you so much for you help - star 👍

Will communicate with the other post

Many thanks

David Tipping

[David_Tipping]

Thanks Josh - Your solution worked a treat 👍