Unanswered

Obtain Outlook Calendar events and write to SQL

(0) Share

Report

Posted on by alex93jansen

101

I have a basic Time Tracking app with CRUD operations, which is connected to a SQL database. Users create and update records through a form which they can submit.

I'd like to add a feature where, by clicking one button, a user can have all of their Outlook Calendar events pulled for a specific day, which the app will automatically write to a SQL table. The only information I need to capture from these events are the day and duration of the meeting. There should be a unique record for each meeting, e.g. if a user had 5 meetings today, it should create 5 separate records.

I'm not really sure where to start with this though. The purpose of this new feature is to reduce the amount of time it takes for users to log their activities, so I want to automate as much as possible, i.e. there should be no individual forms to go through.

Does anyone have any thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (0)

Report

Hello alex93jansen,

I think you could achieve this using Power Automate.
You could create a Power Automate flow that is triggered from your app.
Using the Office 365 Outlook connector, you can retrieve the calendar entries in a specific time frame. Then, you can create a record in your SQL database for each entry.

Was this reply helpful? Yes No
alex93jansen 101 on at

Like (0)

Report

I thought about that, however the PowerApps (manual) trigger doesn't allow for any input data, e.g. I want users to be able to only write the Calendar data to SQL for the date they have selected. E.g. if it's Tuesday, a user may want to write the event data for Monday, but not for Tuesday because their Calendar can still change throughout the day.

Was this reply helpful? Yes No
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (0)

Report

Hello @alex93jansen,
Actually the Power Apps trigger should accept parameters. When you set up your flow, you can select "Ask in PowerApps" as a Dynamic Content:

When you link your flow in your app, you should be able to provide the input, e.g. a date, as an argument in the Run formula:
You can find more information here (also the source of the pics above): https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Was this reply helpful? Yes No