Forum Discussion
Using Power Automate and Syntex to create document with multiple tables HELP?
I work for a performing arts organization, and we manually create documents ("one sheets") related to performance information in tables like casts, crews, chorus details, etc. See the example pictur...
rsderby Sorry to say I don't have a solution for this. I'm having the same problem and been hunting for a solution for many months now. I want to create an invoice that has a table with each billable item as a row in the table but I can't find any examples how to populate the table. If I use the list columns from a 'get items' it goes into a 'Apply to Each' loop so tried the 'Select' Data Operation and 'Create HTML table' and various array variables and JSON formats but it always fails.
It works if I manually create the doc via the library but not via power automate.
Has anyone succeeded in using tables?
- spucelik
Microsoft
Wayne_Addison you can use a Data Operation -> Compose method to bind the items to a table in content assembly.
Hi spucelik and all on this thread, I've been meaning to try your solution but have been getting a brand new problem when creating the template. Whenever I define the table field I get this error:
It started happening around the time MS switched new Syntex licencing from per-user to PAYG. I thought I'd be ok as my per-user was valid until Apr-2024 then I just saw this...
So MS could be switching off content assembly (or at least any new features) unless you are on PAYG even if you have a legacy per-user licence. Are you guys per-user or PAYG?
Wayne_Addison I have noticed that when you do configure PAYG if you were previously PUPM, the templates need to be redeployed and published to the library. Content assembly does work with the straight PAYG billing configuration.
Try creating a new template and publishing it to a library. That should work.
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.
