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

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

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
Skilled Sharer
Skilled Sharer

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,796)