I have a navigation that's a gallery (Gallery4) and a dataTable (DataTable6). I am trying to filter the dataTable when an item is clicked in the gallery. I tried the following but I get a squiggly red line under the formula.
'Request Status' is the column name in the DataTable.
The gallery's datasource is a collection called requestStatus.
Filter(DataTable6, DataTable6.Selected.'Request Status' = Gallery4.Selected.Value)
What am I doing wrong?
Thanks for responding.
Sorry, I had changed the datasource from a list to a collection. The collection looks like this.
I will modify the question to reflect his.
I recreated it in another environment and used the name 'Project Status'. I don't get any errors but the filter doesn't work either. See below:
Project Status in SharePoint is a choice column. Not sure if that makes a difference.
So many events that are happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.