Answered

Add Columns, Sort, and Filter

(0) Share

Report

Posted on by CDev_83

Hi friends.

I can get each of these to work individually in the items setting of my gallery, however I am having trouble when trying to nest them.

This works to SORT on the gallery but not filter:

SortByColumns(
 AddColumns(
 ReportDeliveryCustomerGroups,
 "MainCustomerName",
 'Main Customer Name'.Value
 ),
 "MainCustomerName",If(SortDescending2,Descending,Ascending)
)

This works to FILTER on the gallery but not sort:

If(
 IsBlank(CustomerCombobox_2.Selected.Value),
 ReportDeliveryCustomerGroups,
 Filter(
 ReportDeliveryCustomerGroups,
 Customer.Value = CustomerCombobox_2.Selected.Value
 )
)

The closest I can come to not getting angry red lines everywhere is this:

SortByColumns(
If(
 IsBlank(CustomerCombobox_2.Selected.Value),
 ReportDeliveryCustomerGroups,
 Filter(
 ReportDeliveryCustomerGroups,
 Customer.Value = CustomerCombobox_2.Selected.Value)
 ),
AddColumns(
 ReportDeliveryCustomerGroups,
 "MainCustomerName",
 'Main Customer Name'.Value
 )
"MainCustomerName"
)

but it's just not working. I've been putting commas and parentheses in different spots and I'm just going in circles. Please help me fix this silly thing.

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@CDev_83

Rearranging a bit.

With({_items:AddColumns( ReportDeliveryCustomerGroups, "MainCustomerName", 'Main Customer Name'.Value ) }, SortByColumns( Filter(_items, IsBlank(CustomerCombobox_2.Selected.Value)|| Customer.Value = CustomerCombobox_2.Selected.Value ),"MainCustomerName",Ascending ) )

Was this reply helpful? Yes No
CDev_83 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! I don't really ever use the "with" function, I appreciate the help

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@CDev_83

I like it because it makes the code so much easier to understand the logic, it doesn't slow down the processing of the code and unlike collections or variables, it only exists during the execution of the code. I sometimes used to get lost in my own code when I went back to it months later. I find this really helps.

Was this reply helpful? Yes No