Unanswered

AddColumns error - Column name already exists

Like (0) Share

Report

Posted on 13 Apr 2023 08:11:19 by SShivi

I am trying to add some columns to a collection using the AddColumns function. The second argument - Column Name - returns the error: "Column name already exists".

It has started happening recently. Previously the same code was working fine.

Here is the syntax:

Clearcollect(col_bills, AddColumns(Gallery.AllItems,"NewColumn", "TestVal"))

All responses (3)

Answers (0)

iAm_ManCat 18,206 Most Valuable Professional on 13 Apr 2023 at 13:27:41

Like (0)

Report

Re: AddColumns error - Column name already exists

@sahana_23 That is not a valid Power Apps formula, the column name has to be a text literal - plus even if you could add a random value to the column name after every time you collect something, then you will never be able to refer to that column name in your App as it will change every time

Did you try this formula yourself or is this what the AI suggested - AI models are currently particularly bad at PowerFx, so I would not recommend using them for PowerFx
sahana_23 46 on 13 Apr 2023 at 10:54:00

Like (0)

Report

Re: AddColumns error - Column name already exists

Hii, Can you use this formula and try it once,
ClearCollect(col_bills, AddColumns(Gallery.AllItems,"NewColumn" & Text(Rand()), "TestVal"))
victorcp 2,347 Super User 2025 Season 1 on 13 Apr 2023 at 09:20:50

Like (0)

Report
Re: AddColumns error - Column name already exists

Hi,

Problably you already have that column, if you want to override it, you can do this:

ClearCollect(col_bills, AddColumns(DropColumns(Gallery.AllItems,"NewColumn"),"NewColumn", "TestVal"))

But I suggest changing the name of NewColumn.

I hope it helps 🙂