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

Why are columns case sensitive?

So, clearcollect(somecoll,{a:"1"}, {"A:"2"}) will give me two columns. Why are they case sensitive?

 

Selecting somecoll.A in for example a listbox gives different items than somecoll.a 

1 REPLY 1
Super User III
Super User III

Hi @agneum


Your example highlights how case sensitive column names can be awkward to work with.  At worst, this behaviour can make it easier to introduce bugs into apps. It might be worth raising the idea of case insensitive column names as a suggestion in the ideas forum to gauge what others think.  

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Although I don't know the reason why column names are case sensitive, my guess is this.

As you might be aware, this type of syntax expresses a data construct in JSON format:

{a:"1"}

When PowerApps passes this data between the browser and any server-side service layers, it probably needs to adhere to JSON-RPC standards which mandate case-sensitivity.

https://www.jsonrpc.org/specification#conventions

 

"All member names exchanged between the Client and the Server that are considered for matching of any kind should be considered to be case-sensitive."

Because of this, and the fact that the browser based client is built with JavaScript (a case sensitive language), it was probably easier for Microsoft to make all of these data objects case sensitive, rather than engineer case-insensitivity on top of a platform that's inherently case-sensitive. Just for info, it's also worth noting that any variables that you create with Set and UpdateContext are also case sensitive.

Hopefully, someone from Microsoft can provide a more accurate and official explaination.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (73,719)