Unanswered

Filter datatable with gallery selection

(0) Share

Report

Posted on by theisogunro

272

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

item property of Data Table:
Filter(DataSource,'Request Status'.Value=Gallery4.Selected.'Request Status'.Value)

Example:

Was this reply helpful? Yes No
theisogunro 272 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

DataTable Item Property:
Filter(DataSource,'Request Status'.Value=Gallery4.Selected.Value)

Was this reply helpful? Yes No
theisogunro 272 on at

Like (0)

Report

For some reason it's not working

Was this reply helpful? Yes No
theisogunro 272 on at

Like (0)

Report

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.

Was this reply helpful? Yes No