
Hello there,
Need a helping hand again here. We are developing a Helpdesk application for various department. The User form is common across all departments. But each department has its own SharePoint list. On the user screen we have two option.
1. Creating a ticket
2. Viewing tickets
Our requirement is when user creates a ticket, based on the department, we need to patch the respected department Sharepoint list. Example, if the user raise a ticket for IT department, the IT deapartment list must be patched. If user select HR department, HR dept. sharepoint list must be patched.
Likewise, when the user go and view their tickets, the gallery must be pulling the data from where ever the his/her data exists in the list based on the his email id.
Is that possible ?
Plan B:
if i do that in single SharePoint list, we have auto ticket number generation challenge. Because each department needs a ticket number in specific format. The department want their department id to be prefixed with the ticket number. I am not sure if this is possible, because in SharePoint list i worked on autogenerating number for predefined format, and not dynamic based on any condition.
Please guide which one would be feasible and most suitable.
Plan B should be better.
For Plan A:
Do a Switch or a If to choose the department of the user and, deppending of the department, you do a different patch. To view the tickets I would say you have 2 options:
1. Create a screen with all departments and when the user selects one, you navigate to a certain screen that has the gallery of that department
2. Create a nav bar with the name of the departments and, when you click on "Systems", for example, you show the Systems gallery and hide the others. When you click "Power Apps", you hide the others and show "Power apps" and so on
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!