Unanswered

Outlook connector distribution list selection

(0) Share

Report

Posted on by baarsd

Hi,

I have been taking a look at the template for a room booking system (in Power Apps > Create > Book a Room). This uses the GetRoomLists function of the Office365Outlook connector. This collects the room lists (which are really just a type of distribution list) with this command:

ClearCollect(RoomsLists, Office365.GetRoomLists().value);

Without resorting to making a custom connector to MS Graph, is there a way to get a different set of distribution lists - e.g. ones starting with "Vehicle".

The reason I'm asking is I'd like to be able to book vehicles (which we have as resource mailboxes in Exchange Online) via a Power App.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-siky-msft on at

Like (0)

Report
Hi @baarsd ,

If my understanding is right, you want to filter the list that start with "Vehicle", right?

The office365 has been deprecated, please change to use Office365 Office connector. Then, please try with this code:

ClearCollect(FilteredRoomsLists, Filter(Office365Outlook.GetRoomListsV2().value,StartsWith("Vehicle",name)));

Hope this helps.

Sik

Was this reply helpful? Yes No
baarsd 43 on at

Like (0)

Report
Hi @v-siky-msft
so under Data Sources, when I expand connectors the only Office365 ones I see are

- Office 365 Groups
- Office 365 Outlook
- Office 365 Users

I've added the "Office 365 Outlook" connector - which is https://docs.microsoft.com/en-us/connectors/office365connector/. It doesn't appear to be deprecated?

I inserted a gallery with its Items property set to

Filter( Office365Outlook.GetRoomListsV2().value, StartsWith(name,"Vehicle") )

Which returns 0 results - which I sort of expected given the distribution lists I'm looking for are not rooms. If I change that to

Filter( Office365Outlook.GetRoomListsV2().value, StartsWith(name,"Room") )

It works, because our Room distribution lists all start with "Room".

So your filter works - but only for Room lists, and not for standard distribution lists (which our vehicles use, they are not rooms). Is it not possible to search for normal distribution lists?

Thanks for your help!
Dylan

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report

Hi @baarsd ,

What I mean is that the Office365 connector has been deprecated and it is subdivided into three parts- Office 365 Groups - Office 365 Outlook - Office 365 Users.

The Office365Outlook.GetRoomListsV2() function can only get all rooms in tenant resource. If you want to get all distribution list, I am afraid it is not supported in PowerApps currently.

The only way is to create a custom connector based on Microsoft Graph API to implement your needs.

Please take a reference on this blog: https://gotoguy.blog/2017/12/17/access-microsoft-graph-api-using-custom-connector-in-powerapps-and-flows/

Sik

Was this reply helpful? Yes No