cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yit
Regular Visitor

The requested operation is invalid. Server Response: An identifier was expected at position 0.

My app was working last night, but today there are over 50 runtime errors with the same error:  "The requested operation is invalid. Server Response: An identifier was expected at position 0. inner exception: An identifier was expected at position 0....."

 

I have an Azure SQL Server backend and the problem seems to be primarily showing up in combo boxes and galleries dependent on SQL views, but I haven't checked every error yet. 

 

The published app is still functional, but the editor isn't happy.

 

I turned off the preview feature "Explicit column selection" and the errors went away.  Then I turned it back on and the errors returned. 

2 REPLIES 2
samdolphin
Frequent Visitor

Re: The requested operation is invalid. Server Response: An identifier was expected at position 0.

Same issue here, opened my app to countless run time errors this morning.  Disabling explicit column selection did the trick, but I would like to leave this feature enabled for performance reasons.  Hopefully this is fixed soon!

Community Support
Community Support

Re: The requested operation is invalid. Server Response: An identifier was expected at position 0.

Hi @yit ,

The user @Brian4 and @MisterMagoo has faced similar issue with you, please check the response within the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Problems-with-data-source-after-usi...

 

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/App-reading-from-an-Azure-SQL-DB-We...

 

When you turned on the "Explicit column selection" preview option, it would only fetch columns used in your published app from your data source, but when you edit your app, and try to reference other column values (not be referenced before) from your data source (e.g. SQL Table), this error would show up.

As an fixed solution, please consider turn off the "Explicit column selection" option within Advanced settings of App settings of your app.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (830)