Unanswered

PowerApp Issue Reporting Error "The function Average cannot be used with an empty table"

(1) Share

Report

Posted on by ChiefofChief

Can anyone tell me how to fix this error in the Issue Reporting Tool in Power Apps: The function Average cannot be used with an empty table. It is displayed on the Issue Reporting dashboard.

Categories:

Error handling

I have the same question (0)

All responses (4)

Answers (0)

Guillaume42 11 on at

Like (0)

Report

I have the same issue, which makes me hesitant to use this in a user-facing environment.

Lost a couple of hours on this already, but I simply cannot find any use of the Average function anywhere in the app.

Please fix asap

Was this reply helpful? Yes No
Guillaume42 11 on at

Like (0)

Report

Follow-up: I have spent my morning on this app, and I strongly recommend against it. On top of the bug above (which seems to have existed for more than a year now), the crippling limitations and general awkwardness of PowerApps make it impossible to allow attachment of a useful screenshot - or any other file for that matter - to an issue.

Because when, by some kind of miracle, I got the app to display an "Attach picture" section (it's hidden by default), said picture is not visible in the planner, completely defeating the purpose.

More time wasted with microsoft's empty promises. Taken from the PowerApps page : "Make it easy for anyone to build apps for your teams and customers. Start for free with the Developer Plan to access user-friendly, low-code tools." I can't confirm the date of publication, but I would be surprised if it were not a 1st of April.

Avoid.

Was this reply helpful? Yes No
LeFlair 20 on at

Like (0)

Report

You can build a flow to add exactly these images in Planner. I have implemented this myself, it works really well.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Adding-attachment-picture-option-to-the-Issue-Reporting-App/td-p/903014/page/3

Was this reply helpful? Yes No
MarKar 13 on at

Like (0)

Report
Yes, you have to mark as finished some tasks on Planner
otherwise the Filter function returns an empty table

varCompletionTimeAverage: If( CountRows( Filter( varTasksLast7Days, appPercentComplete = 100 ) ) > 0, Round( Average( Filter( varTasksLast7Days, appPercentComplete = 100 ), DateDiff( appTaskRecord.createdDateTime, appTaskRecord.completedDateTime, Days ) ), 0 ), 0 )

the work around is to check If the filter returns some rows otherwise you show 0

Marwen

Was this reply helpful? Yes No