Power Platform Community Forum Thread Details

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

What I'm doing in my flow:

Copy an excel from external sharepoint to my internal one.
Reading a table from that copied file (filter on value of 1 column)
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.

Categories:

Building flows