Send Sharepoint file content to Child flow

[Angela23]

Hello experts

I am trying to send my file content from sharepoint to a child flow and create a file from child flow but I get errors all the time.
This is my Parent flow:

and this is my child flow:

Error:

your help will be appreciate a lot.
Regards 
Angela

@Pstork1 

[FLMike]

Hi

How come you are converting to Base64?

You are doing it as you pass it to the Child and within the child.

Have you tried doing it without converting as you pass it?

[Pstork1]

Files are sent between flows as Text encoded JSON records. But what file are you trying to send? You are using an Item trigger. Items can have 0, 1, or more attachments. So what file content are you trying to send? That will determine the dynamic content you want to send, but it probably won't be Body and it definitely won't be using Base64toBinary. When I get a few minutes I'll put together a quick sample with screenshots.

[FLMike]

It is actually the Body.

Specifically in his case its body('Get_file_content'), thats why I wondered why he was converting it to Base64

[Pstork1]

Here's a working set of screenshots based on when a file is created in a library.

Parent Flow

Child Flow Trigger

[Angela23]

Thank you for your answers @FLMike  and @Pstork1 
My file can be a Word or Pdf document.
Here I try to do As @Pstork1  demonstrated:

But I get this error:

[Pstork1]

As I mentioned earlier, are you triggering this on a list or a library?  If you look at my screenshot you can see its triggered on a file creation not an item creation. How are you getting the file content based on the item trigger since that doesn't include the file identifier.

[Angela23]

you are right @Pstork1 . I have a Document library and I need a trigger for my file, so *'ve changed it but still get this error:

[Pstork1]

When you hover over the file content what does the JSON look like?  

[Angela23]

@Pstork1 
when I hover over the body: body('Get_file_content')
But the JSON is very long:

Do you want me to download it for you? its more than 60.000 characters

[FLMike · Accepted solution]

@Angela23 

Please change the File Content (from the Run a Child flow), to this expression

body('Get_file_content')['$content']

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Angela23 · Accepted solution]

@FLMike and @Pstork1 
Bingo Its working now. Thank you soooooo much for your help

[Pstork1 · Accepted solution]

Nope, I thought maybe you were using the whole body.  it should be 

body('Get_file_content')['$content']

as @FLMike said.  Otherwise you are feeding the connection an object that contains the file instead of a record that is the file.  That's why you were getting the error.

[Angela23]

@Pstork1 @FLMike 
Hello again
Unfortunately the file is not saved correct 😞

Does is it has something to do with the file content?

[Pstork1]

Can you be more specific about what is wrong with the file?

[Angela23]

Sure, When a PDF is generated in the Child Flow from the file content received from the Parent Flow, it cannot be correctly opened.

[Pstork1 · Accepted solution]

You are trying to convert the file to PDF in the child flow actions. But the file you are saving to SharePoint uses the original file content that is passed to the child flow, which is not PDF.  You need to create the file using the file content from the Convert to PDF action.

[Angela23]

Thank you soooooo soooo much