You’re offline. This is a read only version of the page.
I'm trying to:
- Pull two columns from a table,
- Filter a column "crd2e_toola" by a separate value "crd2e_prefix"
- Count the occurrences of all remaining values in column "crd2e_toola"
- Sort the remaining values from most to least common
- Return the sorted distinct values to use in a drop down box
Having trouble getting this to work, and I feel like it's something simple I'm missing. Thank you!
Hi @jfsrc ,
You are missing the grouped column in GroupBy.
Share
Report
All responses (
Answers (
155,752
ClearCollect(
toola_list,
SortByColumns(
AddColumns(
GroupBy(
ShowColumns(
Filter(
jareds_sandboxes,
prefix = lbl.Selected.Value
),
"crd2e_prefix",
"crd2e_toola"
),
"crd2e_prefix",
"Data"
),
"toolcounted"
CountRows("Data")
),
"toolcounted",
Descending
)
)Also, can you please remember to post your code in Text as it saves re-typing here. This code is OCR'd, so please watch spelling.
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
