Showing results for 
Search instead for 
Did you mean: 
New Member

Reading from Excel with hidden columns fails

I'm currently facing an issue with an excel file, which has sometimes hidden columns.

What I'm doing in my flow:

  1. Copy an excel from external sharepoint to my internal one.
  2. Reading a table from that copied file (filter on value of 1 column)
  3. Update an other excel file (own managed) with new entries and proceed workflow

In step 2 somethimes there occurrs an error, when someone has hidden a column - regardless which one.
I recieve a message like:
"Matching of columns in filtered view not possible, number of filtered columns: 42, number of actual columns 44. try to show all columns to use sorting or filtering"

The only workaround I know it to go to the original file - unhide all columns and workflow can be passed successfully.
Is there any other smoother and more automative way? Like a step to just unhide all columns? Or any other idea?

Thanks for any hint.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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,997)