cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
turbofred69
Frequent Visitor

Blank value sent by Power BI to the flow triggered from the report

Hi 

 

I want to trigger a flow from a pPowerBI report to store records with incorrect / blank data in a Sharepoint list

 

Using the assistant, it is working fine at the beginning and the flow trigger receives the expected data

 

{
  "type""object",
  "properties": {
    "rows": {
      "type""array",
      "items": {
        "type""object",
        "properties": {
          "entity": {
            "type""object",
            "properties": {
              "Power BI values": {
                "type""array",
                "items": {
                  "type""object",
                  "properties": {
                    "Part ID A": {
                      "title""Power BI data Part ID A",
                      "type""string"
                    },
                    "Part ID B": {
                      "title""Power BI data Part ID B",
                      "type""string"
                    },
                    "HSCode": {
                      "title""Power BI data HSCode",
                      "type""string"
                    }
                  },
                  "required": []
                }
              }
            },
            "required": [
              "Power BI values"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}
 
But after some changes and refinements of the flow (done though teh Power BI screen), no more data are passed and the schema looks corrupted.
{
  "type""object",
  "properties": {},
  "required": []
}
I can't find any way to reinitlize it. Can anymone give me some hint?
 
BR/
Frederic
 
0 REPLIES 0

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors