Answered

AddColumns Not Working

(0) Share

Report

Posted on by JK-25091409-0

Everytime I use "AddColumns" I get an error as I type in the name of the new column. The column gets added to the collection before the command is entered, and it says there is a duplicate column.

Categories:

Power Apps component framework

I have the same question (0)

All responses (16)

Answers (1)

AndrianaO 199 Moderator on at

Like (0)

Report

AddColumns Not Working

Hi! The table on the first screenshot is OpenRequirements, and the table on the second Screenshot is RequirementsC. The error in the formula indicates that the column "ClosedTag" already exists in the table OpenRequirements. Are you sure it is not there?

Was this reply helpful? Yes No
JK-25091409-0 92 on at

Like (0)

Report

AddColumns Not Working

That was my mistake, but it is happening on both RequirementsC and OpenRequirements.

Was this reply helpful? Yes No
AndrianaO 199 Moderator on at

Like (0)

Report

AddColumns Not Working

That is strange because AddColumns cannot modify the table you're using as an argument, this function creates a new table.
How are you creating these two tables? Do you collect them directly from the data source?

Was this reply helpful? Yes No
ronaldwalcott 3,825 Super User 2025 Season 2 on at

Like (0)

Report

AddColumns Not Working

Show the statement where you adding columns to OpenRequirements

Was this reply helpful? Yes No
JK-25091409-0 92 on at

Like (0)

Report

AddColumns Not Working

Was this reply helpful? Yes No
AndrianaO 199 Moderator on at

Like (0)

Report

AddColumns Not Working

Can you show how you create the original collection before you run AddColumns function? It is important to know if the column ClosedTag already exists (even though all the values in that column are empty). I suspect that instead of AddColumns you should try using:

ForAll(OpenRequirements,Patch(OpenRequirements,ThisRecord,{ClosedTag:

Concatenate(ThisRecord.ID,",",ThisRecord.Title)}))

This code will update every record in your collection to have the correct value in ClosedTag column if this column do really exists

Was this reply helpful? Yes No
JK-25091409-0 92 on at

Like (0)

Report

AddColumns Not Working

Andriana, When I used your code I got : "The specified column 'ClosedTag' does not exist".

Was this reply helpful? Yes No
JK-25091409-0 92 on at

Like (0)

Report

AddColumns Not Working

I added this to the OnSelect of the list box I am choosing from:

AddColumns(RequirementsC, TitleTag, Concatenate(ID, ". ", Title));

I do not get a 'column exists' error, and the column does not show up under the collections variable.

Was this reply helpful? Yes No
Suggested answer

AndrianaO 199 Moderator on at

Like (0)

Report

AddColumns Not Working

Oh, that is a good sign that the error disappeared and the column is expected not to show. The AddColumns() function does not create a column in the table you pass as a parameter to this function. You can read about it in the documentation

That is why you need to add the results of your AddColumns() function to a new collection:

Try this formula

ClearCollect(colRequirementsC,AddColumns(RequirementsC, TitleTag, Concatenate(ID, ". ", Title)));

The new column should appear in a new colRequirementsC table

Was this reply helpful? Yes No
JK-25091409-0 92 on at

Like (0)

Report

AddColumns Not Working

It's still doing that, you can see the RequirementsC has a ClearCollect, and it pulls from the Requirements table which does not have a
"TitleTag" column. Actually if you look at the image of the collection above, the new columns are in fact showing up in RequirementsC. That must be the problem, AddColumns is adding the new column to the collection instead of returning a new table.

After some testing I think that's it, if you AddColumns to a Collection, they get added to the collection. If you AddColumns to a table, it returns a new table.

This works for me (Requirements is an actual table):

AddColumns(Requirements, TitleTag, Concatenate(ID, ". ", Title))

Was this reply helpful? Yes No