Filter Gallery from Dataverse Table Yes/No

[send2marky]

I have a column in a dataverse table that I want to filter my gallery with. It is a data type Yes/no and when it says Yes, I want them to show in the gallery and then sort by date.

[LaurensM · Accepted solution]

@send2marky please try the following structure in your gallery Items property:

Sort(Filter(DataSource, Roadmap= 'See explanation below'.Yes), 'Created On', Descending)

Explanation yes/no: this field will roughly be called 'Roadmap (tablename)'. You should be able to find it by searching on Roadmap in the code editor.

I used created on as the date field (Descending). You can adjust it to your case.

I hope this helps!