cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NasserA
Regular Visitor

AddColumns fails when adding column to collection from ShowColumns

Using Office 365 Power Apps Version 3.20013.29

 

The code below performs the following:

 

vRequestRecords has the columns: "Title", "ItemType", "ItemName", "RequestType", "Revision", ….. and several others.

The function ShowColumns extracts 4 columns ("ItemType", "ItemName", "RequestType", "Revision") from vRequestRecords.

The function AddColumns then adds 1 column ("Title") to the result of ShowColumns.

 

Until Friday, January 31,2020, it worked without a problem.

 

Today, February 3, 2020, it shows the error messages listed.

 

It looks like a Power Apps bug introduced in a recent Office 365 update.

 

 

CODE:

 

AddColumns(ShowColumns(vRequestRecords, "ItemType", "ItemName", "RequestType", "Revision"),

  "Title", ItemType.Value & ": " & ItemName.Value & " (" & RequestType.Value & ")" & " (" & Revision & ")"

)

 

ERROR MESSAGES:

 

A column named 'Title' already exists.

The function 'AddColumns' has some invalid arguments.

11 REPLIES 11
james_hathaway
Advocate IV
Advocate IV

It seems this BUG has REAPPEARED.

 

I too am getting the "Column already Exists" error, for a column that most certainly DOES NOT EXIST.

 

I also agree with @NasserA

This is inexcusable - especially as it was a big that was previously reported and fixed, and yet is back!

 

Microsoft - Please fix.

 

James.

 

servoise
Regular Visitor

Same problem here. How can we solve or circumvent the problem ?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,576)