Filter not working with CDS

[Belasor]

Hi,

Actually I´m trying to filter values from a Comon Data Service Table with the selected Value from a gallery. However it is not working. Rooms.Building is a table and I think the issues lays here.

Thanks in advance

[eka24]

Try remove Rooms.Building and make it Building.

Also Can you give further explanation?

Are filtering a Gallery from another Gallery

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-siky-msft · Accepted solution]

Hi @Belasor ,

Filter function evaluates each record of table, so the right syntax of Filter function should be like this.

Filter('TableName', ColumnName= "Value")

Please try to modify your code as follows:

GroupBy(Filter(Rooms; Building=Gallery3.Selected.Name);"new_floornumber";"Floors")

Hope this helps.

Sik