Hi,
Suddenly it stopped working and I can’t open the pdf. I’ve checked but I can’t find how to fix it. all files are in a shared drive
The complete folder
This is the html message:
<html>
<body style="margin:20px">
<div>'\Files\2024_02_09 - 12_51_55CotizacionMarcel Behar538392.pdf' not found</div>
<div>Probable cause: N/A</div>
<div><ul><div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A</div>
<details>
<ul>
<li><div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A</div>
<details>
<ul>
<li><div>
<div>Path: Root</div>
<div>Result: Success</div>
</div>
</li>
<li><div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A</div>
<details>
<ul>
<li><div>
<div>Path: Root</div>
<div>Result: FAILURE</div>
<div>Message: N/A, Searching for '\\Files\\2024_02_09 - 12_51_55CotizacionMarcel Behar538392.pdf', File entry not found</div>
<details>
My spreadsheet is in ‘data’ and the pdf files in ‘Files’
‘Unidades compartidas’ is ‘shared drives’ in google drive
Also, I created a “Shortcut” of the folder to my drive
In the action this is the path and the default app folder
and the filename prefix bots:
SUBSTITUTE(
SUBSTITUTE([documento pdf],
"\Files\",""
),
".pdf","")
thanks