Unanswered

Display Default Value of Gallery

(0) Share

Report

Posted on by nayem

Hai, i have a question, im looking for this solution almost a week and cant find an answer for this. Please help me.

My gallery code:
Sort(
Filter(
ReportDetailsTable,
(StartsWith(StaffEmail, SearchInputBox.Text) ||
StartsWith(ID, SearchInputBox.Text)) &&
Status.Value = "Pending" &&
Category.Value = 'Dropdown category'.Selected.Value
),
Switch(
varSortColumn,
"SubmissionDate", 'Submission Date'
),
varSortDirection
)

my dropdown code:
Distinct(ReportDetailsTable,Category.Value)

The problem: I cant add "ALL" Value in the dropdown list, which will show all items = pending status only, in the gallery. Please help..

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nayem ,

In the Items of your drop-down

Ungroup( Table( {Data: Table({Value: "All"})}, { Data: Distinct( ReportDetailsTable, Category.Value ) } ), "Data" )

and your gallery Items

Sort( Filter( ReportDetailsTable, ( StartsWith( StaffEmail, SearchInputBox.Text ) || StartsWith( ID, SearchInputBox.Text ) ) && Status.Value = "Pending" && ( 'Dropdown category'.Selected.Value = "All" || Category.Value = 'Dropdown category'.Selected.Value ) ), Switch( varSortColumn, "SubmissionDate", 'Submission Date' ), varSortDirection )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
nayem 75 on at

Like
a
(0)

Report
Copy link

Link copied!

The code works very well!

But I tried to apply on check status page and the code i applied look like this:
Dropdown Code:

Ungroup(
Table(
{Data: Table({Value: "All"})},
{
Data:
Distinct(
ReportDetailsTable,
Status.Value
)
}
),
"Data"
)

Gallery Code:

Sort(
Filter(
ReportDetailsTable,
(
StartsWith(
ID,
SearchInputBox.Text
)
) ||
(

('Dropdown2_2'.Selected.Value = "All" && 'Created By'.Email = VarLoggedInUser) ||
('Dropdown2_2'.Selected.Value && 'Created By'.Email = VarLoggedInUser)
)

),
Switch(
varSortColumn,
"SubmissionDate",
'Submission Date'
),
varSortDirection
)

Somehow it did not show based on LoggedIn user, Please help.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@nayem ,

You do not have the field that Dropdown2_2 needs to match

Sort( Filter( ReportDetailsTable, StartsWith( ID, SearchInputBox.Text ) && 'Created By'.Email = VarLoggedInUser && ( 'Dropdown2_2'.Selected.Value = "All" || YourFileNameHere = Dropdown2_2.Selected.Value ) ), Switch( varSortColumn, "SubmissionDate", 'Submission Date' ), varSortDirection )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps