WF requirement lib

Question

Can you suggest the list and workflow logic for the below requirement:

Application Description:

Library - Is used issue checkout books to Organization employees. Employee can reserve a book online and pick it up from learning center. Books can be issued to the contract employees only on the approval mail of their immediate supervisor.

Classification:

BU : HR

Login Type : DOMIAN/user

Host : http://www.xxx.yy.com

URL : https://www.xxx.yy.com/sites/sc/subsite/Library/

Process Owner :

Process Flow description:

There are 2 modules in Library:

1. Admin module
2. Normal user module

User Module:

1. About Us: Displays about Library
2. Process: Displays about Library process
3. Search: Search based on Title, Author and Publishers
4. Reserve Book: User can reserve a book
5. Reserved Book Details: Displays reserved book details
6. Dues: Displays books dues
7. Request New Books: User can request new books
8. Others:
   a. Book Sellers: Displays Book sellers information
   b. External Resources: Displays External Resources
   c. Members: Displays Library Members and role
9. Home CD: Provides cd

Admin module:

1. House Keeping:
   Books:
   Add
   Edit
   Delete
   Change in Status:
   Issue
   Renew/Return/Cancel
   Status Update
   New Books:
   Send to Library Committee
   Pending for LibCom Approval
   Pending for Purchase
   Procured Book List
   Reports
   Book Sellers:
   Add
   Edit
   Delete
   Borrowing Facility:
   Add
   Edit
   Delete
   External resources:
   Add
   Edit
   Delete
   Members:
   Add
   Edit
   Delete

Application Tier : 3

Data classification [CIP]: Non-Confidential

Does application contain Intellectual Property Data? No
Is application Critical to financial reporting? No
Is application Critical to Manufacturing/Shipping? No
Is this application a Security/Authentication/Authorization Service? No
Does application retain Personal Data regarding users? No
Does this application contain Legal Data? No
Does this application service TI customers, suppliers or distributors from the internet? No
Is this application subject to SOX audit reviews? No

Data Fields:

LIBRARY_BOOKDETAILS LIBRARY_BOOKSELLER Library_Requestdetails
type_of_doc Slno request_no
accno shop_name requested_by
title Address requested_on
author1 contact_person supervisor_no
author2 Phone type_of_doc
author3 Fax title
author4 Email authors
author5 publishers
publisher LIBRARY_CIRCULATION isbn
publication_place Slno cost
yearofpublication emp_no indianedition
edition Accno benefits
collation Type concept
series issued_date existingbooks
isbn return_date copiespresent
no_of_pages mail_status up_to_date
notes reserved_date status
lcc_no denied_reason
cost LIBRARY_CIRCULATION_HISTORY sup_approval_date
date_of_procuring Slno libcom_approval_date
classification_no emp_no updated_by
subject1 Accno procured
subject2 Type procure_date
subject3 issued_date libcom_approved_by
status return_date libcom_denial_reason
msp_book mail_status librarian_send_date
url_of_book reserved_date librarian_send_by
cancel_date libadmin_app_status
cancelled_by year_of_publication
url_of_book
Library_Documenttype
type_of_doc Library_Externalresources
issue_type slno
description external_resource_name
Period external_resource_url

Library_Users
slno
emp_no
role
Process Flow Diagram:

I also attached flow diagram

Answer 1

Hi, @sns , your requirements are far more beyond the reach of a SharePoint library with workflows. You are trying to create a book manage system which will has its own authentication, database, search feature and additional operations on items(book).

You will need to use other tools like Power Apps or simply hard code with VS. SharePoint library is merely a file managing system, not a tool to develop a new app.

If you have access to PowerApps, you can post a new thread here in the Power Apps community for more help: https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

---

If the response is helpful, please click Accept Answer and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.