Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Error to using Power Automate in Power BI desktop

Hello, 

 

I try to use the Power Automate into Power BI to send a e-mail but doesn´t work, 

 

The error mensage is: The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.

 

Anybody can help me?

 

Thanks a lot.  

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello, datadmin-austin 

     

    I have this flow, at On Power Bi button clicked :

     

    {
        "kind": "ApiConnection",
        "splitOn": "@triggerBody()['rows']",
        "inputs": {
            "schema": {
                "type": "object",
                "properties": {
                    "rows": {
                        "type": "array",
                        "items": {
                            "type": "object",
                            "properties": {
                                "entity": {
                                    "type": "object",
                                    "properties": {
                                        "Power BI values": {
                                            "title": "Tabela do Power BI",
                                            "type": "array",
                                            "items": {
                                                "type": "object",
                                                "properties": {
                                                    "EMAIL": {
                                                        "title": "Tabela do Power BI EMAIL",
                                                        "type": "string"
                                                    }
                                                },
                                                "required": []
                                            }
                                        }
                                    },
                                    "required": [
                                        "Power BI values"
                                    ]
                                }
                            },
                            "required": [
                                "entity"
                            ]
                        }
                    }
                },
                "required": [
                    "rows"
                ]
            },
            "host": {
                "connection": {
                    "name": "@parameters('$connections')['shared_powerbi']['connectionId']"
                }
            },
            "operationId": "PowerBiButtonClicked",
            "parameters": {
                "inputsPowerBiData": "{}",
                "pbi_source": "powerAutomate"
            },
            "headersSchema": {
                "x-ms-user-email-encoded": {
                    "title": "User email",
                    "type": "string",
                    "format": "byte",
                    "x-ms-dynamically-added": false
                }
            }
        },
        "metadata": {
            "operationMetadataId": "5111b358-6f68-43a0-8cac-28c622f1643a"
        }
    }
     
    this help us?
     
    Thanks