Adding value from map layer to label in print layout with expression

Question

I would like to add value from layer “X” field “Y” with ID “1” to the label in my print layout with expression.

I don’t want to use atlas generator because I want this to be 1 layout with all of the data. Let’s say a kind of schematics.

I tried may expressions but nothing work. I will add that i’m not that advanced in writing expressions in qgis.

At this point I think that it is not possible. Somebody please help.

Answer 1

this can be achieved with the get_featureand attribute functions:

attribute(get_feature('X','ID',1), 'Y')

get_featurewill get the feature in layer Xwith the value 1in field ID and attributewill get the value of this feature in the column Y.