cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jcarlsen
Level: Powered On

Office365.CalendarGetTables().value gives blank dropdown

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Jcarlsen
Level: Powered On

Re: Office365.CalendarGetTables().value gives blank dropdown

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.

View solution in original post

6 REPLIES 6
PowerApps Staff Mr-Dang-MSFT
PowerApps Staff

Re: Office365.CalendarGetTables().value gives blank dropdown

@Jcarlsen ,

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.

Community Support Team
Community Support Team

Re: Office365.CalendarGetTables().value gives blank dropdown

Hi @Jcarlsen ,

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:1.JPG

 

2.JPG

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jcarlsen
Level: Powered On

Re: Office365.CalendarGetTables().value gives blank dropdown

@Mr-Dang-MSFT Thank you for your reply. The session id: c8284062-6a51-4ef8-b15d-2a6e2d1a7bed

1.JPGUsually, 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,

2.JPGBoth calendars now shop up, my regular appointmentcalendar and my birthday calendar.

I wait a few minutes, aaaaaaand its gone:

3.JPGThe "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.

4.JPGTimer 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!

 

Community Support Team
Community Support Team

Re: Office365.CalendarGetTables().value gives blank dropdown

Hi @Jcarlsen ,

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jcarlsen
Level: Powered On

Re: Office365.CalendarGetTables().value gives blank dropdown

@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.

 

Jcarlsen
Level: Powered On

Re: Office365.CalendarGetTables().value gives blank dropdown

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.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,637)