Solved: Unable to display xlsx file in browser - Page 2

gougou · 10-31-2023 04:24 AM

I created bot to create an xlsx file.

The path to the created file is stored in the column set for the file type.

When I click on the icon that appears as a link to the path on the app, the file does not appear in the browser, but is automatically downloaded locally.

How do I make it appear in the browser?
Or can I save the file locally by specifying the path?

(The template is created in xlsx format and placed in Dropbox)

baba_sawane

First, create a new folder for your collection, then add this folder like you were adding a normal table by selecting collection of file (if it's not already done).

Collection of files name is the table name (which is your collection folder name).

Use this : ~~concatenate("https://drive.google.com/file/d/", select(collectiontablename[_ID], contains([Path], [_THISROW].[File]))~~
update : you have to use https://docs.google.com/spreadsheets/d/ to be able to edit the file.

concatenate("https://docs.google.com/spreadsheets/d/ ", select(collectiontablename[_ID], contains([Path], [_THISROW].[File]))

Using this formula, you select this table, and get the value of the file ID of each row , by filtering the Path column. The filter select values that contains your file name.

____

A collection of files is listing all the files contained in one folder -without subfolders- in your Drive. This is why you have to edit your file path in your automation of your generated xlsx inside this folder.

If you want to get the URL to your file in the table where you generated it, use any(select(collectionfilestablename[URL], [File] = [_THISROW].[File] ) ))

View solution in original post