Power Platform Community Forum Thread Details

I'm creating a Flow to perform a follwing task:

-get information from a Form as this is submitted;

-fill this information in a Excel Template and save it in Onedrive;

-get this excel file created and convert to a PDF.

I am facing 2 issues here:

1st) the template is not been fulfilled with the information from Form (the file has been saved in the correct folder but empty);

2nd) CONVERT XLSX to PDF is returning an error ( "Cannot open the document, invalid type of file.")

I have to send this pdf by email to the submitter's manager and HR but the flow didn't to this point because it stops before.

Here is the picture from this part fo the Flow that isn't working.

Hope someone could help me on these issues!

Categories:

Using flows

Hi @Michael_Dias ,

How did you configure the template? Please share more details about your template.

I made a test on my side and it worked properly. Please refer to my steps and try again.

With regard to your flow, I have three points to mention:

1. When configure the template in plumsail.com, you need to surround the properties with double braces. In addition, you should test the template in plumsail.com by JSON data to ensure the template work.

2. The template file won't be modified, the data is only filled in the new-created XLSX file.

3. The Document Content of 'Convert XLSX to PDF' action must be the Result File dynamic content from 'Create XLSX document from template' action, rather than the name of XLSX file.

Hope this helps.

Sik