Answered

Office365.CalendarGetTables().value gives blank dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Im having trouble getting my calendar from the Office365 Outlook connector.

I have added the connector as a datasource, added a dropdown menu, and put the formula(Office365.CalendarGetTables().value) in the items field, yet i get no options from the drowndown menu and no available selections.

Here's the oddball:

When i enable the birthday calendar in the Outlook Online settings, this calendar will show up in the powerapp. As soon as i disable it(birthday calendar) again, my normal calendar is available for a few minutes, before dissapearing, and the dropdown becomes blank and no options may be selected.

Any ideas on why this happens and how it might be solved?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Do you have a session id you can share when this had occurred?

https://aka.ms/pa/sessionid

Does Office365.CalendarGetTables().value correctly show in other controls: data table, combo box, radio, etc.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you mean that the normal calendar could not show up if you turn off the "Birthday" calendar within your Outlook setting?

Based on the needs that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Based on the issue that you mentioned, I think this issue may be related to the result the Office365.CalendarGetTables().value formula returned is not updated in real time.

As an alternative solution, I think a Timer control could fix your issue. I have made a test on my side, please take a try with the following workaround:

Set the OnStart property of the App control to following:

ClearCollect( CalendarCollection, Office365.CalendarGetTables().value )

Add a Timer control within your app, set the Duration property to following:

1000

Set the AutoStart property and Repeat property to following:

true

Set the OnTimerEnd property to following:

ClearCollect( CalendarCollection, Office365.CalendarGetTables().value )

Set the Visible property to following:

false

Add a Dropdown control, set the Items property to following:

CalendarCollection

please take a try with above solution, then re-publish your app, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Mr-Dang-MSFT Thank you for your reply. The session id: c8284062-6a51-4ef8-b15d-2a6e2d1a7bed
Usually, this command and controll gave me a list of my available calendars, but now they dont show up.
I go into my Outlook Online settings, and toggle on birthday calendar.
I save and close the app.
I reopen the app in edit mode,
Both calendars now shop up, my regular appointmentcalendar and my birthday calendar.
I wait a few minutes, aaaaaaand its gone:
The "Regular" calendar is no longer available

@v-xida-msft
I tried your suggestion but it made no difference sadly. I can now only see the birthday calendar and not my standard calendar anymore.
Timer suggestion did not work sadly.
As soon as i toggle off the birthday calendar, i will once again have no options.
@Mr-Dang-MSFT and @v-xida-msft Thank you both for taking the time to answer, any other ideas i might try to fix this? I find it very odd that my regular calendar(called "Kalender") shows up temporarily and then dissapears.
Have a nice day!

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Currently, I could not reproduce your issue on my side.

Please consider re-create a new connection to your Office 365 Outlook connector within your app, then try it again, check if the issue is solved.

If the issue still exists, please consider submit an assisted support ticket for help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft I tried re-adding the connection in the app, and in the environment im working in. Both work temporarily but dissapear after a few minutes.

The ticket system sends me into an infinite log-in loop. By this i mean i click, your link, click support ticket, i have to log in, then im back at post in general forums. Its like the link automatically signs me out or something.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It has been solved. Im not sure how, but what i did was to connect to powerapps outside our office via a 4g connection and now it works. Maybe some sort of firewall issue at our office but it seems to be working as it should now. Thanks for all the help.

Was this reply helpful? Yes No