File Content not available when using base64ToBinary

(0) Share

Report

Posted on by Jorge_

Hi,

I get a weird behaviour when trying to move files from Dataverse to SharePoint.

First, I get Notes with .jpg attachments in Dataverse

Then I do create a folder and a file.

When creating the File, in the file content, if I choose items('Apply_to_each')?['documentbody']

it works, however file cannot be opened in SharePoint as incorrect format, found that I need to create the file using base64ToBinary

But the weird thing is that when I use: base64ToBinary(items('Apply_to_each')?['documentbody'])

it gives me an error with: The template language function 'base64ToBinary' expects its parameter to be a string. The provided value is of type 'Null'

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Jorge ,

You can use the Download a file or an image action to get the file content instead:

Best regards,

Was this reply helpful? Yes No
Jorge_ on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

I cannot use that action for attachments on Notes.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Jorge ,

Could you please check the notes table and see in which column the files are stored? It is a common process to get file contents from the Notes table:

Upload or download image and file content - Power Automate | Microsoft Learn

You will not be able to get file contents by querying the documentBody column in Notes table:

PQ Returns "Null" Rows from Dataverse Table '[Note... - Microsoft Power BI Community

Best regards,

Was this reply helpful? Yes No
Jorge_ on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

The file is on the documentbody, and throws Resource not found for the segment 'Note'.
As you might know, Notes its an out of the box entity which cannot be modified.

So, it is not possible to get Notes file contents within a loop in Power Automate?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jorge ,

Based on my test, get document body from note table is achievable in a loop.

Result:

It seems there is something wrong with your fetch XML query expression:

Use lists of rows in flows - Power Automate | Microsoft Learn

You may try and use Filter query instead:

endswith(filename, '.jpg') and (createdon lt 2022-01-01T00:00:00-00:00)

Best regards,

Was this reply helpful? Yes No