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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Can I export Sharepoin...
Power Automate
Unanswered

Can I export Sharepoint data as dashboard by Power Automate

(0) ShareShare
ReportReport
Posted on by 30

I would like to export automatically Sharepoint's data as dashboard by power automate.

I knew that it can be done by Power BI but we can't use PowerBI.

So I would like to know whether it can be done by Power Automate.

Any suggestion , please.

 

Categories:
I have the same question (0)
  • takolota1 Profile Picture
    4,974 Moderator on at

    @PannEiSan 


    Usually you can use some Power BI capabilities and share it with others without a lot of licensing. Are you sure it’s not an option?

    https://devoworx.net/publish-power-bi-to-web-step-by-step/#:~:text=Publish%20Power%20BI%20to%20web%20allows%20anyone%20with%20a%20web,sign%20in%20to%20Power%20BI.

     

    Otherwise…

    What do you mean by dashboard? Can you provide some specifics on what you want?

     

    How much data is involved with this? Less than several hundreds of thousands of rows?

     

    Can you maybe use Excel, pivot tables, & pivot charts?

     

    Or maybe if you are up for some more detailed programming, you could generate html charts 

    https://www.w3schools.com/ai/ai_chartjs.asp
    And then host them as a webpage using a flow like so

    https://youtu.be/ePwHNz4laRQ

  • PannEiSan Profile Picture
    30 on at

    Thanks for your reply.

    Yes, I can use excel.

    I mean dashboard that I want to express as pivot charts or pivot table in excel .

    I knew that sharepoint data can be exported as csv or excel by power automate.

    I would like to know that output can be expressed as pivot charts or pivot table in excel .

     

  • takolota1 Profile Picture
    4,974 Moderator on at

    Are the end users internal or external to your org?

     

    Another way of asking, can they pull in data through Power Query, or will you need to push all your data to staging table(s) in a copy of a template Excel file?

  • PannEiSan Profile Picture
    30 on at

    I think, internal.

     

  • Verified answer
    takolota1 Profile Picture
    4,974 Moderator on at

    @PannEiSan 

     

    Okay, then you should be able to set up a shared Excel workbook with some tables imported from the SharePoint list using Power Query. Then you can create pivot tables & charts from that.

    https://youtu.be/0aeZX1l4JT4?si=f1FeV2t_z1TkA0Jv

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard