DUG4GOV - Microsoft D365 & Power Platform

Come and learn how the City of San Francisco is achieving its strategic IT objectives. There has been focus on application modernization, with a strong emphasis on transitioning to a cloud-first approach.

This strategy has been driven by key business objectives aimed at enhancing application scalability, integrating additional services to support growth, and optimizing overall performance. To achieve these goals, we have undertaken the re-platforming of various applications and have leveraged the Power Platform to automate processes effectively.

We believe that sharing our experiences and insights could be mutually beneficial, and we are eager to discuss the key drivers, challenges, and successes we have encountered along the way. Your participation would not only foster collaboration but also help us collectively enhance our IT modernization efforts.

We look forward to the opportunity to connect and share our journey with you.

The City and County of San Francisco will be sharing some fascinating use cases on how they have harnessed the power of Power Platform to achieve remarkable results.

Here are the exciting use cases that will be presented:

1. Natural Gas Equipment Inventory Power App
Benefits:

• Consolidation of Data: By consolidating distributed Excel files from multiple departments into a single Power App front end, the San Francisco achieved a centralized repository for equipment inventory.
• Enhanced Data Accessibility: With Dataverse handling text and photo storage, all relevant data is easily accessible and manageable from one location.

2. Dormant Phone Cost Savings
Benefits:

• Efficiency in Data Processing: The Power Automate flow processes a large Excel file containing months of phone usage data, automating the identification of dormant lines.
• Streamlined Actions: The Power App front end allows departments to initiate line suspensions and discussions directly, reducing manual intervention and speeding up decision-making.

3. Invoice Life Cycle
Benefits:

• Automated Invoice Handling: Power Automate flows download vendor invoices from the web, ensuring that all invoices are captured and processed consistently.

• Guided Review and Approval: The Power App front end guides finance staff through the review, approval, and payment process, providing a clear audit trail and ensuring accountability at each step.