Answered

Power app works fine when i run from edit mode, but in user's run mode it gives errors ?

(0) Share

Report

Posted on by SudhirSingare

Getting this error when i directly open power app.

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

I am working with SQL server connection with multiple tables.

Also app takes more time to load when directly opned.

And when i run this from edit mode it works smoothly..

Shareing session Id from edit mode(Studio)

Session ID: d4a79c62-e28d-400a-8e94-7eb2efed4fe5
PowerApps 3.18114.25

Session ID When directly opened in browser:
Session ID: 037cceca-7db6-481e-8535-fb31d5d13e52
PowerApps 3.18114.16

Can you suggest any ways to debug this ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SudhirSingare

Do you have 'Explicit Column Selection' turned on? If so, could you try disabling this option?

If that doesn't work, I'd also disable 'Delayed Load' to see if that makes a difference.

Was this reply helpful? Yes No
mogulman 764 on at

Like
a
(1)

Report
Copy link

Link copied!

I had a weird problem a few weeks ago. PowerApps was running inconsistently on Edge. I solved it by clearing the Edge cache, restarting Powerapps and republishing the latest version.

Was this reply helpful? Yes No
tayostephen 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I cleared my browser cache, and it solved the problem.

Was this reply helpful? Yes No