Answered

F&O Document Attachment Fails with email Trigger

(1) Share

Report

Posted on by ManthanK

I am creating a flow in which it trigger when email arrives in specified mail which content pdf attachment. That pdf attachment need to be added to specified shipment in D365 F&O. Here is my flow screenshot

But it is getting failed in create record. Error is "

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

". Even though I have specified file content. Also in compose it shows value.
The same failed flow works fine on resubmit. Please help me with this problem

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManthanK ,
Do you want attachment content?
First you should set the option to include attachments to Yes
or
You need to add a Get Attachment action to get the attachment content.
Best Regards,
Dezhi

Was this reply helpful? Yes No
ManthanK 4 on at

Like
a
(0)

Report
Copy link

Link copied!

v-dezhili-msft, Thanks for the solutions you have provided but option of include attachments is already set to Yes and i had tried the Get attachment action but it is also failing.

Was this reply helpful? Yes No
Bharath_v 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManthanK ,

I am also trying the same but i need to attach the document with "VendorDocumentAttachmentEntity" entity. If you have any solutions please let me know as well.

Was this reply helpful? Yes No
James Lyn 10 on at

Like
a
(4)

Report
Copy link

Link copied!
I managed to successfully import PDFs into D365 using the VendorInvoiceDocumentAttachments entity. For the Archive file field (File Content), normally the base64 of the File Content needs to be passed, however it was throwing the error that the OP mentioned. I wrapped the base64 expression with a trim expression and the PDF loaded fine. Example expression:
trim(base64(outputs('Get_document')?['body']))

In my example, the Get_document is pulling from a Dataverse connector, but I also managed to use the trim function to successfully load a PDF file from the SharePoint Get File Content connector. I suspect the connector may be trying to convert the base64 passed in some way causing D365 to error out and the trim may force it through as a string.

Was this reply helpful? Yes No
Bharath_v 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @jlyn ,

We also able to import the attachment with above example. Thanks once again

Was this reply helpful? Yes No
krawad 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Jlyn for the solution, i tried the above function witht base64 and trim functions; the flow actually succeded but the file in F&O was unreadable.
PS: i receive the file by email attachment, i tried to save it on onedrive then get its metadata but didnt work as well.
Also the file saved in onedrive is readable.

Thanks!

Was this reply helpful? Yes No
Verified answer

Bharath_v 36 on at

Like
a
(5)

Report
Copy link

Link copied!

Hi @krawad ,

I am faced that issue. So, i tried this way and its worked. May be this will help you to solve the problem.

Was this reply helpful? Yes No
krawad 9 on at

Like
a
(1)

Report
Copy link

Link copied!

thank you so much @Bharath_v it worked perfectly!

Was this reply helpful? Yes No
Shivani Thakur 6 on at

Like
a
(0)

Report
Copy link

Link copied!

worked for me as well. Thanks

Was this reply helpful? Yes No
Shivani Thakur 6 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked for us as well. Thanks a lot

Was this reply helpful? Yes No