Forum Discussion

rsderby's avatar
rsderby
Copper Contributor
Mar 03, 2023

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...
content assembly
process automation
Syntex
Steve Pucelik's avatar
Steve Pucelik
Copper Contributor
Sep 15, 2023

Schneika Here are some screen shots of it working in my environment.  There is also updated https://learn.microsoft.com/en-us/microsoft-365/syntex/automate-document-generation 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.

 

Schneika's avatar
Schneika
Iron Contributor
Sep 18, 2023

I dont see the updated reference yet
https://learn.microsoft.com/en-us/microsoft-365/syntex/automate-document-generation
published date is the older one from 03/15/2023.

But i have already raised a Power Platform Service Support Ticket for this issue, dear Steve Pucelik 

  • Mario_Fulan's avatar
    Mario_Fulan
    Iron Contributor
    Sep 18, 2023

    Schneika and Steve Pucelik I am still having the same error that Karl is having. I see the inputs to the create document are proper JSON format but I get the error 

     
    Error
    Action 'Generate_document_using_Microsoft_Syntex_(preview)_2' failed
    Error Details 
    [{"ErrorMessage":"Answer for data type 'table' has wrong format.","HasError":true}]
    clientRequestId: 3f4cb665-5663-4fa9-b185-b6c5b053f1b4
    serviceRequestId: 3f4cb665-5663-4fa9-b185-b6c5b053f1b4
     
    Here are the raw inputs to the create document with Syntex request - I've verified the heading match the headings in the Word document template (removed spaces to make sure that was not the issue):
    {
        "host": {
            "connectionReferenceName": "shared_sharepointonline",
            "operationId": "CreateContentAssemblyDocument"
        },
        "parameters": {
            "dataset": "https://xxxxxxx.sharepoint.com/sites/OperationalContentCenter",
            "table": "fc943c8d-db45-41a6-965a-ef63ff17f60d",
            "template": "0x0101005F1508AB448AD04A82198A206228038C006AC7F8A786B4374AB41FB6D8D957510A",
            "fileName": "MAP1.pdf",
            "item/msca602030TableSelection": [
                {
                    "Ameren Illinois": "OrgName",
                    "Larry Magelitz": "PrimaryContactName",
                    "Manager-Illinois Crisis Management": "PrimaryContactTitle",
                    "email address removed for privacy reasons": "PrimaryContactEmail"
                },
                {
                    "Ameren Missouri": "OrgName",
                    "Pam Harrison": "PrimaryContactName",
                    "Director, Missouri Gas Operations": "PrimaryContactTitle",
                    "email address removed for privacy reasons": "PrimaryContactEmail"
                }
            ]
        }
    }
     
    Have you found out anything through your support request inquiry?

Resources