Answered

AddColumns Error

(2) Share

Report

Posted on by ML-15050300-0

I am consistently getting an error whenever I use the AddColumns function in Power Apps. As you can see in the screenshot, a red underline appears even with a very basic test formula. I’m not sure why this keeps happening.

Is there a specific reason why AddColumns would fail on a standard table? I’ve checked the column names and syntax, but the error persists. Could it be related to regional settings (comma vs. semicolon) or a data type mismatch?

I tried to proceed by ignoring the error (thinking it might just be a warning), but the formula does not work at all.

Categories:

Error handling

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ML-15050300-0,

I created a sample collection.

ClearCollect(

colEmployees,

[

{ Name: "Raghav", Age: 28, Department: "IT" },

{ Name: "Yukesh", Age: 17, Department: "HR" },

{ Name: "Pravin", Age: 35, Department: "Finance" },

{ Name: "Murali", Age: 22, Department: "Admin" }

]

);

Usage of Add Columns to the Collection

ClearCollect(

colEmployeesWithCategory,

AddColumns(

colEmployees As rec,

'AgeCategory',

If(rec.Age >= 18, "Adult", "Student")

)

);

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

I have revisited your formula based on my collection you also update it accordingly

Concat(

AddColumns(

colEmployees As rec,

'AgeCategory',

If(rec.Age >= 18, "Adult", "Student")

),

ThisRecord.Name & " - " & ThisRecord.Age &" years - " & ThisRecord.AgeCategory &

Char(10)

)

Was this reply helpful? Yes No
Verified answer

timl 37,214 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @ML-15050300-0

The simple answer to this is that when you add a column with AddColumns, there's no need to enclose the new column name in double quotes.

The correct formula looks like this:

Concat( AddColumns( Table( {Name:"Adult", Age: 30 }, {Name:"Student", Age: 17 } ), AgeCategory, If(Age >= 18, "Adult", "Student") ), Name & " - " & Age & " years - " & AgeCategory & Char(10) )

I tested this by adding it to a label - there are no errors and it produces the correct result.

Was this reply helpful? Yes No
Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
The name of the new columns passed to the AddColumns function cannot be enclosed in double quotes (this used to be the case, but changed a few years ago). If you remove those, it should work:

Concat( AddColumns( Table( { Name: "AAA", Age: 30 }, { Name: "BBB", Age: 17 } ), AgeCategory, // no quotes If(Age >= 18, "Adult", "Student") ), Name & " - " & Age & "years - " & AgeCategory, Char(10) )

Hope this helps!

Was this reply helpful? Yes No
Verified answer

timl 37,214 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

For further details, here's the article about the change to remove the need for double quotes in calls to AddColumns.

https://www.microsoft.com/en-us/power-platform/blog/power-apps/power-fx-no-more-columns-names-in-text-strings/

Was this reply helpful? Yes No