web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate Visual ...
Power Automate
Unanswered

Power Automate Visual in Power BI - Update SharePoint List Item

(0) ShareShare
ReportReport
Posted on by 35

Hello,

 

I have a table in Power BI that brings in data from multiple sources. I have created a SharePoint list where the columns are exactly the same as the columns the Power BI table. I am manually exporting the data to excel and then using a flow to add/update the items to SharePoint. I would like to automate this by using the Power Automate visual in Power BI to update items in SharePoint. Can anyone share the steps on how to build this flow? 

 

Thanks!

Categories:
I have the same question (0)
  • JenniferSilva2 Profile Picture
    8 on at
    Re: Power Automate Visual in Power BI - Update SharePoint List Item

    I have the same doubt, in the power automate visual I cant see the fields of Sharepoint and neither construct the composes. But in Power automate web what I cant see is the power bi dataset. Anyone have a clue of how to procedure? 

  • gregmarbais Profile Picture
    108 on at
    Re: Power Automate Visual in Power BI - Update SharePoint List Item

    @dani2 So, I've done this a bit in the past - I ended up using a PowerApp to do what I was initially using a flow to do (I found my users were not batching updates - they were doing individual updates and wanted to be able to add other data at the same time - so it's not the exact same that you're doing).

    I think you need to break it down into 2 steps - the Power BI visual essentially passes the data to the Power Automate flow - so you don't need the SharePoint columns at that point - you just need to make sure you pass all of the appropriate data to the flow - any field that you'd want to add or update in your SharePoint list. Once you do that, you can head to the flow.

    From the flow, you'll be able to see the columns you passed through from Power BI and that's where you'll map those fields to the SharePoint columns and add items or iterate over the existing rows in SharePoint if you're updating data. That part can be complicated because you're looking up rows in SharePoint based on what PowerBI fed the flow but it's possible.

    There aren't great videos for your specific use case but here's a good one that looks at the Power BI data coming into a flow and how to manipulate it (in the video it's about generating and sending an email - SharePoint will be a bit more complex): https://youtu.be/KtKJGZArq9w

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard