Dynamics Community Forum Thread Details

Use power Automate to Attach a file to "VendorDocumentAttachments" Entity

Hi,

The process I am trying to build in the Power Automate is:

1. Trigger When a new email is received in the Companies outlook with a PDF

2. Use the AI invoice reader to read the invoice and determine "Vendor", Amount, PO# etc...

3. Create a Pending vendor invoice header in D365 FO

4. Attach the invoice file to the Pending vendor invoice

I have successfully created the steps 1 to 3 above, but I am not able to attach the file (STEP 4). I am using the "VendorDocumentAttachments" entity and I cannot get around the errors it gives me.

"An error has occurred. Write failed for table row of type 'VendorDocumentAttachmentEntity'. Infolog: Warning: 'FileContents' is required when attaching a file; Warning: validateWrite failed on data source 'DocuRefEntity (DocuRefEntity)'."

The error to me makes sense because I cannot add the Invoice reference to the Automate step: