As per this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-APPS-Calendar-getSchedule/td-p/344553 I'm trying to read the free busy information for a user using a custom connector. From testing the connector within the app it shows that it is retrieving the information correctly since I see it in the collection once it executes.
After the code executes I'm also able to get the users ID using this code:
ClearCollect( UserFreeBusyId, ForAll( UserFreeBusy.value, value.scheduleId ) );
However when I attempt to retrieve the start and end date and time of the calendar entry, it doesn't seem to work:
I was hoping that the same approach for accessing the nested data would work as per this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Understanding-Nested-Collections/td-p/336270 however it doesn't seem to be working. Any guidance appreciated. Thanks.
Solved! Go to Solution.
@Eelman , the errors are:
If I remove the dot after the scheduleItems the error goes away but it doesn't give me the nested data under the scheduleItems sub-collection.
@v-xiaochen-msft , as per this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Understanding-Nested-Collections/td-p/336270 I was trying to get to the next level of the collection under scheduleItems which in this case is either start, end or busy however when I add the dot it doesn't show me any of those columns. When I remove the dot the error goes away but it then does not give me the start and end dates of the schedule.
@v-xiaochen-msft , yes, the forall preview shows a table similar to yours:
I then used the ungroup function to try and get to the start and end date/time:
and this is what it gets me to:
I then tried to access the start date time using a variable:
And when I try to display the value of the variable it says that it is of type Table
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.