Forum Discussion
Using Power Automate and Syntex to create document with multiple tables HELP?
MicrosoftWayne_Addison you can use a Data Operation -> Compose method to bind the items to a table in content assembly.
Struggling with the same behavior. spucelik Wayne_Addison rsderby
I have a modern Syntex Template with a Table. The Template with Table is supported manually from SharePoint New Menu.
In Power automate action (Preview) "Generate document using Microsoft Syntex (preview)"
https://learn.microsoft.com/en-us/microsoft-365/syntex/automate-document-generation
microsoft wrote:
10. The action does not support images and tables and templates containing these fields are hidden while selecting the templates in the action.
But the Template with table is not hidden in the action (instead it is a required column) and therefore i have to add the Table Column Mapping from dynamic content. But this is not working in many variations, because i need a Apply to Each Array in the table mapping.
I guess how a Data operation compose could help for a dynamic repeating section to bind the table entries to the table in content assembly?
How can i get the action working with tables as expected?
Or does the action not working with tables as expected, because of preview state?
- spucelik
Consider the following Power Automate Example
- This action will first get items from a SharePoint library. Then add a Data Operation -> Select action to your flow. Notice that the "Map" values correspond to a table I have in my Content Assembly template columns. This will take the results from my SPO Library and save it this table structure.
2. Now you're ready to populate the smart template with values. Notice that for my table I'm simply taking the JSON output that is produces from the Data Operation and binding it to the table.
3. The result of this will be added to the table in the smart template.
spucelik thanks for your hints. But i can not get it to work. I fail to send the JSON-Objekt for the Table (from a get items select filter) to the TableField in the Syntex action. I always get
[{"ErrorMessage":"Answer for data type 'table' has wrong format.","HasError":true},{"ErrorMessage":"","HasError":false}]
clientRequestId: b65638ae-5dfb-4100-a224-0327f8c859dc
serviceRequestId: b65638ae-5dfb-4100-a224-0327f8c859dci also get this error when i try to update the Syntex-Template-TableField with a simple JSON-Object (single Item) like this one:
[
{
"Nr.": "1",
"Bereitzustellende": "Test",
"Detaillierte Erläuterungen": "Test",
"Anzufordern von": "Test",
"Stand": "offen",
"Bemerkung": "Test"
}
]Do you have a working example for a suitable JSON?
I tried this without success
Schneika Here are some screen shots of it working in my environment. There is also updated documentation to reference.
Here is the result of my Data Operation -> Select activity going against a library.
When binding the information to the template, here is the input values.
If you continue to have issues, I would open a support ticket and we can look at it in depth.
