Unanswered

Display all items in gallery

(0) Share

Report

Posted on by lumos

114

Hello!
I have a gallery but the gallery didnt display all my items unless i filter my date combo box . i want the gallery to display all items even though the gallery isnt filtered. Below is my existing code

Sort(
 Filter(
 coldata,
 IsBlank(cbxmeetingforum.SelectedItems) || IsEmpty(cbxmeetingforum.SelectedItems) || NewMeetingType in cbxmeetingforum.SelectedItems,
 IsBlank(datemeetingdate.SelectedDate) || ThisRecord.MeetingDate >= datemeetingdate.SelectedDate, ThisRecord.MeetingDate < datemeetingdate.SelectedDate + 1

 ),
 
 
 "Meeting Date",
 SortOrder.Descending
)

Thank you in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @lumos ,
The issue with your code is that it filters the data (coldata) based on the selection in the cbxmeetingforum dropdown and the datemeetingdate datepicker control. To show all items even when nothing is selected, you can modify the first Filter function.

Sort( Filter( coldata, /* Check if no meeting type is selected from dropdown */ IsBlank(cbxmeetingforum.SelectedItems) || IsEmpty(cbxmeetingforum.SelectedItems) /* OR */ /* Meeting type selected from dropdown matches this record's NewMeetingType */ NewMeetingType in cbxmeetingforum.SelectedItems, /* No date selected in datepicker OR meeting date is on/after selected date */ IsBlank(datemeetingdate.SelectedDate) || ThisRecord.MeetingDate >= datemeetingdate.SelectedDate ), "Meeting Date", SortOrder.Descending )

Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lumos ,

Please try this.

If(IsEmpty(cbxmeetingforum.SelectedItems)&&IsBlank(datemeetingdate.SelectedDate),Sort(coldata, "Meeting Date", SortOrder.Descending ),Sort( Filter( coldata, IsBlank(cbxmeetingforum.SelectedItems) || IsEmpty(cbxmeetingforum.SelectedItems) || NewMeetingType in cbxmeetingforum.SelectedItems, IsBlank(datemeetingdate.SelectedDate) || ThisRecord.MeetingDate >= datemeetingdate.SelectedDate, ThisRecord.MeetingDate < datemeetingdate.SelectedDate + 1 ), "Meeting Date", SortOrder.Descending ))

Best regards,

Rimmon

Was this reply helpful? Yes No
lumos 114 on at

Like
a
(0)

Report
Copy link

Link copied!

it doesnt work but is it possible that the root cause is because in my combobox for date in DefaultDate is Today()?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lumos ,

If the date picker has default date, the below formula returns false.

IsBlank(datemeetingdate.SelectedDate)

I recommend you set the default date to blank and test again.

Best regards,

Rimmon

Was this reply helpful? Yes No
lumos 114 on at

Like
a
(0)

Report
Copy link

Link copied!

i already did but the combo box displays unrelevant date and the gallery still didnt display every items

Was this reply helpful? Yes No
lumos 114 on at

Like
a
(1)

Report
Copy link

Link copied!

i change AND to OR FOR IsEmpty(cbxmeetingforum.SelectedItems) || IsBlank(datemeetingdate.SelectedDate), This condition ensures that If datemeetingdate.SelectedDate is blank, the condition is true (all items should be included regardless of their MeetingDate).If datemeetingdate.SelectedDate is not blank, it checks if ThisRecord.MeetingDate is within the selected date range.Using || allows the filter to pass if any of the conditions are true, thus including items that meet any of the filter criteria.

Thank you for helping

Was this reply helpful? Yes No
lumos 114 on at

Like
a
(0)

Report
Copy link

Link copied!

i was wrong, it doesnt work actually , when i change it to OR, the gallery is able to display all items but the combo box cannot filter the gallery

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lumos ,

Have you tried method in my first reply? Use If function to show all items when combo box is empty and date picker is blank.

Best regards,

Rimmon

Was this reply helpful? Yes No
lumos 114 on at

Like
a
(0)

Report
Copy link

Link copied!

i think the If function return false because my date picker isnt blank, but in the item property of my date picker is also blank

Was this reply helpful? Yes No