I will try to outline my issue as best I can so bear with me. I have seen many related posts, but have yet to find one that helps or covers exactly what I am trying to do. I am developing an app that will be used to conduct meter readings at a local camp ground each month. I have created a few sharepoint lists two of them being Meters and Meter Readings. Meters is a list of the meters on the property along with the Lat/Long coordinates as well as columns for notes and images in case of damage or another issue. The Meter Readings list has columns for meter name, the value of the reading, the date of the reading, and an image of the reading in case of disputes with residents.
My issue is that in the meter readings list, the MeterName column is a lookup to that meter in the meter list. What I need to do is access the meter name from a galler or text box etc. When i try to do this, it returns the record like normal. My question is how can I get the text value of the row rather than the reference to a record. In my gallery what i want to do is something Like:
ThisItem.MeterName ( if you use ThisItem.MeterName. you get the options of ID or Value neither of which are what i need. )
This returns the record for a meter rather than the text value of that meter name. Is there any way to do this? I am going to attach some images to show the lists in case my explination wasnt clear. Thank you in advance!
