Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to: dynamic dropdown of excel sheet with dynamic filepath input?

jensroy
9 - Comet

Hello!

 

I am working on a custom macro (not an app) for a workflow. We have excel files located on sharepoint. I am able to read these using the normal input tool. It works great. Now I want to stream this file into an in-db stream to enrich some data.

 

The challenge: I want to paste inn the sharepoint file path (or local excel file. it should act the same) in the macro, and then I want to macro to refresh the list of available sheets in that workbook.

 

I have succeeded in each step individually, but not when it comes to getting an updated sheet list based on the filepath i paste in.

 

Anyone have a good idea for this?

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

If you want this to work then you can not use a macro in a sense because everything is worked out at run time.

 

This type of thing you can do using the HTML gui extension, where the user would put in the site address and hit a button, this would trigger a script to run to go and fetch the list and populate the drop down.

 

An example of this can be found with the 'Publish to Tableau Server' tool on the gallery.

 

With a normal macro everything is generated at run time, so hence why your list doesn't refresh when the user pastes something in.

 

You can do this with a chained app, but as you mentioned at the start of the post, this isn't what you want!

 

Ben

jensroy
9 - Comet

Hi Ben,

 

Yes I thin the HTML gui is exactly the thing I am looking for. I have never used that before.

 

I found this documentation and will give it a go:

https://community.alteryx.com/t5/Engine-Works-Blog/Building-an-HTML-Macro/ba-p/158691

 

Thanks Ben!

Labels