Unanswered

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

(1) Share

Report

Posted on by yit

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.

Categories:

Building Power Apps

powerAppsErrorPic...

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

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-using-enhanced-SQL-preview/m-p/388561

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/App-reading-from-an-Azure-SQL-DB-Weblink-is-not-working/td-p/160961

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,

Was this reply helpful? Yes No