Was wondering all you intelligent folks out there can help me on this one.
Overview: We have a SharePoint Library "Reports" that gets populated automatically with folders and files using another external system(don't have control to this system). The folders and files are copied to the library through "open in explorer" way. The structure of the folders are this way, Eg : Folder A610 - Folder pcl - File name (A610-pcl-May-16)
As you can see the Title has the format A610-pcl-May-16
Requirement from Business:
The business requires a custom landing page with three filters to search the files in the SharePoint library, the following are the filters,
1. Centre - which Corresponds to the A610 of the file name ( also they need full name like "A610 Visitors in Department"
2. Report Type - which Corresponds to the pcl of the file name
3. Division - this is tricky, for example they need a parent group say A6000 which consist of say A610, then A7000 which consist of A611 in them, so when users filter based on A6000 it should only return A610. Now this parent group is not available from the file name, will need to somehow use logic to create the metadata for it.
Solution tried: So firstly from the file name A610-pcl-May-16, I was able to create two new Calculated columns in the library called Centre and Report Type which strips out the A610 and pcl from it. That was great and working.
Now my challenge was to add say the full name to the Centre column like "A610 Visitors in Department" and to add a Division column which consist of the parent group name "A6000",
So ultimately when users see the filters, they would select
Division - A6000
Centre - A610 Visitors in Department
Report Type - pcl
this should return them the file name A610-pcl-May-16
Would be nice if somebody could guide me in the right path Thanks in Advance
Also new to StackExchange and excited!!! :)