Hi I would like to get some process flow or logic for the following problem,
- I have a company which works in three states, lets say states A,B,C
- In the company I also have team of employees work for each states, That is for state A, we have a group of employees, For B we have another group and same in the case of state B.
- For each states I have 5 different activities.
Now I have an admin for each state, who will upload the request into the system using a SharePoint portal in the form of an Excel sheet.
a. The admin will select in the site, which state, which activity and a flag whether the activity is priority or not.
b. All the requests will go to the document library for that state, and into the folder for that particular activity.
Now the real problem is, that excel sheets can contain 10 lines (each line is one activity - same kind) or 100 lines.
Now how can I distribute the requests (1 request is one line in the excel sheet) to the group for that country, on the basis of work load.
Please suggest me one possible flow to achieve this ?