File Browse and Action Tool to update file path but force sheet name

Question

I am creating an app where I want the user to be able to use the file browse to select a file path, but then force the sheet name that is input regardless of their selection. I believe I've seen it done with update value with formula, but I don't remember the regex formula to replace the current things left of | with the path data left of |

ChrisTX · Answer

Without RegEx, yes use Dynamic Input after you have your new full path.

Chris

Felipe_Ribeir0 · Answer

Hi @KyleF

You can use this formula inside your action tool, just replace the Sheet1 by the Sheetname that you want to always be imported

REGEX_Replace([#1], '(?<=\|\|\|)(.*?)$', 'Sheet1')

File Browse and Action Tool to update file path but force sheet name.yxzp

KyleF · Answer

Would you then use dynamic input to pull the actual data?