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

All responses (5)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Example:
theisogunro 272 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

For some reason it's not working
theisogunro 272 on at

Like
a
(0)

Report
Copy link

Link copied!

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.