Note: The whole process logic is the same, the only different thing is that you need to pass your Excel table records as a JSON String from your canvas app to your flow.With interactive documents, you can choose from a range of predefined options for data, instead of typing the data from scratch each time. More details about passing JSON string from canvas app to Power Automate flow, please check the following video: In addition, within your flow, you could also do some modification to the converted JSON Table (using Select action or Parse JSON action) to meet the fields name you set in your Repeating section control. After that, you could apply the converted JSON table into the Repeating section field in your "Populate a Microsoft Word Template" action.
![auto populate word document proform auto populate word document proform](https://i.ytimg.com/vi/TBwQTXvcKrM/maxresdefault.jpg)
Within your flow, you need to use the jsonfunction convert the passed JSON Table string value into a actual JSON Table (array value). Then pass the converted JSON table string value to your flow. If you still want to use " Populate a Microsoft Word Template" action in your flow, please check and see if the following blog would help in your scenario:įirstly, you need to convert your whole Excel table records into a JSON Table string value using the JSONfunction in your canvas app. Hi on the needs that you mentioned, I think the solution I provided would achieve your needs better. More details about formatting table rows as a HTML Table, please check the following blog: More details about firing a flow from a canvas app, please check the following video resource: Please consider take a try with above solution, then check if the issue is solved.
Auto populate word document proform pdf#
The generated PDF file would be stored in your OneDrive folder, and looks like below: When press the "Upload" button from your canvas app, the above flow would be fired to create a PDF file. Set the OnSelectproperty of the "Upload" button to following: GeneratePDFFilebasedonHTMLtablepassedfromapp.Run(HtmlText1.HtmlText)
![auto populate word document proform auto populate word document proform](https://i.ytimg.com/vi/pv60ZIAJa54/maxresdefault.jpg)
Date FaceNumber Serie Client OrderNum Qty Cost Return date: " & DateAdd(Today(), 1, Months) & " Set the HtmlTextproperty of the Html Text control ( HtmlText1) to following: "Asset Checkout Notification" & Within your app, you need to create a connection to your above flow firstly. I have made a test on my side, please consider take a try with the following workaround: With the converted PDF file content, you could create your PDF file. Then you could add a "Convert file" action of OneDrive connector to convert the HTML file content into a PDF file content.
![auto populate word document proform auto populate word document proform](https://support.content.office.net/en-us/media/c79019c6-ba37-40cf-81c7-20e129db8189.png)
Within your Power Automate flow, you could create a HTML file based on the passed HTML text value in your OneDrive folder. Then you could pass the generated HTML Table string value to your Power Automate flow. Instead, I think a HTML Table in a HTML file could achieve your needs.įirstly, within your canvas app, you could generate HTML table using Html Text control based on your Table rows. Hi you want to create a PDF file with repeating table based on the Table rows from your canvas app?īased on the needs that you mentioned, I think it is not necessary to populate a Word document with repeating content control. If someone could help me out, Thank you in advancedĭetails: FacNumber is the same in all the rows, Serie: is only a kind of document, Client: All the rows have the same Client, OrderNumber: is different in every row., (OrderNumber, Quantity, Cost) are fields of another table.
![auto populate word document proform auto populate word document proform](https://i.ytimg.com/vi/1Ev81TRgFBg/mqdefault.jpg)
The Details table is the following (excel) Date
Auto populate word document proform how to#
but when I see the repeating content section I don´t know how to do it., I have seen some videos using SP list, but in my case I am using an xls sheet on onedrive., so, I don´t have idea in order to solve this situation. I solved this using the "Ask to powerapps" solution. Hi everyone., I almost finish my app., One part is that I have to create a pdf file, So I watched a couple of videos in order to populate a word document using power automate., Then I did the template, I added all the content controls for the non repeating content with simple text holders.