Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Collect can't match two identical columns


I have a Collect that update a source with a collection.

Used to have the source in Excel and it worked fine... now today I exported the table to a Sharepoint list and updated the app accordingly.

But now the patch says it can't find one column... but it also display identical column names.
Below you can see the detailed error message... and you can see there that the columns have the same name.
I've also tried to change the name on the columns in both the collection and in the Sharepoint list... but it still gives the same error.


Can't find column.PNG

Helper III
Helper III

I changed the column name to "Rubrik" and it worked... but then it complained on a new column that was identical.
After changing a bunch of columns it starts to complain on the new names I choose...

Right now it's complaining on "Orderdatum" and "Orderdate", but "XXX" worked, but now it complaines on "Rubrik" again.
And so it goes round and round... 😞

Helper III
Helper III

I circumvented the problem with a ForAll & a Patch function.
But I would love to know why the collection didn't work, since all columns were identical.

New Member

I have the same problem. Already looked up everywhere and there seems to be no solution.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,952)