"Read Excel Sheet Names" output as list for a "List Box Widget

Hi …

A client does a weekly update to a new sheet in an Excel workbook. I already have a flow that reads all the sheets and then loops through all the new sheets to create some output, but I have new requirement since sharing the flow. My client would like to be able to pick a sheet from the workbook to process.

Is it possible to read the sheets and then use the “sheets” column as options for a “List Box Widget”.

tC/.

I just solved my own problem. I should have done better research … I have been using the wrong node. I should have been using the “Value Selection Widget”, not the “List Box Widget” …!

tC/.

5 Likes

Thanks for following up with your solution!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.