Nested functions syntax help

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone. Need help with nested functions. When I pull in a gallery using the following formula:

Sort(GroupBy(DepotPlacedOrders,"Part","DATA"),Part,Ascending)

I get exactly what I need. I am trying to turn it into a collection and add date pickers. When I use this formula

ClearCollect(colRollup,Filter(Sort(GroupBy(DepotPlacedOrders,"Part","Created","DATA"),Part,Ascending),(Created>=dpStartRollup.SelectedDate Or IsBlank(dpStartRollup.SelectedDate)) And (Created<=DateAdd(dpStopRollup.SelectedDate,1,Days) Or IsBlank(dpStopRollup.SelectedDate))))

Its ALMOST perfect, it just does not group by the column "Part" . Everything else appears to work correctly. The date picker works properly.

Any help would be appreciated!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous

Please try the following,

ClearCollect( colRollup, GroupBy( Sort( Filter( DepotPlacedOrders, ( Created >= dpStartRollup.SelectedDate Or IsBlank(dpStartRollup.SelectedDate) ) And ( Created <= DateAdd( dpStopRollup.SelectedDate, 1, Days ) Or IsBlank(dpStopRollup.SelectedDate) ) ), Part, Ascending ), "Part", "Created", "DATA" ) )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@CNT Thank you for the quick reply. I am seeing the same thing on the gallery with this code. Its repeating items in the parts column still.

Ultimately Im trying to get the number of items sold for each item in the parts column.
Chris

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous

Please try the following. Items Sold will have the count you need.

ClearCollect( colRollup, AddColumns( GroupBy( Sort( Filter( DepotPlacedOrders, ( Created >= dpStartRollup.SelectedDate Or IsBlank(dpStartRollup.SelectedDate) ) And ( Created <= DateAdd( dpStopRollup.SelectedDate, 1, Days ) Or IsBlank(dpStopRollup.SelectedDate) ) ), Part, Ascending ), "Part", "DATA" ), "Items Sold", CountRows(DATA) ) )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@CNT That works perfect, thank you very much for your help!!

Chris

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Glad to help!

Was this reply helpful? Yes No