My PDF is opening up as HTML error saying file cannot be located

[whlim]

as the title mentioned, my pdf file when opened in a new tab returns an error saying file cannot be located. 

now i checked for spelling error or any mismatch in the folder path, cross checking with my drive, nothing seems to be wrong with it...

tried solutions from the forums saying to throw in the .xlsx files in the same folder in drive... i've done that...

did all that but nothing seem to work.

any help appreciated....

[Aurelien]

Hi @whlim 

Did you check the PDF file has been properly created in the appropriate file?

[whlim]

yep i did, the file is created in my drive > appsheet > data > app name> PDFs > 2024 > filename... i can manually open the pdf just not access it via action

[Aurelien]

Can you get rid of the ENCODEURL() part?

[whlim · Accepted solution]

getting rid of it didnt solve it... but i have figured out the issue, being that google sheet excel and microsoft office excel is apparently in different formatting, therefore affecting the relative folder path. I ported over the data using the google sheet excel and it works now.