cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NasserA
Level: Powered On

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.

1 ACCEPTED SOLUTION

Accepted Solutions
NasserA
Level: Powered On

Re: AddColumns fails when adding column to collection from ShowColumns

The problem has been resolved with a product update.
It no longer exists with Office 365 Power Apps Version 3.20022.19.
Hopefully regression testing as been put in place to prevent it from reoccurring again.
Thank you PowerApps team for the prompted solution.

View solution in original post

6 REPLIES 6
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: AddColumns fails when adding column to collection from ShowColumns

Thank you for reporting this issue; I'll pass it to the product team right away.

Stefan_J
Level: Powered On

Re: AddColumns fails when adding column to collection from ShowColumns

I have the same issue here.

 

Collection A with columns: ID, Title, Date

I use AddCollection(B, ShowColumns(A, "ID", "Title"))

 

Then: AddCollection(C, AddColumns(B, "Date", Today()))

 

Error: The columns named Date exists. 

In the preview of the collection B I see only the columns ID and Title.

Power Apps Staff lesaltzm
Power Apps Staff

Re: AddColumns fails when adding column to collection from ShowColumns

Hey all. We've identified the issue (related to performance optimizations for data calls) and will prepare a fix. In the mean time, this can be resolved by not using a name that is present in the original table. Sorry for the inconvenience.

NasserA
Level: Powered On

Re: AddColumns fails when adding column to collection from ShowColumns

There is evidence of this problem being reported and fixed in the past – at least a year ago. Just searching for it in the internet shows a good number of old reports.
Microsoft Power Apps team needs to do a better job at managing code changes and performing tests to filter out previously reported – and fixed – bugs which are now being reintroduced by their own team.
When bugs are reintroduced in a software product, it is a serious issue indicating bad code change controls and inconsistent automated testing.
What old bugs should we bee looking out for next?
This is inexcusable and should be fixed immediately.

NasserA
Level: Powered On

Re: AddColumns fails when adding column to collection from ShowColumns

The problem has been resolved with a product update.
It no longer exists with Office 365 Power Apps Version 3.20022.19.
Hopefully regression testing as been put in place to prevent it from reoccurring again.
Thank you PowerApps team for the prompted solution.

View solution in original post

roel-occ
Level: Powered On

Re: AddColumns fails when adding column to collection from ShowColumns

Hi there

 

I'm still seeing the same error message.

 

Best regards

 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,134)