cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SudhirSingare
Advocate I
Advocate I

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

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 ?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @SudhirSingare

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

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

View solution in original post

3 REPLIES 3
timl
Super User
Super User

Hi @SudhirSingare

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

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

mogulman
Impactful Individual
Impactful Individual

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. 

tayostephen
New Member

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

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,850)