Unanswered

Outlook calendar events into Power bi

(0) Share

Report

Posted on by send2mark

505

I was successful in creating a flow that emails me a list of calendar events within a certain time using Get calendar view of events (V3) - Select - Create HTML table - Send an email (V2). Done

Now I want to take it a step further and take that same info that I pulled from the action Select and enter it into a Power bi action called Add rows to a dataset which I created a Streaming dataset.

I keep getting Apply to each added and errors. I am hoping someone can help me get this info in there.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@send2mark Can you please post the screenshot of your Flow and the Error message?

Was this reply helpful? Yes No
Verified answer

send2mark 505 on at

Like (0)

Report

Thanks for the reply, but I got it figured out somehow. After starring at the screen and trying different things I eventually got one to work.
Using the Apply to each I used outputs('Get_calendar_view_of_events_(V3)')?['body/value']. I think that is the same as the dynamic content called List of values.

I was then able to move forward.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@send2mark I am glad that the problem is resolved 🙂

Was this reply helpful? Yes No
Chris_at_3Seven 4 on at

Like (0)

Report

@send2mark, do you mind sharing your flow details? I'm trying to figure out how to use a fully populated calendar to create a timesheet report in PowerBI and it sounds like you went down this road already.

I tried connecting PBI to exchange but am getting stuck on how to account for recurring meetings (since it doesn't surface the instances, only first meeting). I get what I need when I export a csv file of my calendar and was hoping to automate that process for all users.

Thanks!

Was this reply helpful? Yes No