Only Allow User to Select Specific Sheets From Excel With File Browse on Gallery

[Kenda]

When using a File Browse to get a file from a user on the gallery, I want to be able to limit the sheets available as options to select from. Currently all sheets and named ranges in the workbook appear in the list. In the example below, I would want to be able to limit the options to just the Allow sheet so that the <List of Sheet Names> and the Don't Allow sheet are not even options for the user.

[patrick_digan]

Great idea!

[KylieF]

Hi all!

This is an interesting idea and great feedback on how the File Browse tool and data connection process can be improved, which we greatly appreciate!

I know neither of you are new to the idea boards, but for any users who are interested in this idea be sure to like and check out our Submission Guidelines, which go over the process behind the boards in a bit greater detail.