cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SudhirSingare
Level: Powered On

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
Super User
Super User

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

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

2 REPLIES 2
Super User
Super User

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

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

mogulman
Level 8

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

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. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,775)