Filter Outlook Calendars using CalendarGetTablesV2

(0) Share

Report

Posted on by AndreaPRJ

Hello everyone.

I would like to create an app in powerapps that allows me to view the appointments of some Outlook calendars.

I have done several tests and everything works for me.

What I can't do is:

- Filter only a few calendars in my calendar chooser combobox (I want to filter the calendars and NOT the events!)
- Filter Outlook calendars through fields that are not the usual two "id" and "name"
- Filter only 365 calendars that have a certain attributes (entered by the IT department) for example in the CustomAttribute1 field

Is it possible to do so?

When I try to use a Filter formula with CalendarGetTables(V2) I see only name and id (and owner)

For example this works well, but I would need more:

 Filter( Office365Outlook.CalendarGetTablesV2().value, name = "Calendar")

If I launch this in OnStart:

ClearCollect(colCalendars,
Office365Outlook.CalendarGetTablesV2()
);

then I see this where only see "id" and "name" attributes for my calendars:

Thank you in advance

Bye

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Artur Stepniak 1,539 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello,

you receive this output, because the function that you're using outputs only those informations. The only option to get more data is to use a custom Graph API call. Here's an example:

HTTP Request

To get the properties and relationships of a calendar object, you can use the following HTTP request:

GET https://graph.microsoft.com/v1.0/me/calendars

Request Headers

You need to include the following headers in your request:

Authorization: Bearer {token}

Example Request

Here's an example of a request to get the signed-in user's default calendar:

GET https://graph.microsoft.com/v1.0/me/calendars

Example Response

If the request is successful, you'll get a response like this:

{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#me/calendars", "value": [ { "@odata.id": "https://graph.microsoft.com/v1.0/users('user-id')/calendars('calendar-id')", "id": "calendar-id", "name": "Calendar", "color": "auto", "changeKey": "change-key", "canShare": true, "canViewPrivateItems": true, "hexColor": "", "canEdit": true, "allowedOnlineMeetingProviders": ["teamsForBusiness"], "defaultOnlineMeetingProvider": "teamsForBusiness", "isTallyingResponses": true, "isRemovable": false, "owner": { "name": "Owner Name", "address": "owner@example.com" } } ] }

You'd need to explore the API more to get the data that you'd like to have. :-) You can use Graph API explorer for testing: https://developer.microsoft.com/en-us/graph/graph-explorer.

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Was this reply helpful? Yes No
AndreaPRJ 64 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer.

Can you tell me if these calls can be made directly inside the powerapps?

If so, can they be launched through a Power Automate flow or what?

PS:however, I fear that this path is difficult to follow: HTTP calls are premium and it would mean licensing all users who will use my application with that license... I don't think they will agree

thanks again

Was this reply helpful? Yes No
Verified answer

Artur Stepniak 1,539 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello,

you'd need to use Power Automate flow for that and yes, that's correct, you'd need to use premium connectors. It's not possible to get the data that you want within the standard connectors available.

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Was this reply helpful? Yes No