I've been trying to import pdf file (w9 file) to Vendor document attachment entity but it shows "We can't open this file" in Preview and it looks like the file was not imported into D365FO. Tried to open the file (download the file) but it was not readable.
Does anyone know how to solve the problem or how to upload pdf file to Vendor master using power automate?
My ultimate goal is scan the documents (vendor request form and W9) from procurement team and create the vendor master and attach pdf W9 form to the vendor.
Here is the message on Preview.
Here is my flows. Maybe Initialize the variable and set the variable parts are not necessary. I was just following guidance from someone's blog.
1. Upload the file
2. Initialize the "FileContents" as String
3&4. For Parse Jason and Compose parts, I just removed unnecessary text from contents.
example:
Original text >> {"contentBytes":"dGVzdA==","name":"test.txt"}
After3&4 >> dGVzdA==
5. Set Output from Compose to Variable "FileContents".
6. Adding new row in Vendor document attachments entity. In Archive file field, I convert String to Base64. Used this Expression: base64(variables('FileContents'))