Unanswered

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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Reina_CP 21 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Reina_CP 21 on at

Like (3)

Report

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!

Was this reply helpful? Yes No
Jojojojojo on at

Like (2)

Report

Hey thanks for the reply!

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

Was this reply helpful? Yes No
jdwood44 3 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
@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]" ] } }

Was this reply helpful? Yes No
Debbie E 62 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
power_ap 46 on at

Like (0)

Report

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!

Was this reply helpful? Yes No