Hi, I'm new to power pages, and I want to show properties of an entity where one of the fields is equal to the signed in contact's id.
So my table is staffmember (staffmembers) and it has a property parkingplace
The staffmember row is linked to the contact using a lookup column
So I want to show the parkingplace property of the staffmember entity where the contact is the contactid of the signed in user
I have the following code in my snippet, but it doesn't work
{% if user %}
<h1>{{user.fullname}}</h1>
{% for sm in entities.staffmember[{{user.contactid}}] %}
<h2>{{sm.parkingplace}}</h2>
{% endfor %}
{% endif %}