Unanswered

Get File Content for Dataverse Note to Upload to Business Central

(0) Share

Report

Posted on by ice1234

Hi 🙂

I have a canvas app with Dataverse as my data source. I have enabled the Attachment so all my attachments are stored in Note. In my Power Automate flow for when a record is created I need to get the file name and file content for the attachments and upload them to Business Central. I have an "List rows" action to get the attachments and from there I can get the File Name but I'm not able to use the Document variable (Always get failed to load error if I try to open it in Business Central). Can someone help me out?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Linn Zaw Win 2,996 on at

Like (0)

Report
What action did you use to upload them to Business Central? Maybe the action is expecting Binary data instead of Base64. In that case, you need to convert the content type before uploading to BC.
base64ToBinary(outputs('Get_a_Note_Attachment')?['body/documentbody'])

Was this reply helpful? Yes No
ice1234 55 on at

Like (0)

Report

Hi @LinnZawWin

I'm using the "Update an image, file or document (V3)" for Business Central. I've tried a few ways to see if the base64tobinary is something I could use, but so far nothing is working. I've tried to take the "Document" variable and append that one to string variable and using that in the base64tobinary, I've also tried the same thing that you suggested here above but that doesn't seem to work either. I'm fairly new to Dataverse so maybe I'm doing something wrong.

I have the same flow for Sharepoint and that one is working perfectly.

In a perfect world I thought I could just use the "Document" variable that comes from this action.

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report

@ice1234
Sorry, I don't have a Business Central connection to test the Update an image, file or document (V3) action.
But based on the following blog post, it is getting the file content from Get file content action for the OneDrive for Business connector which is the binary format. So, base64ToBinary() of the Documents should be working but I am not sure why it is not working for your case.
https://www.powercommunity.com/dynamics-365-business-central-new-power-automate-actions-for-handling-images-and-attachments/

Hope someone who's familiar with BC connector could shed some light.

Was this reply helpful? Yes No
ice1234 55 on at

Like (0)

Report

Hi @LinnZawWin,

Yes this works perfectly for Sharepoint as well. But when I'm getting the attachment from Dataverse things seem to get more complicated, maybe I'm not pulling the attachment from Note correctly or missing some step.

Thank you so much for taking the time to reply to me, I really appreciate it!

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report

If you are able to upload the file from SharePoint, that means the action is expecting binary data.
In that case, base64ToBinary should work through.
Ref: https://linnzawwin.blogspot.com/2021/02/handle-base64-and-binary-file-content.html

Was this reply helpful? Yes No
Verified answer

ice1234 55 on at

Like (1)

Report

@LinnZawWin,

I figured this out. I needed to use a compose action for the content-type (Mime-Type in Dataverse) and content (Document in Dataverse) and then I was able to use the output as the Content! 🙂

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (1)

Report

@ice1234
Glad to know that it finally worked out well. Please mark your own last reply as a solution to close this thread. That will be useful for others in the community who come across this thread to identify the solution easily.

Was this reply helpful? Yes No