Answered

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

Like (0) Share

Report

Posted on 10 Nov 2022 04:17:09 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

All responses (7)

Answers (1)

power_ap 46 on 26 Jul 2023 at 04:05:34

Like (0)

Report

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

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!
Debbie E 62 on 15 May 2023 at 09:43:37

Like (0)

Report

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

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?
Community Power Pla... on 07 May 2023 at 16:07:04

Like (0)

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

@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]" ] } }
jdwood44 3 on 17 Apr 2023 at 17:27:09

Like (0)

Report

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

Hi, Jojojojojo. Would you mind sharing screen shots of your Parse JSON above (of course, feel free to redact any sensitive data)?
Jojojojojo on 08 Jan 2023 at 23:03:46

Like (2)

Report

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

Hey thanks for the reply!

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

Reina_CP 21 on 27 Dec 2022 at 19:29:22

Like (3)

Report

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

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!
Reina_CP 21 on 27 Dec 2022 at 16:29:34

Like (0)

Report

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

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