Data stores - OfficeDev/microsoft-teams-apps-staffcheckins GitHub Wiki
Staff Check-ins app uses Office 365 connectors to get manager and user information and uses a SharePoint list to store this information along with user details.
Following are data stores:
SharePoint List
Check-inSchedule
Check-inSchedule stores the details of all the check-ins scheduled by the manager.
| Name of Column | Type | Comment |
|---|---|---|
| Title | Single line of text | Id of the manager |
| ManagerEmail | Single line of text | Email id of the manager |
| CheckInType | Choice | Type of check-in i.e whether it is Scheduled or Ad-hoc |
| CheckInTitle | Single line of text | Title of the check-in |
| CheckinTeamName | Single line of text | Team name in which the manager wants to send check-in notification |
| UniqueIdentifier | Single line of text | Unique combination of team name & title |
| CheckinFrequency | Choice | Frequency of check-in i.e whether it is Daily or Weekly |
| CheckinDays | Choice | The days in which user should check-in |
| CheckinTime | Single line of text | Time stamp at which user should check-in |
| ManagerNote | Multiple lines of text | Note from the manager to end-users as a part of notification |
| TeamId | Single line of text | Team id of selected team |
| ChannelId | Single line of text | Channel id of selected team |
| CheckinDaysConcat | Single line of text | Concatination of selected days |
| CombinedIdentifier | Single line of text | Combination of Team name,check-in frequency & check-in time |
UserCheck-ins
UserCheck-ins list stores the details of all the check-ins of users.
| Name of Column | Type | Comment |
|---|---|---|
| Title | Single line of text | Id of the user |
| UserName | Single line of text | Name of the User |
| UserEmail | Single line of text | Email id of the user |
| UserGivenNotes | Single line of text | Updates from the end user regarding check-in |
| UserCheckinPicture | Multiple lines of text | Picture checked-in by user |
| UserLatitude | Single line of text | Latitude of the user's check-in address |
| UserLongitude | Single line of text | Longtitude of the user's check-in address |
| UserCheckinAddress | Multiple lines of text | User's check-in address |
| UserCheckinTeam | Single line of text | Team name of the check-in |
| UserCheckinTitle | Single line of text | Title name of the check-in |
| UniqueIdentifier | Single line of text | Combination of UserCheckinTeam and UserCheckinTitle |
| UserCheckinSchedule | Single line of text | Type of the check-in |
| CreatedDate | Single line of text | User check-in date |
Flows
- Staff Check-ins Schedules Adaptive Card: To send an adaptive card in teams for scheduled check-in request.
- Staff Check-ins Adhoc Schedules Adaptive Card: To send an adaptive card in teams for ad-hoc check-in request.
- CheckinUsersReportExport : To export the user check-in record from the last 7 or 30 days.
- GetMyCheckInSchedules : To fetch Schedules created by Managers/Admin from SharePoint to Power App.
- StaffCheckinReports : To fetch all Check-ins performed by Manager/Admin's Staff from SharePoint to Power App.
- StaffCheckinTeamsReports : To fetch Check-in's of a particular Task from SharePoint to Power App.
Office 365 Users
Office 365 Users connector provides signed-in user information. The attributes which we are using in this app are:
-
Email id: Email id of the signed-in user
-
Name: Display name of the signed-in user
Office 365 groups
Office 365 groups connector provides a list of all the O365 groups owned by the signed-in user.
Microsoft Teams
Microsoft Teams connector provides selected team information.
Bing Maps
Bing Maps connector provides user location information.