![]() Upper( _userDomain ) = Upper( Right( Result, Len(Result) - Result) ) ) The formula then filters out blank values from that set and adds the other values into a collection named AttendeeEmailsTemp.ĬlearCollect(AttendeeEmails) ClearCollect( AttendeeEmails, This formula concatenates the required and optional attendees into a single string and then splits that string into individual addresses at each semicolon. Split( ThisItem.RequiredAttendees & ThisItem.OptionalAttendees, " " ), This list discusses what each ClearCollect operation does:ĬlearCollect(AttendeeEmailsTemp) ClearCollect( AttendeeEmailsTemp, LookUp(Office365Outlook.CalendarGetTablesV2().value, DisplayName = " ![]() Set( _lastDayOfMonth, DateAdd( DateAdd( _firstDayOfMonth, 1, Months ), -1, Days ) ) Set( _firstDayOfMonth, DateAdd( Today(), 1 - Day( Today() ), Days ) ) ĭateAdd( _firstDayOfMonth, -( Weekday( _firstDayOfMonth) - 2 + 1 ), Days ) Set the OnStart property of the app to this formula: Set( _userDomain, Right( User().Email, Len( User().Email ) - Find( User().Email ) ) ) This change removes the need for the drop-down list of calendars, so you can remove it. If you already know which calendar your users should view, you can simplify the screen by specifying that calendar before you publish the app. If you want to modify the screen further, use the calendar-screen reference as a guide. You can modify the default functionality of this screen in a few common ways:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |