Bot is ignoring File Folder Path

The Default app folder for my app is:

/[TeamDrive]PHS-OEHS-BPH-DHHR/Food Manufacturing/Permits and Inspections

I created a bot that Creates a New File when a permit is added to the permits table.

The File Folder Path for the bot is:

CONCATENATE("/Facilities/", [Name], "/Applications and Permits/", [Fiscal Year])

When the bot creates the file it ignores the File Folder Path and creates a Files folder under the default folder.

/[TeamDrive]PHS-OEHS-BPH-DHHR/Food Manufacturing/Permits and Inspections/Files

Is there any way to get it to use the File Folder Path that I entered?

0 1 32
1 REPLY 1

The two paths you have shared are completely different in their content.

Also not sure what you mean by /[TeamDrive]...

It appears like an incorrect syntax because typically [TeamDrive] may not be allowed.


@DanielMcNeil wrote:

/[TeamDrive]PHS-OEHS-BPH-DHHR/Food Manufacturing/Permits and Inspections/Files


 

So you may want to further clarify exactly which path you you wish the files created by AppSheet automation need to be stored.

Generally if the file path in the bot setting is 

CONCATENATE("/Facilities/", [Name], "/Applications and Permits/", [Fiscal Year])

Then the folder path will be something like

App root folder/Facilities/ James/Application and Permits/2025

 

Top Labels in this Space