How to Dynamically Update Modify Query in Dynamic Input Using Action Tool

[vijaysinghsinhmar]

I am building a workflow where the user selects a file containing multiple sheets that need to be collated for further processing. I am using the **File Browse Tool** to allow the user to choose the file, and then I use the **Dynamic Input Tool** to load the data from multiple sheets.

### **Current Setup:**
- **File Browse Tool** → Allows user to select the Excel file.
- **Three Action Tools**:
1. **Connected to Input Tool** → Updates the file path dynamically.
2. **Connected to Dynamic Input Tool** → Updates the input template path dynamically.
3. **Connected to Modify Query in Dynamic Input Tool** → Replaces a specific string (`'1-6$'`) with the correct sheet name from the newly selected file.

### **Issue:**
The workflow works fine in a standard setup, but when uploaded to the Alteryx Server, it fails because the **Modify Query does not update correctly**. The string `'1-6$'` needs to be dynamically replaced with the correct sheet name based on the user-selected file.

### **What I Need Help With:**
1. How can I ensure the **Modify Query dynamically updates** the sheet name based on the user-selected file?
2. Are my **Action Tools configured correctly**, or is there a better approach to update both the file path and sheet name?
3. Any best practices for handling **Dynamic Input with multiple sheets in a server environment**?

Thanks in advance for any guidance! 😊

[apathetichell]

Search for your specific use case in community and you'll see numerous posts on it - the key thing is do not use dynamic input. This will break. You must use a batch macro.

[vijaysinghsinhmar]

I Tried, Can you help me point out to such solution, Thanks!

[apathetichell · Accepted solution]

https://knowledge.alteryx.com/index/s/article/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-h...