Data stores - OfficeDev/microsoft-teams-apps-rapid-assist GitHub Wiki

The app uses the following data stores:

SharePoint Lists

  1. RA_CategoryList – Used for storing categories defined in the app.
Name of Column Type Comment
Title Single line of text Name of the category
CategoryID Single line of text Unique ID for each category.
  1. RA_CategoryTeamMapping – Includes mapping information between a category and the list of experts assigned to the category, associated channel name etc.
Name of Column Type Comment
Title Single line of text Name of the channel.
TeamID Single line of text TeamID where the app is installed.
CategoryName Single line of text Name of the category.
CategoryID Single line of text Unique ID for each category.
ChannelId Single line of text Unique ID for each channel.
Experts Single line of text Email addresses of the experts.
ExpertNames Multiple lines of text Name of the experts.
  1. RA_QnAPairs- Used to store QnA pairs that are displayed in the app.
Name of Column Type Comment
Title Single line of text It stores GUID values.
Questions Multiple lines of text Set of all possible questions.
Answer Multiple lines of text Set of all possible answers.
  1. RA_Requests- Used to store the created meeting metadata between End-users and Experts.
Name of Column Type Comment
Title Single line of text It stores GUID values.
MeetingLink Single line of text Link for specific meeting to connect with experts.
Category Single line of text Name of the category.
CategoryID Single line of text Unique ID for each category.
Description Multiple lines of text Detailed description for the queries
Question Multiple lines of text Assosciated question.
Status Single line of text Status of open requests created by users like whether it is open or closed.
  1. RA_TeamSettings- Used to store experts team id.
Name of Column Type Comment
Title Single line of text It stores Experts team name.
TeamId Single line of text Unique group ID.

Office 365 Users

Office 365 Users is the Office 365 connector that provides signed-in user's information. The attributes which we are using in this app are:

  • Email id: Email id of signed-in user

  • Name: Display name of the user