Unanswered

Offline error

(0) Share

Report

Posted on by andreFelipeLima

Hello,
I have the following problem, when I enter my application in offline mode automatically it tries to connect the database, in Excel case and displays an error message, but this does not influence the functionality of the application, but I would like to remove this message from error. Is there any exception handling or some way to hide this error? I also thought about disconnecting and reconnecting the database to avoid this very annoying message.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@andreFelipeLima
PowerApps errors cannot be hidden but you can try to manage them if they are caused by a formula. You would have to go into App Settings > Advanced Settings > Experimental Features and turn it on though.

Here's how another forum user was able to supress an error using Formula Level Error Management. Let me know if its useful:
https://powerusers.microsoft.com/t5/General-Discussion/Disable-the-red-error-message/td-p/52816

Also, here's the insanely detailed description on the Microsoft blog:
https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-databases/

And yes, sometimes weird errors go away by disconnecting/reconnecting the datasource. Was your app ever working without the error? If yes, what did you change in the app between then and now?

---
Please mark as Solution if this post answers your question to ensure others find it quicker. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @andreFelipeLima ,

Do you mean that the error message would show up when you set your app in Offline mode?

According to the error message that you mentioned, it seems that this issue is related to the Offline mode in your app. When your app is in Offline mode, your app would lost the connection to your Excel table.

I afraid that there is no way to get rid of this error within PowerApps currently. If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

If this issue occured by formula you used in your app, please consider turn off the "Formula-level error management" option within Advanced settings of App settings of your app, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
andreFelipeLima 6 on at

Like
a
(0)

Report
Copy link

Link copied!

It looks like powerapps automatically connects to the excel database. So when I'm in the offline version it accuses just that, it couldn't connect to excel. This message does not change the functionality of the application, but it is very bad for an application to issue an error message and it is working perfectly. My wish was to omit this, or send a custom message instead. Another interesting point is that when you create a blank application and connect to the database afterwards it does not give this error, but when you create an application from a base from excel the offline error appears, reinforcing my hypothesis that this connection to excel is made automatically. If I connect and disconnect the excel base manually I could handle it. IfError cannot handle this problem because it is not a formula and this connection is made internally.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@andreFelipeLima
Does your code check to see if the App is connected online using the formula Connection.Connected()? If you want the app to behave differently when offline you'll have to code it to do that. PowerApps does not do this automatically for you.

Link to documentation: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/signals

Was this reply helpful? Yes No
andreFelipeLima 6 on at

Like
a
(0)

Report
Copy link

Link copied!
My problem is that powerapps eventually connects to the excel database in offline mode, and I don't know where, how, and when it does so I can handle this problem.
APP CODE
If(Connection.Connected; ClearCollect(arrayPrincipal; principal);; SaveData(arrayPrincipal; "localPrincipal");LoadData(arrayPrincipal; "localPrincipal";true));; LoadData(arrayTemp; "localTemp";true)

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@andreFelipeLima
I'm sorry but I don't have any more to offer on this issue if my previous posts did not help. @v-xida-msft does not seem to think there is a way to do what you want. The best we can do is vote of on the Idea for now.

Was this reply helpful? Yes No