User Profile
AdamAtTheMuseum
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Extract metadata from excel and add to document library in folders
Hello I have been given 30,000 construction project files. Lucky me? They have come to me in folders in the following folder structure: ContractorName\DocumentType and the document title. For example: JimTheBuilder\Drawings\Drawing1.dwg JimTheBuilder\Drawings\Drawing2.dwg JimTheBuilder\Drawings\Drawing3.dwg JimTheBuilder\Specifications\Spec1.doc JaneTheContractor\Drawings\Elevation1.dwg JaneTheContractor\Reports\Report.doc etc etc The client has placed them complete with folder structure in a Document Library called AllVersionsArchive The client has also given me an Excel file with Metadata for each file. One row for each file, all on one sheet. She wants me to find a way to add the metadata to every file in the document library. There are three "fields" that are the same in the folder structure and the metadata. Folders: ContractorName\DocumentType\fileName Excel: ContractorName\DocumentType\fileName The file names are unique and can be used as a Primary Key the Excel file has extra metadata: description, status, shortName, ReceivedDate, IssueNumber, revisionLetter Its the metadata in blue that I have to add to each file in each folder. As I see it I need to: Go through the Excel data row by row, for each file, find the matching file name in the SharePoint document library attach the metadata. I have some basic PowerAutomate experience and I am OK with PoweShell. But Im not a programmer and need some help and pointers as to where to start. I have Googled around of course but its the requirement to go recursively through the folders to find a match that defeats me. I was also considering converting the files and folders into just one flat Document Library containg the fileName, ContractorName and Document type. I could then perhaps mathch the metadata more easily? Any ideas? Adam.920Views0likes0CommentsRe: SharePoint news from associated sites filter
I think you have spotted the flaw in my plan. The users do not have permissions on the other Department sites So all users will need read access to Department news. I am going to set up another Page on each Department site called Intranet news and give all users read access to that. Im not using Audience Targeting in this example.1.3KViews0likes0CommentsSharePoint news from associated sites filter
I am building a proof of concept Intranet page for work. Its very simple. I have a hub site called Intranet associated to the hub are three sites representing Departments Department 1 with one Member "User 1" Department 2 with one member "User 2" Department 3 with one member "User 3" All three users are members of the Intranet Visitors group i.e. they have Read access to Intranet and can access it no problem. All sites are Communication sites. All three sites have a custom column called "NewsType" from which the news poster can choose a Term called NewsType. The default value is Department but the news poster can choose "Intranet" instead if they wish the news story to show on the Intranet I have configured a News Web part with a Filter on the Intranet site to show any news item on the three Department sites if the NewsType column value has been set to "Intranet" When I look at the Intranet site as SharePoint Admin I can see all the news posts from the department sites that have been tagged as Intranet. So that is working just fine. But when my test users go to the Intranet site they only see news stories from their own department. I want them to see news from all departments, even if they are not a member if that news post has been tagged with the NewsType term "Intranet" Could I acheive that or is my proposed model fundamentally wrong? Adam.Solved1.4KViews0likes2CommentsMS Microsoft Graph PowerShell SDK to assign licenses in bulk from a csv file
Hello I have a .csv file with over 400 users in it in the form of the email address of each user. I need to assign a Microsoft 365 license to each user as a one-off process. They currently have three separate licenses, Windows 10, EMS and Office 365. I used to be able to use msol cmdlets but these have been deprecated and I can no longer use them. the cmdlets were Get-Content then ForEach Set-MsolUserLicence etc etc... But now I have to use MS Graph Powershell SDK (which I have installed) and for the life of me I cannot work out how to do this. I can see its Set-MgUserLicense -AddLicenses but all the examples I see are to set a licence to just one user... I want to read my list of users and do a For-Each on them but I cant see how I can do that in Microsoft Graph Powershell SDK. Can anyone help?Solved19KViews0likes9CommentsSharePoint online - search for documents containing #147 only
My manager would like to search SharePoint for only files that contain the phrase #147 (This is how some projects have been referred to in files in the past) I would have thought that using double quotes like "#147" would do that. But it seems not. If I search SharePoint for "#147" it will return every file with 147 in it. For example "Timetable for bus number 147" or a file with a figure such as £147 or $147 in it. How can I make SharePoint only return files with #147 in them? thanks in advance.356Views0likes0CommentsCapture two Forms responses into one item in a SharePoint list
Hello Im trying to turn a paper workflow digital. It is used to setup new suppliers in our finance system. So, imagine we want to buy software from a new supplier, we need to add them to the finance system so we can raise a purchase order to buy the software. At present we fill in a PDF form with the name of the new supplier and a description of what they do e.g. "Fred Bloggs Software, GIS software suppliers" The PDF form is then emailed to the supplier who fills in their details such as bank account details, tax references etc etc. They then email the completed PDF form to our Finance people who manually type the information into the finance system to set them up... So how can I do this? Im thinking this: Form 1: Internal user provides the name of the new Supplier and the nature of their business and an email address for them. Submits the Form. This creates a record in a SharePoint list. This also triggers an email to the supplier with a link to: Form 2. The supplier provides their bank details, tax references, address, email address for remittance advice etc. When they submit Form 2 it adds their details to a SharePoint list so that their information is appended to the information submitted in Form 1 Im thinking I will have to use the unique ID of each record in the SharePoint list to add the data from Form 2 to the data from Form 1 on the same line/record. Thanks for any thoughts. Adam. P.S the data in the SharePoint list can only be visible to finance staff, nobody else should see the content (bank details etc...)SolvedRe: Sharepoint List Web Part says the Year 1899 from internal Created Date - worked, but now its 1899
Siewake I had this problem. I changed the date format in the column to US format and it showed correctly, then changed it back to UK and its now showing correctly (I'm in UK)2.9KViews0likes0Comments
Recent Blog Articles
No content to show