**Title:** PowerShell Script — Microsoft Graph API Auto-Upload to SharePoint with Metadata Tagging **Budget:** $400–$600 fixed price --- **Overview** We are a CPA firm (New York, 15 staff) running a shared Windows Server terminal environment. We need a PowerShell script that watches a folder (C:\Transit) on the VM, parses a structured filename, auto-tags SharePoint metadata columns, and uploads the file to a SharePoint document library — entirely replacing manual browser-based tagging. A detailed technical specification document (14-section RFP) is available immediately upon engagement. --- **What the Script Does** 1. Monitors C:\Transit on the Windows Server VM using a FileSystemWatcher or Task Scheduler loop 2. When a new PDF appears, parses the filename using this convention: - Format: [ClientCode][TypeLetter][Period][F] - Example: SAND4521E2025F — 8-char client code + 1-char document type + 4 or 6-char period + optional F (Final flag) 3. Looks up the full Account name from Microsoft Dynamics 365 using the 8-character ClientCode (via Graph API or D365 REST API) 4. Uploads the file to a SharePoint Online document library via Microsoft Graph API 5. Auto-populates 5 SharePoint metadata columns: Account (text), Document Type (choice), Period (text), Status (Draft or Final), Contact (blank — leave empty) 6. Moves the processed file out of C:\Transit and logs the result 7. Sends an alert email on any failure --- **Tech Stack** - Windows Server (hosted VM) - PowerShell 5.1 or 7 - Microsoft Graph API (SharePoint + D365 endpoints) - Entra ID app registration (client credentials flow) — we will create and provide client ID, tenant ID, and client secret - SharePoint Online — Microsoft 365 Business Basic tenant - Dynamics 365 — for ClientCode → Account name lookup --- **Deliverables** 1. Fully tested PowerShell script (.ps1) with inline comments 2. Entra app registration setup guide (what permissions to request) 3. Deployment instructions for Windows Task Scheduler or Windows Service 4. Error log format and alert email configuration 5. One supervised screen-share session to deploy to production --- **Access and Security** - Development and testing must use a test SharePoint library and dummy files — no real client data during build - Production deployment via one supervised screen-share session (firm principal present throughout) - Developer never holds credentials — all credential entry done by firm principal during session - Deliverable is the script file and documentation — not ongoing VM access --- **Budget** Fixed price: $400–$600. Proposals significantly outside this range without clear justification will not be considered. Please do not apply if you need more than 2 weeks to deliver. --- **How to Apply** Please include: - Brief description of your PowerShell and Microsoft Graph API experience - Examples of similar SharePoint/Graph API projects you have delivered - Fixed-price quote for this scope - Estimated delivery timeline - Any questions about the specification A detailed 14-section technical RFP is ready to share immediately. This is a well-defined, one-time project — no ambiguity in the spec.

I need an expert on Co pilot studio with a specific focus on agent optimization workflows. I have a handful of agents I need to work in parallel with one another and funnel up through a hierarchy to the master agents above. Looking to consult an expert to make this flow seamless, fast, and accurate for a project. Thanks!

**Job Description:** We are excited to announce an opportunity for a talented and skilled freelancer to join our team in enhancing and optimizing our Microsoft SharePoint intranet. As a pivotal component of our internal communication and collaboration efforts, this intranet serves as a vital resource for our employees, and we are committed to making it as effective and user-friendly as possible. **Key Responsibilities:** In this role, you will be responsible for a variety of tasks aimed at improving the overall functionality and aesthetics of our SharePoint intranet. Your primary responsibilities will include, but are not limited to: 1. **Graphic Design Enhancement:** You will work on upgrading the visual elements of the intranet, including graphics, icons, and layout. This includes creating a modern, engaging design that reflects our company’s brand and culture to enhance user experience. 2. **Widget Development and Optimization:** You will be tasked with developing and optimizing widgets that provide essential information and tools to our employees. This may involve creating custom widgets that facilitate easy access to frequently used resources and improving existing ones for better usability. 3. **Organizational Improvements:** An essential part of the project will involve reorganizing the existing content and structure of the intranet. You will assess the current layout and information architecture, making recommendations for improvements to ensure that information is easy to find and navigate. 4. **Data Migration:** You will oversee the migration of existing data to the new intranet structure. This includes ensuring that all content is accurately transferred, properly formatted, and accessible to all users without loss of information. 5. **Publishing Flows:** You will design and implement streamlined publishing flows to ensure that content updates are efficient and effective. This may involve creating workflows that facilitate collaboration among team members and making it easy for them to contribute to the intranet. **Project Importance:** This project is crucial for our company as we transition into a more modern and agile organizational structure. Having a robust and effective intranet is essential for fostering communication, collaboration, and engagement among our employees. Your expertise in SharePoint will be invaluable in creating a seamless and efficient intranet experience that aligns with our company’s goals. **Qualifications:** We are looking for a freelancer with a strong background in SharePoint and experience in web design and development. The ideal candidate will possess a blend of technical skills and creative vision, along with the ability to work independently and meet deadlines. Specific qualifications include: - Proven experience in enhancing SharePoint intranets or similar platforms. - Strong graphic design skills with a portfolio showcasing previous work. - Familiarity with data migration processes and best practices. - Knowledge of web development languages and tools relevant to SharePoint. - Excellent organizational and communication skills, with the ability to work collaboratively with our team. If you are passionate about creating exceptional digital experiences and have the expertise we are looking for, we would love to hear from you. Join us in shaping a modern intranet that empowers our employees and supports our business objectives.

I want to build a sustainable, useful, attractive and valuable intranet for my colleagues and franchise subscribers. The successful candidate must have extensive experience with small business intranet that gets used and references to that effect. I have seen how well experienced designers and implementers can do what I'm expecting in days, rather than months. Please don't offer your services if you are expecting me to design or don't have the experience to definitively design this for ease of use and value for the business and my colleagues. See www.pilotadvisors.com

We are seeking a skilled freelancer to develop a SharePoint Intranet for our organization. The project involves creating a user-friendly interface, integrating with Active Directory, and implementing security features for a multi-entity company located in 6 countries. The ideal candidate will have experience in SharePoint administration and development, and be able to deliver a high-quality solution within a reasonable timeframe.

We are seeking a skilled freelancer to automate two Excel sheets so they can feed data to each other. The ideal candidate will have experience in creating interactive Excel systems and be proficient in Visual Basic for Applications. This project requires attention to detail and the ability to deliver a seamless data exchange between the sheets. If you have a strong background in Excel automation, we would love to hear from you!