cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
theisogunro
Helper IV
Helper IV

Filter datatable with gallery selection

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.

 

ClearCollect(requestStatus,

"Awaiting Assignment",

"Pending",

"In Progress",

"Complete"

);

 

Filter(DataTable6, DataTable6.Selected.'Request Status' = Gallery4.Selected.Value)

 

What am I doing wrong?

 

 

 

 

5 REPLIES 5
zmansuri
Super User
Super User

item property of Data Table:

Filter(DataSource,'Request Status'.Value=Gallery4.Selected.'Request Status'.Value)

 

Example:

a.jpg

Thanks for responding.

 

Sorry, I had changed the datasource from a list to a collection.  The collection looks like this.

 

ClearCollect(requestStatus,

"Awaiting Assignment",

"Pending",

"In Progress",

"Complete"

);

 

I will modify the question to reflect his.

 

DataTable Item Property:

Filter(DataSource,'Request Status'.Value=Gallery4.Selected.Value)

For some reason it's not working

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:

 

theisogunro_0-1624986176893.png

 

Project Status in SharePoint is a choice column.  Not sure if that makes a difference.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,141)