City and County of San Francisco | One Platform, Infinite Possibilities

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.