You’re offline. This is a read only version of the page.
Announcements
47
I'm trying to do something which should be very simple but I can't get the syntax right. I have a canvas app gallery connected to a sharepoint list. The list has the following columns: Client, Supply Item, Qty, Supply Shipped.
Forget the Supply Item and Qty columns for now. I simply want to display a vertical gallery that filters based on Supply Shipped = "No" and group the gallery by Client, and sort by Client asc. I can't figure out how to use GroupBy, Filter, and Sort in one formula for the Items property of the gallery. Any ideas?
Hi, @Rahul320
I have an idea for this:
Share
Report
All responses (
Answers (
Sort(
GroupBy(
Filter(
TuyenDemoDS,
Supply_Shipped = true
),
"field_2",
"GroupByName"
),
field_2,
SortOrder.Ascending
)Step 1: I filter my collection with return a table based on my condition:
Step 2: I group by this table and return other table below with group col name GroupByName:
Step 3: I sort table after group by:
Best regards,
Tuyen
