SharePoint Input Tool and Interface tool

[JayMarie]

Hi. I would like to know if it's possible to use any interface tool to the SharePoint input tool where I will be the one to select the tab that I need to run in my workflow. I have this use case where my file contains the monthly data for each tab. Now I need to transfer those data in another file in the SharePoint but I only need to select one month every time I run the workflow. I tried to use the File Browse and Action tools but it still chose the tab that I assigned for the SharePoint input tool, not the one I selected in the File Browse. I'm running it as an analytic app. Hope you can advise and kindly provide an example that can be my guide. Thank you.

[robwalks]

Hi @JayMarie , when you connect an action tool to the SharePoint Input Tool for files, there is a value called "SheetNames - value". In my screenshot below you can see in my example this is set to "Summary" (full string is: SheetNames - value="Summary")  tab in my Excel file. If you add another interface tool (such as text input, or control parameter) to amend this value then you can select any valid worksheet.

its worth mentioning that there are other values that can be edited to make this even more dynamic - for instance the "Path - value" one allows you to change the document library and filename that you are locating. Hope that helps.