Data Stores

Visitor Management app uses Office 365 connectors to get logged in user information and uses SharePoint lists to store this information along with other input details.

Following are data stores used in the app:

SharePoint List

Visitor List

Visitor list stores the details of both host and visitor.

Name of Column	Type	Comment
Title	Single line of text	Id of the host
BranchLocation	Single line of text	Location of host's branch
HostName	Single line of text	Name of the host
HostEmail	Single line of text	Email id of the host
VisitorName	Single line of text	Name of the visitor
VisitorContact	Single line of text	Contact number of the visitor
OrganizationDetails	Single line of text	Name and address details of the visitor's organization
ArrivalDateAndTime	Date and time	DateTime stamp when the visitor is supposed to arrive
PurposeOfVisit	Multiple lines of text	The purpose of the visitor
VisitorRequestStatus	Choice	Current status of the request i.e whether the request is in a pending state or confirmed or acknowledged or deleted
HostNotes	Single line of text	Comment or note given by host while acknowledging the request
RequestType	Choice	Whether the type of request is scheduled or walk-in
NotifiedCount	Number	Number of times host gets notified
NotifiedAt	Date and time	DateTime stamp when the host gets notification
AcknowledgedAt	Date and time	DateTime stamp when the request is acknowledged
RequestStatusInternal	Choice	To trigger flow based on the status to send an adaptive card to host once security team confirms request
UniqueRowIdentifier	Single line of text	Unique GUID for each request

Branch List

Branch list stores the details of all the host branches.

Name of Column	Type	Comment
Title	Single line of text	List of locations of host branch

Flows

• Visitor Management Confirmation: Notify the Security team about a new request.

• ConfirmationFlow: Notify host about successful approval of the request.

• NotifyHostOfVisitor: Notify host about the user's arrival.

• Visitor Management User Gallery

• Visitor Management Security Team Gallery

Office 365 Users

Office 365 Users is the Office 365 connector which provides logged in user's information. The attributes which are being used in this app are:

• Email id: Email id of the signed-in user

• Name: Display name of the user