Answered

Add a conditional GroupBy to ClearCollect.

(1) Share

Report

Posted on by emfuentes27

578

I'm trying to add a condition to GroupBy, but I get an error saying: The function GroupBy has some invalid arguments. Expected literal text. We expect literal text at this point in the formula. I really don't know what I'm missing. I'm trying to use something like this:

...
 GroupBy(
 Data,
 If(
 condition,
 "Column1",
 "Column2"
 )
 )
...

The code I'm using is this:

ClearCollect(
 reportsDataTypeByYear,
 AddColumns(
 SortByColumns(
 GroupBy(
 AddColumns(
 rawData,
 "ROValue",
 'Office'.Value
 ),
 If(reportTypeVar = "Count By Request Type And FY","fy", "Title"),
 "ROValue",
 "ROGroup"
 ),
 "ROValue",
 Ascending
 ),
 "TypeCount",
 CountRows(ROGroup)
 )
)

Thanks for any suggestion.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @emfuentes27,

I don't think this is currently possible within the input parameters of GroupBy. It expects a Text Literal - meaning a hardcoded string value that is not variable or conditional. Text variables, for example, lead to the exact same error.

Another way we could get this to work is by going to the parent function and trying to apply the If() there. Instead of using it within the GroupBy, we use it around the function:
ClearCollect( reportsDataTypeByYear, AddColumns( SortByColumns( If(reportTypeVar = "Count By Request Type And FY", GroupBy( AddColumns( rawData, "ROValue", 'Office'.Value ), "fy", "ROValue", "ROGroup" ), GroupBy( AddColumns( rawData, "ROValue", 'Office'.Value ), "Title", "ROValue", "ROGroup" ) ), "ROValue", Ascending ), "TypeCount", CountRows(ROGroup) ) )
This unfortunately results in some code duplication. Now by using a With() function and storing the AddColumns(rawData, ...) locally, you could remove the duplication partially.

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @LaurensM . Your solution is precisely what I was trying to avoid, but I guess there is no other way for now.

Was this reply helpful? Yes No