You’re offline. This is a read only version of the page.
Announcements
4
Hi,
I'm currently facing an issue with an excel file, which has sometimes hidden columns.
What I'm doing in my flow:
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.
Hi there, I was in the same "problem".
In my approach, I created an Office Script to unhide all the columns and invoke it before the List rows step.
Office Script samples: https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/excel-samples
Regards,
Share
Report
All responses (
Answers (
