Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Free Trial

Alteryx Designer Desktop Discussions

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

Interface Tools within Macro not updating values

Jes
8 - Asteroid

I have a macro that:

1. Selects a file from a list of files in SFTP

2. Downloads the selected file onto a shared folder in Sharepoint (Given the file is downloaded to a Sharepoint website, Interface Tools were used to update the usernames in dynamic input tools, formula tools, output tools, etc.)

 

When the macro is triggered, the user is prompted to select their username from a list of usernames. 

The downloaded file is critical/used in a variety of processes and is usually the starting point of other workflows. 

 

Given that the downloaded file is used in many workflows, it made sense to set up the process in a macro to account for future changes (limit the need to make changes to many different workflows vs updating 1 macro).

 

Screen print of macro:

JH0123_0-1615303324896.png

 

 

When embedding the above macro in other workflows, the interface tool embedded within the macro is not triggered. 

The macro is embedded in another workflow as seen below. This workflow also has interface tools to prompt selection of username & to use this data to update Sharepoint folder link, etc.

 

Any suggestions on how to change/update my macro so that when the below workflow is run, the selected username flows into the macro as well?

JH0123_1-1615303875840.png

 

 

 

1 REPLY 1
patrick_digan
17 - Castor
17 - Castor

@Jes Great question! As you've figured out, there is no way to "bubble up" the macros interface questions to your app; instead, you will have to duplicate any macro interface questions and create them again in your app (which it looks like you've already done). Since it looks like something isn't working, I would focus on how your action tool connected to the macro is setup. In order to help you debug, I would use the Interface Designer (View >> interface designer) and then debug your app. Your action tool should be updating your macro's dropdown when configured correctly.

Labels
Top Solution Authors