Solved! Go to Solution.
I am now able to do that with "Multiple tabs" icon. I just filter the sheet that I want and connect to multiple tabs to read the content of the sheet.
I am not reading one sheet only but multiple sheets at the same time. That's why I am finding ways to read both the list of sheets and the corresponding content.
Thanks a lot.
Hi Eliot12345, all,
If I have correctly understood your request, the below and attached workflow should do it, thanks to the Dynamic Input tool.
I described the setups of the different tools in the below image.
Have a try and come back to me if you need any assistance !
Hi JimPer,
That is a great alternative solution.
I find that there is a disadvantage if I use "Multiple Tabs" tool instead of "Dynamic Input" tool to read the content.
Since my file contain column data with colons, "Multiple Tabs" is having issue to read them and wrongly use colon as the separator that all the content positions were shifted.
Nevertheless, I can achieve reading the content with your workflow below.
Thanks,
Eliot
You're welcome !
Thanks for your feedback