[Bug] File type column cannot read the selected filename

[LeventK]

@praveen @brian @tony
When I use a File type column, there are some certain cases that I don’t want the users to upload files other than PDF, DOC or restrict the upload of certain file types like PNG, JPG etc. To verify this shall be as easy as constructing a Valid_if expression like:

".PDF" = UPPER(RIGHT([FileColumnName],4))

However, whatever way you construct this kind of expression to ensure the file type, the expression evaluates to a null value (empty string) and therefore always eval to FALSE.

[Fabian_Weller]

I just tested how this works with Actions and Bots after saving a record.

In an Action's condition we cannot use:
ENDSWITH([File_Column],".pdf")
nor
ENDSWITH(TEXT([File_Column]),".pdf")
It will just not fire the Action.

Bun in a Bot's condition we can use:
ENDSWITH([File_Column],".pdf")
or
ENDSWITH(TEXT([File_Column]),".pdf")

So it seems as if a Bot can read the column value, an Action cannot.

Our usecase: We use 2 columns: [Image] and [Document] to upload or an image or a document. But some users insert an image like jpg in the [Document] column. A bot then copies the value from [Document] and pastes it in [Image]. It then also deletes the value in [Document]. This workaround is ok for our usecase, but it's not perfect.
In the Bot we use the condition:
STARTSWITH([Document],"TABLE_NAME_Images")
Because if it would be a real document file, it would be saved in "TABLE_NAME_Files_".

[Firdaus_AG]

I need this!

[JOHNN]

i have the same trouble, it was normal before but now i can open the file but when I check in Google drive the file is exist