App works in Test but fails on the Phone

[schneice]

Hi,

I've seen similar posts - but the suggested fixes do not seem to work for me.

My app works find in the test mode - but fail in the play mode or on a phone.

I receive this error:

"The requested operation is invalid. Server Response: The column 'gb_pumper' of the table wasn't found. inner exception: The column 'gb_pumper' of the table wasn't found."

I've traced it back to this gallalery item:

"Sort(GroupBy(lc_freez,"pumper","gb_pumper"),Sum(gb_pumper,delta),SortOrder.Ascending)"

Fixed I've tried:

1) Using "AddColumn"

2) Similar structure to create an additional collection vs doing it all in line

3) Setting the App settings to 

• Delay load - ON
• Explicit column selection - ON

Appreciate any help.

[v-monli-msft]

Hi @schneice,

First of all, please share more detailed information of this app. Like what are the included data sources' type and what are their names?

About this part of the formula:

Sum(gb_pumper,delta)

Is gb_pumper the name of a table? The syntax of Sum function should be:

Sum( Table, NumericalFormula )

Other involved functions' syntax should be:

Sort( Table, Formula [, SortOrder ] )

GroupBy( Table, ColumnName1 [, ColumnName2, ... ], GroupColumnName )

Regards,

Mona

[schneice]

Thanks for the reply

Table name is lc_freez.  It has 3 columns pumper (text), delta (dec), most_recent (dec).

As I understand it gb_pumper is a new table generated by the GroupBy function.

[schneice · Accepted solution]

I was able to solve the problem by using AddColumn and then dropping the "groupby" column.  Best I can determine, powerapps can run into trouble with some of the nested tables.

DropColumns(

AddColumns(

GroupBy(lc_freez,"pumper","gb_pumper2"),

"sum_delta2",Sum(gb_pumper2,delta),"sum_most_recent",Sum(gb_pumper2,most_recent)

)

,"gb_pumper2")