Unanswered

Build Flows to get all Task list in To do

(0) Share

Report

Posted on by N.-03120651-0

Hello, I want to connect To Do and Power BI using the following idea: Create a flow that automatically generates a JSON file containing information from all tasks in “To Do” and saves it into a SharePoint folder. Power BI will connect to the JSON file, and I will build an analytical report based on that data. However, I have not been able to build the flow to extract this information yet. Please guide me.

Thank you,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,194 Most Valuable Professional on at

Like (1)

Report

Hi @N.-03120651-0,

You can also directly connect to the Graph API from Power BI, via the Web.Contents method. So, you don't need a Power Automate flow for this to get data from that data source.

Below are a couple of examples:

https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

https://www.thomweide.nl/2024/09/use-graph-api-data-in-power-bi-microsoft-intune/

Or do you have a specific reason you want to store the data on SharePoint first?

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
N.-03120651-0 3 on at

Like (0)

Report

Thank you. I want to use Power Automate because I want to build a work-management table from employees through To Do. Is there any simpler way to retrieve all tasks from To Do?

Was this reply helpful? Yes No