Hello Power Automate community.
Can you help please?
The issue I have is: when I send an Approval message via Microsoft Teams and add a PDF file, from the attachments in a SharePoint List item, the approver is unable to open the PDF file and receives a message in Adobe Acrobat Reader stating:
"Adobe Acrobat Reader could not open ''MyFileName.pdf' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded."
The real issue appears to be creating the file, as even if I try to open the file attached to the SharePoint List item, it gives me the same error.
Here's some more information to help.
The URL I provide in the Approval message is structured like this:
https://mycompany.sharepoint.com/sites/MySiteName/Lists/MyListName/Attachments/69ThisMustBeTheIdOfTheFileInTheAttachmentsFolder/MyFileName.pdf
The process is as follows:
- A Microsoft Form is completed.
- Flow 1 triggers and creates an item in a SharePoint List and populates the answers from the Microsoft Form into columns in the SharePoint List item.
- It gets the data from the List item.
- It converts the data into a html table.
- It uses the OneDrive for Business connector to create a file.
- It converts the file to a PDF.
- It recreates the file.
- It adds the file to the attachments column of the SharePoint List item.
Below are the actions of the Flow not expanded.
Below are the actions expanded.
Now, even before my second Flow runs and gets the attachment and send it for an approval, the file attached to the SharePoint List item doesn't open when I click on it, and it gives me the error I mentioned at the top of the post.
Any idea what I'm doing wrong, please?
Thanks in advance for all your help,
Garry
