How to: Run Query against a data set -> Populate SharePoint List

[Jojojojojo]

Hey there, newbie here~

I'm looking to take a PowerBI dataset and push the data into a SharePoint list on a daily basis. 

After running the query against the dataset, I'm a bit lost...
I was hoping anyone would be able to give me a hand with the steps I'd need to take in populating the SharePoint list below with the Query above..!

Thanks,

Jojojojojojojo

[Reina_CP]

Hi there! were you able to figure this out? this is actually what I trying to do 😁

[Reina_CP · Accepted solution]

Its me again! 

I manage to solve it following this video:

https://www.youtube.com/watch?v=sXdeg_6Lr3o

Basically you create a csv file after you run the query, and then just need to parse it. After that you can add all the items from your table to the share point list

My flow looks like this

I going to be testing this but so far on my manuals runs it is working!

[Jojojojojo]

Hey thanks for the reply!

Yeah that looks great! Thanks for the solution, works for me 🙂

[jdwood44]

Hi, Jojojojojo. Would you mind sharing screen shots of your Parse JSON above (of course, feel free to redact any sensitive data)?

[Anonymous]

@jdwood44 

Here's what I ended up using. Note that when I generated this from a sample, it set all fields as required, I had to go back and edit that part since my data contains nulls.

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "RepsAll[LOB]": {
                "type": "string"
            },
            "RepsAll[SEQ]": {
                "type": "string"
            },
            "RepsAll[AgentID]": {
                "type": "integer"
            },
            "RepsAll[Name]": {
                "type": "string"
            },
            "RepsAll[Location]": {
                "type": "string"
            },
            "RepsAll[Coach]": {
                "type": "string"
            },
            "RepsAll[Manager]": {
                "type": "string"
            },
            "RepsAll[NTID]": {
                "type": "string"
            },
            "RepsAll[WPCode]": {
                "type": "string"
            },
            "RepsAll[P#]": {
                "type": "integer"
            },
            "RepsAll[TimeStamp]": {
                "type": "string"
            }
        },
        "required": [
            "RepsAll[Name]",
            "RepsAll[TimeStamp]"
        ]
    }
}

[debbieedwards]

I have used the same process. for some reason the csv ends up with a blank row at the end even though there are no blank rows coming through on the DAX Query so this is making the Parse JSON error.

I wonder if there is a way of getting rid of this empty field in the csv?

[power_ap]

New to Power Automate, came across this post b/c I was looking to do the same.

My solution is a bit different: basically I used output of PBI query to initialize a variable (which outcome is supposed to be an array), then I parsed JSON (I used PBI query result data and the "Generate from sample" function to create the JSON schema), after which I created SharePoint list. Tested and seemed work fine!