Answered

Getting columns name from a Collections - code posted before appears to not work anymore

(0) Share

Report

Posted on by subsguts

1,259 Moderator

The following code was supposed to get the names of the columns in a collection as posted previously. However, It won't work for my collection as shown below. Note, I had to add the JSONFormat.IgnoreUnsupportedTypes just to get it this far, but it is now complaining about "SubMatches". Any help is greatly appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

subsguts 1,259 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks to someone else who had a similar error message, I have figure out that the original code probably never worked. Because... drum roll... it has to have single quotes, not double quotes. That fixes the code.

I wonder if the double quotes used to work because the person who posted the original code and it is still in their blog usually knows there stuff. It was originally posted in 2022, so maybe PowerApps changed. I wouldn't think this was posted and used by people according to responses without anyone getting this error if this was not the case.

Hopefully this will save someone else some time 🙂

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Yes, this was a recent change - see https://powerapps.microsoft.com/en-us/blog/power-fx-no-more-columns-names-in-text-strings/ for more details.

Was this reply helpful? Yes No
subsguts 1,259 Moderator on at

Like (0)

Report
Copy link

Link copied!

I feel sorry for those that have to republish all their code since I assume it's doesn't have backwards compatibility, right?

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

It is backward compatible. See this excerpt from the blog post: "But wait… Aren’t we going to break all the existing apps in the world? Power Apps has a mechanism to update app formulas automatically. This change is only a syntax change, the behavior of these functions does not change, making it perfect to use this mechanism. Your apps will be automatically updated to the new syntax when they are loaded into Studio at or after version 3.24042. In general, you don’t need to do anything except to start using the new syntax for new formulas."

So existing apps will be updated automatically. The only problem is with examples that you can find on the internet where one would want to copy / reuse in new apps - those will need to be updated.

Was this reply helpful? Yes No