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

Announcements

News and Announcements icon
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

    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

    @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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard