**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.

Looking to plot a trending map from dynamics 365 and paylocity based with filter abilitys so the trend can change.

We are seeking a skilled freelancer to build a Microsoft SharePoint database for our company. The ideal candidate will have experience in database management and be able to design and implement a robust SharePoint solution. Responsibilities include creating a database structure, integrating data sources, and ensuring data security and accessibility. The project requires an intermediate level of proficiency and is expected to be completed in less than a month.

We are seeking an efficient and detail-oriented Power BI Developer with a strong proficiency in DAX and Power Query to join our dynamic data analytics team. The ideal candidate will play a critical role in transforming raw data into insightful, actionable reports and dashboards that support data-driven decision-making across various departments. This position requires a deep understanding of data modeling, advanced analytical techniques, and the ability to optimize data processing workflows to ensure performance and accuracy. The Power BI Developer will collaborate closely with business stakeholders, data engineers, and analysts to gather requirements, design effective data solutions, and ensure seamless integration with existing systems. The role demands a proactive problem solver who thrives in a fast-paced environment and stays current with the latest BI tools and best practices. By leveraging expertise in DAX and Power Query, the developer will enhance data transformation capabilities, automate repetitive tasks, and maintain high-quality data pipelines. This is an excellent opportunity for a motivated professional seeking to apply technical skills to drive business insights and contribute strategically to organizational success through efficient data processing and visualization techniques. The requirements for this position will include: - Proven experience as a Power BI Developer with strong skills in DAX and Power Query. - Solid understanding of data modeling, ETL processes, and report development. - Ability to work with complex datasets and integrate data from various sources. - Strong analytical and problem-solving skills to deliver accurate insights. - Excellent communication skills and ability to work collaboratively with cross-functional teams. - Attention to detail with a commitment to data quality and consistency. - Experience with database systems such as SQL Server, Azure SQL, or similar is a plus. - Self-motivated and eager to learn new technologies and improve existing processes.

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.

Overview We’re a software company that resells Microsoft licenses as part of our SaaS product and deploys workloads in Microsoft Azure. We need a specialist who can accurately model our per-user and per-deployment costs across both Azure infrastructure and Microsoft licensing so we understand exactly what each customer deployment costs us. What you’ll do • Build a clear, reusable cost model for a product deployment that combines Microsoft 365 licensing (e.g. E3/G3) with Azure Virtual Desktop (AVD) • Use the Azure Pricing Calculator to estimate infrastructure costs across different VM sizes and configurations (e.g. 8 GB vs 16 GB RAM, session host counts, storage, bandwidth) • Break down Microsoft licensing costs per user, including how E3/G3 and any add-ons stack up • Model how costs scale as we add users/seats, and identify the main cost drivers • Deliver the model in a spreadsheet we can adjust ourselves (change RAM, seat count, VM size, etc. and see the cost update) Required expertise • Hands-on experience with the Azure Pricing Calculator and real-world Azure cost estimation • Strong knowledge of Microsoft 365 / Azure licensing, including CSP/reseller licensing models • Experience with Azure Virtual Desktop sizing and cost (session hosts, VM SKUs, storage, FSLogix, etc.) • Ability to translate technical configs into a clean cost breakdown a non-engineer can follow Nice to have

I have a Fabric workspace where I created a powerbi report sourced from Worldwide Importers demo data in Microsoft Fabric (public Azure Blob Storage, where Microsoft hosts the sample dataset in Parquet format for ingestion into a Fabric Lakehouse) and dfg2. I need someonewith recent power bi and fabric experience that can walk me through over zoom making that report publicly viewable.