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... 😞

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

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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,166)