Forum Discussion

Fabrice Frachon's avatar
Fabrice Frachon
Icon for Microsoft rankMicrosoft
Jun 28, 2019

I would like to pass to Sharepoint>Create file, a variable of type Object to the File Content param

In my flow, depending various conditions I am using distinct templates to create a word document, using "Populate a Microsoft Word template". For each case, I store the created file in a variable...
Microsoft Flow
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Jun 28, 2019

Hi Fabrice Frachon 

 

Can you show a sample of your Flow please? If you can show an example how you use the MS Word template connector and how you are saving it, we can use that to track down the issue.

 

Cheers

Damien

  • Fabrice Frachon's avatar
    Fabrice Frachon
    Icon for Microsoft rankMicrosoft
    Jun 28, 2019

    Thanks for reaching out Damien_Rosario 

     

    1. Initialize variable
    Name: wordDocument
    Type: Object
    Value:

     

    2. Populate a Microsoft Word template (preview)

     

    3. Set variable
    Name: wordDocument
    Value: Microsoft Word Document (from step #2)

     

    4. Create file (Sharepoint)
    File Content: I cannot use the 'wordDocument' variable. I can only pass 'Microsoft Word Document' from step 2

    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      Jun 28, 2019

      Hi Fabrice Frachon 

       

      Hopefully I understand the issue. Maybe try checking these items?

       

      1. Have you put the text fields into Word template where the inserted text needs to go? Have you named each box appropriately?

       

      The custom box names should appear in Populate a Microsoft Word template In MS Flow.

       

       

      2. Have you then inserted values (e.g. your variables) into these boxes in MS Flow?

       

      3. When you Create file, the output has to be 'Microsoft Word Document' from the Populate a Microsoft Word template as that has the variables you have added in (1).

       

      Here's a diagram that I hope illustrates the point in Flow.

       

      You can insert your variables into the Populate a MS Word template fields above

      Hope that helps?

       

      Cheers

      Damien

       

      EDIT: P.S. I should add that I do not believe the variables will be recognised as appropriate file content thus the issue. You'll need the variables to be input into the Populate a Microsoft Word template connector before creating the file.

      • Fabrice Frachon's avatar
        Fabrice Frachon
        Icon for Microsoft rankMicrosoft
        Jun 28, 2019

        My issue is not with creating Word documents using templates. I am able to create and save Word documents and using variables to populate the template.

         

        What I cannot do, is use the Word document that I placed in a Microsoft Flow variable, as an input later in my flow to save the File or to attach to an email (again my scenario is that the Microsoft flow variable is used to support that, depending conditions, the Word document is different).

Resources