I have two layers, one being a manhole layer and the other a gravity main layer. I need to get the asset number from the manhole layer into the gravity main layer. On the gravity main layer I have a field "From_Manho" which contains an ID, that same ID exists on the manhole layer under the name "Facility_I". In my head, I'm thinking I can make an expression using the ID fields to extract the associated asset number. I came across this question but I wasn't able to get it to work.
This was my attempt at the expression:
attribute(
get_feature(
'ssManhole_642cc259_988d_404e_9458_9e5dc4f7b7b6',
Facility_I,
"From_Manho"
),
'Asset'
)