microsoft / federal-business-applications

US Government Business Applications Demo Repository

US Government Business Applications Demo Repository

Welcome to the US Government Business Applications Demo Repository. This repository was created to showcase sample solutions that run in the Power Platform and Dynamics 365 in our various US sovereign government clouds.

Demos

Below is a listing of the sample solutions available. These sample solution files are meant for demonstration purposes only to quickly showcase various features across our platform.

Demo Name	GCC	GCC High	DoD
Access Data Migration to Dataverse	✔️
AI Builder Drivers License Canvas App	✔️	✔️
AI Builder Form Processing + RPA	✔️	✔️
Azure Computer Vision Canvas App	✔️	✔️	✔️
Book a Room Template App	✔️	✔️
Chargeback & License Management	✔️	✔️	✔️
Dynamics 365 Fraud Protection	✔️	✔️	✔️
Dynamics 365 or Model-Driven Power Apps & Teams Click-To-Dial	✔️
DevOps with GitHub Actions	✔️	✔️	✔️
Electronic Signature Canvas App	✔️	✔️	✔️
Mixed Reality - Take Measurements Demo	✔️
govDelivery Custom Connector	✔️	✔️	✔️
Electronic Signature PDF Flow	✔️
PII Redaction with Power Automate	✔️	✔️
Populating Dataverse with ArcGIS Data Using Power Automate	✔️	✔️	✔️
Power Query Custom Data Connector for Power Automate REST APIs	✔️
Power Query Custom Data Connector for Power BI REST APIs	✔️
PowerShell Gov Samples	✔️	✔️	✔️
Return to the Workplace	✔️	✔️	✔️
RPA Web Scraping Demo	✔️	✔️	✔️
Rules Engine	✔️	✔️	✔️
Transcript Demo: Power Platform + Azure Speech to Text		✔️
Vaccine Attestation	✔️	✔️	✔️

Whitepapers

Accessibility and Section 508 Conformance

• Section 508 Conformance
• Federal Business Applications Webinar - Accessibility - March 2022

Power Platform

Below are whitepapers that have been created specifically for use in the US Government sovereign cloud regions.

• Power Platform / Dynamics 365 Gov Architecture
• Power Platform / Dynamics 365 Federal Security Recommendations
• Power Platform / Dynamics 365 Copilot Resources
• Azure Synapse Link Integration
• Consume Commercial Azure Storage Resources from Power Platform GCC
• Creating US Government Support Tickets
• Enable Azure AD Connector in GCC
• How to use the O365 Outlook Connector for Notifications
• Power Apps Developer Plan for US Government Customers
• Power Virtual Agents and Power BI in US Gov Clouds
• Power Apps - 'Add App to Teams' Workaround for GCC

Power BI

• Power BI Desktop Registry Settings for US Gov Clouds
• Power BI & O365 Forms Integration in US Gov Clouds
• Power BI Visuals Download Tool
• A Guide to Power BI Embedding within Government Community Clouds (GCC)

Webinar Series

We recently launched a new Federal Business Applications webinar series. Past recordings and future session details can be found below,

• Federal Business Applications Webinar Sessions

Federal Forums

• Federal App Makers Forum

Training Resources

Power Apps / Power Automate

• App in a Day
• RPA in a Day
• Power Platform Learning Paths
• Power Platform Center of Excellence Starter Kit
• Power CAT Adoption Maturity Model
• AI Builder Labs

Dynamics 365

• Dynamics 365 Learning Paths
• Dynamics 365 Certifications

Power BI

• Power BI Learning Paths
• Guy in a Cube YouTube Channel
• Power BI Training Content
• Power BI Dashboard in an Hour Lab
• Power BI Paginated Reports in a Day YouTube Training
• Power BI Adoption Framework

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repositories using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Contributing Guidelines

For non-Microsoft employees, you can fork this repository, and then submit any contributions with a pull request. Someone on the contributors team will review your pull request and then work to get it merged into the repository. Details on how to fork this repository and submit a pull request are available on GitHub's documentation page below,

Creating a Pull Request from a Fork

Spell Check

We also have spell checking enabled via a GitHub Action. To see if you have any spelling typos, run the Spellcheck Action associate with this repository. We also have a file that contains a list of spell check exceptions. You may need to add acronyms or other words to this list as you run into them.

Spell Check Word List

Folder Naming Conventions

If you want to add a new demo or whitepaper, follow the folder structure convention below,

demos/
├─ your-new-demo-folder/
│  ├─ files/
│  │  ├─ image1.PNG
│  │  ├─ image2.PNG
│  │  ├─ sampleSolution.zip
│  ├─ README.md
whitepapers/
├─ your-new-whitepaper-folder/
│  ├─ files/
│  │  ├─ image1.PNG
│  ├─ README.md
├─ your-new-whitepaper2-folder/
│  ├─ summary.pdf
README.md

You can decide if you would rather have a README.md file with Markdown syntax, or if you prefer, you can convert a document into a PDF file and then upload that into the subfolder for the demo/whitepaper. PDF's will render in the browser when viewed on GitHub. README.md files are preferred as they will also support version control and change history on the actual file.

Lastly, link from this main README.md page to your new demo/whitepaper and the corresponding README.md or PDF file.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

federal-business-applications's Issues

Power BI Desktop - Embedding

I've seen this a few times within GovCloud that Secure Embed Link for Power BI doesn't work because the following best practices were not implemented:

1. For Internet Explorer/Edge please make sure login.microsoftonline.com/us and app.powerbi.com/app.powerbigov.us are listed as trusted sites, so that these two URLs are in the same security zone as the site that needs to embed the Power BI Report.
   a. For many on-premise SharePoint sites group policy places those sites in the Intranet Security Zone while Power BI would be in the Internet Security Zone. If Power BI needs to be embedded on a SharePoint on-premise site, you will need to consider moving those sites to the same security zone.
2. For Chrome settings managed by the organization, if you are blocking third-party cookies then add login.microsoftonline.com/us and app.powerbi.com/app.powerbigov.us to the “Allow” list.

It would be helpful to have an article like this, as many Power BI users like to share their reports on other sites.

Action step initially has different label and changes to label like workflow mockup after step 6

Azure Computer Vision Sample App
In the initial instructions it says "The Flow looks like this," and that confused me, because the flow initially has a label of "Connections" for the action step and changes to "Analyze Image" after step 6

It would be good to convey that in the instructions that the flow might not look exactly like the initial screen shot right away.

connectionsStep-3-2021-09-30_21-40-35.mp4

Feature Request: I would like to see a federal solution for injesting, processing, categorizing, and searching resumes

Assuming the tools within GCC, GCC+ and DOD (but SPECIFICALLY DOD), I would like to see a tool which can take resumes dropped within a certain location (SharePoint library) that can then be processed, key entities extracted, keywords extracted, etc and a tool which can then query the repository of resumes to find someone that fits the need. A place where supervisors can go and search through the pool of applicants and find just the right fit for the position they have.

Please consider the following tools for this solution (and others if needed)
Power Automate
Power Apps
Power Automate Desktop
Azure cognitive functions (e.g. Text Analytics)
SharePoint

Uploading flow in power automate error

First, awesome flow!
Thank you for sharing it!

Unfortunatly i cannot upload the zip.
I get an error without any real info, so i was wondering if you know what is going wrong.

Thanks in advance!

PDF form filler demo

Hi, do you have the source code available for the PDF form demo from the April webinar? I actually started working on something almost identical for the exact same reason. :) Thanks!
@SteveWinward

the links to the "Return to Workplace template are broken, where can I find this solution?

Feature Request: Create an example on how a user could change the organizer of a recurring meeting to a new organizer

Premise: We are constantly fighting the battles of having to cancel recurring meetings so that a new organizer can take it over. This causes all sorts of headaches, but it just plain a pain to do.

The Need: A PowerApp and sets of PowerAutomate flows which the "old organizer" initiates. The old organizer selects the meeting they want to re-assign and then enters the new organizer's information. The App/Flow then creates a "Draft" meeting invite with all the exact same information as the previous invite (including To, CC, subject, body, and Teams invite links/phone number) and sends the draft to the new organizer (somehow) who then just has to "send" it out (suspect a manual interactio of some sort here). Except, the "Send it out" action also cancels the old invite, so it all seems to happen simultaneously.

Ideally, the "Cancel" action and the "New" action would not send an email to everyone. Their calendars would just update with the new item.

Also Ideally, the user would not need to install their own flows or anything, the whole solution would be created as an exported PowerApp that would just "Work" for the entire enterprise once imported into the environment.

Side note: This should be an out of the box feature, quite honestly, in a business/enterprise environment. This capability should be build into Outlook/Exchange, rather than creating a workaround.

Electrontic Signature PDF Flow - Broken Link and Flow

@SteveWinward - I found a broken link when attempting to download the solution from the Electronic Signature PDF Flow page (near the bottom).
Here's the page with the broken link: https://github.com/microsoft/Federal-Business-Applications/blob/main/demos/pdf-electronic-signatures/README.md
Here's the broken link
https://github.com/microsoft/Federal-Business-Applications/blob/main/demos/pdf-electronic-signatures/files/ElectronicSignatureDemo_1_0_0_6.zip

Here's what the link should be:
https://github.com/microsoft/Federal-Business-Applications/blob/main/demos/electronic-signatures/files/ElectronicSignatureDemo_1_0_0_6.zip

Also, when I finally did download the solution, the Setup OneDrive flow does not work. Not sure how to get a URL for the template document file that flow can use.

I will try to fix this myself, but need to brush up on GitHub branches (and review Craig's video tutorial)

Add IL6 URL for Power BI Desktop Registry Settings

The article Power BI Desktop Registry Setting for Sovereign Clouds should be updated with the PowerBIDiscoveryUrl for IL6. If this article is allowed to contain this information, I can provide it.

Feature Request: Recommend adding a section for making requests to Graph API

There are several of us that have struggled to figure out Graph API within the DOD environment. The Explorer doesn't work, so we're shooting in the dark in many ways using PowerShell. If you'd add a section to this area showing how to connect to, authenticate, and make a simple Graph API call in the DOD environment that'd be great.

Also, as far as we have been able to tell, there is no documentation on what WORKS in Graph API for the DOD environment and what does not. We know there are some functions NOT available, but have no idea what those are. In something like Powerautomate, I have a site where I can go and see what connectors I have, but for Graph API (especially since we are only working in PowerShell), discovering what endpoints exist, what permission are set on our accounts, and how to authenticate to those endpoints has been very challenging.

Request: How to create an App ID with PowerShell

If attempting to register an app within Azure Portal, the DOD receives this message

However, I've been unable to find information on generating a App Registration using PowerShell. Can you please add this to PowerShell information (Or point to where it is already documented) and perhaps provide examples. Thank you.