I have a gallery in a canvas app that I want to filter with a field from an entity in CDS. My entity name is 'Quality Alerts', I'm trying to lookup the field 'Assigned To' and filter the gallery to show only records with the 'Assigned To' value that equals a label I have set off to the side of the gallery.
I have a label that shows the users name that I wish to filter the gallery with. However I have yet to find a way to successfully lookup that name through the field in the entity called 'Assigned To'. I've tried using functions like exactin or in to filter like I normally would with an excel sheet as a data source but no luck.
Filter('Quality Alerts', Label62.Text = 'Assigned To')
Any help would be much appreciated as I have several different instances I need to filter similarly.
I went back and changed the field name to Assigned that way I get rid of the space and changed the code to this,
Filter('Quality Alerts DBS', Assigned = Label62.Text)
This gave me the result I wanted.