Unanswered

Filtering Gallery

(0) Share

Report

Posted on by Pixel20

Hi Users,

I need help, please. I am trying to filter a gallery based on response, but I already added 2 drop down filters. I need to add this to complete a patch formula that would filter out by responses Filter('App', 'Corrected'=false) but I am not sure how to add it to what I already have.

This is what I have so far,

If
//This is for all and all//
(DDAisle.Selected.Value = "--All--" And DDSupervisor.Selected.Value = "--All--", 'Audit',

//This is for all aisles and selected supervisors//
DDAisle.Selected.Value = "--All--" And DDSupervisor.Selected.Value <> "--All--",
Filter ('Audit','Supervisor Assigned'.DisplayName = DDSupervisor.Selected.Value),

//This is for selected aisles and all supervisors//
DDAisle.Selected.Value <> "--All--" And DDSupervisor.Selected.Value = "--All--", Filter('Audit', 'Aisle for App'=DDAisle.Selected.Value),

//This is for selected aisles and selected supervisors//
DDAisle.Selected.Value <> "--All--" And DDSupervisor.Selected.Value <> "--All--",
Filter('Audit', 'Aisle for App'=DDAisle.Selected.Value And 'Supervisor Assigned'.DisplayName = DDSupervisor.Selected.Value))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@Pixel20 - irrespective of whichever filtered output is returned from your conditions, I assume you want to filter the final output where the "Corrected" field = false?

Assuming the "Corrected" field is a Yes/No data type, and your data source is SharePoint, try the below:

Filter( With( {_all_data: 'Audit'}, With( { _all_aisles_selected_supervisors: Filter ( 'Audit', 'Supervisor Assigned'.DisplayName = DDSupervisor.Selected.Value ) }, With( { _selected_ailes__all_supervisors: Filter( 'Audit', 'Aisle for App' = DDAisle.Selected.Value ) }, With( { _selected_ailes__selected_supervisors: Filter( 'Audit', 'Aisle for App' = DDAisle.Selected.Value And 'Supervisor Assigned'.DisplayName = DDSupervisor.Selected.Value ) }, If //This is for all and all// ( DDAisle.Selected.Value = "--All--" && DDSupervisor.Selected.Value = "--All--", _all_data, //This is for all aisles and selected supervisors// DDAisle.Selected.Value = "--All--" && DDSupervisor.Selected.Value <> "--All--", _all_aisles_selected_supervisors, //This is for selected aisles and all supervisors// DDAisle.Selected.Value <> "--All--" && DDSupervisor.Selected.Value = "--All--", _selected_ailes__all_supervisors, //This is for selected aisles and selected supervisors// DDAisle.Selected.Value <> "--All--" && DDSupervisor.Selected.Value <> "--All--", _selected_ailes__selected_supervisors ) ) ) ) ), !Corrected )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Pixel20 6 on at

Like (0)

Report

Hi yes, I am looking to filter where the final data output of the "Corrected?" field is false. I tried the input and it didn't seem to work.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

"didn't seem to work" is not very descriptive @Pixel20 - is there an error message for example?

Was this reply helpful? Yes No