Can't Create Note with jpg image attached from microsoft flow

(0) Share

Report

Posted on by fernando.campos@sof...

Hi,

I've created a flow in PowerApps that gets from Onedrive directory a list of images in jpg format.

Then searches for a product code, and then creates a note with the image from onedrive attached.

But when is creating the note it gives this error: The 'inputs.parameters' of workflow operation 'Create_a_new_record_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/documentbody' is required to be of type 'String/bytes'. The source type/format 'String/binary' of the value

I'm getting the image with a Get file content using path

And a set variable to set the image in the create new record this way

Does anyone know how to do or solve this?

Best regards!

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Bipin D365 28,985 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Instead of directly passing content to document body, you will have to convert to base64 string.

Please find below function in microsoft which will help you do the same.

docs.microsoft.com/.../workflow-definition-language-functions-reference

Also look at flow community thread below.

powerusers.microsoft.com/.../280333

Please mark my answer verified if I were helpful!

Was this reply helpful? Yes No
fernando.campos@sof... 35 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your answer!

I've changed the variable to be a string, and pass the file content with base64

base64(outputs('Get_file_content_using_path')?['body'])

but when is creating the Note record I'm getting this error:

"Invalid character in field 'documentbody': '.', hexadecimal value 0x00, is an invalid character.",

IF instead of passing base64ToString I pass just the variable I've setted before I'm getting this error:

The 'inputs.parameters' of workflow operation 'Create_a_new_record_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/documentbody' is required to be of type 'String/bytes'. The source type/format 'String/base64-function-result' of the value

Thanks for your help!

Was this reply helpful? Yes No
Verified answer

H V 351 on at

Like (3)

Report
Copy link

Link copied!
Hi,

Please follow below steps to create notes into Dynamics 365 from OneDrive:

Step 1: Get File Content(One Drive)

Step 2: Select Parse JSON

- Content: add "[ File Content "

- Schema: Click on 'Generate from Sample' and add below code.

[{ "$content-type": "image/jpeg", "$content": "Test Content" }]

Step 3: Create a note record

- Document: Select $content

- Mime Type: $Scope-type

Hope this helps!

Was this reply helpful? Yes No
fernando.campos@sof... 35 on at

Like (0)

Report
Copy link

Link copied!

Oh thanks!!

It worked just fine!

Why do I need to use File Content as an array?

--> Content: add "[ File Content ]"

Thanks!!!

Was this reply helpful? Yes No