Coronavirus Tracking application : Power Apps template 03-08-2020 15:13 PM - last edited 03-24-2020 14:28 PM

[RezaDorrani]

The Coronavirus Tracking application tracks the spread of COVID-19 cases globally

The Main App features include:
1) Track the COVID-19 cases worldwide on a Map. Filter data points by Case Type, Country or Region
2) Track COVID-19 cases around your Location (tracking) or a specified location
3) Send notifications (email) based on filtered data points with map attached
4) Chat Bot to answer common questions around COVID-19
5) Configurable Map Types and Locations

Coronavirus Tracking application Overview:
https://www.youtube.com/watch?v=Gdv23OV_vpg

Coronavirus Tracking application Setup:
https://www.youtube.com/watch?v=UDJSiJi4ibw

Download the solution:

https://github.com/rdorrani/PowerApps/tree/master/Coronavirus%20Tracking

The Coronavirus Tracking application leverages data from the feature layer in arcgis by CSSE_GISandData
Web service:
https://www.arcgis.com/home/item.html?id=bbb2e4f589ba40d692fab712ae37b9ac
Service Layer:
https://services1.arcgis.com/0MSEUqKaxRlEPj5g/arcgis/rest/services/Coronavirus_2019_nCoV_Cases/Featu...

This App can be used along with the Crisis communication template released by Microsoft :
https://powerapps.microsoft.com/en-us/blog/crisis-communication-a-power-platform-template/

watch?v=Gdv23OV_vpg

[R3dKap]

Really nice work there Reza! A perfect example of how to combine all sorts of Office365 and external services to achieve a fully functional (and practical in these times) application.

Bravo!

[RezaDorrani]

Thank you

[Artizeng]

Firstly, great job! I was able to follow the video guide really easily and get the app set up correctly the first time, which is great as this was only my second app!

I do have a couple of questions around the mapping features. Do you know if it is possible to:

• Enable panning on the map when on manual zoom mode? 
• Use node scaling so as the size of the points on the map are relative to their value i.e. number of cases? (I know this feature is available in Power BI mapping)
• Change the background mapping style

I appreciate the quality and accuracy of the data is not within your control but do you know if there is any way to communicate with those who do manage the data i.e. CSSE? The UK information is already a bit out of date and it would be far more useful if it provided at a country level e.g. England, Scotland, Wales and Northern Ireland, and even better again if it were available at a county level.

[BrittO]

@RezaDorrani 

Great app!

Can you share more information on the deployment effort, timelines and resources required to get this off the ground?

Can a client without any knowledge of PowerApps take this on themself?

If a consultant is involved, how much time is required from the client to advise on business requirements? 

If the client puts together a team to advised on business requirements - who would these team members be? What are their roles in their day jobs?

If a consultant is involved - how many hours, days, would they need to allocate to the deployment

I need to spell out the effort required to my client base and partners. Thanks!

[AlfredBoeren]

Hi Reza,  Great app, Thanks.

We have just one problem. The data is populate and filter per country and region is working fine. However the maps stays blank. We got a bingmap key , We do not get  the error that there is no key.

Any ideas, what the problem can be?

Regards,

Alfred

[RezaDorrani]

Hi @BrittO ,

Deployment effort ~15 mins.

Here is a video walkthrough of the deployment

https://www.youtube.com/watch?v=UDJSiJi4ibw

Can a client without any knowledge of PowerApps take this on themself? - Yes

The deployment steps covers publishing of artifacts,web service call flow and the App itself.

If a consultant is involved, how much time is required from the client to advise on business requirements? 

If the App is to be used as is then not much work is needed.

If changes are required then it would depend upon the requirements.

If the client puts together a team to advised on business requirements - who would these team members be? What are their roles in their day jobs?

Team members would be the business users in this case. They could be playing any role in the organization. Power Apps & specifically this solution is ready to use and run with.

If a consultant is involved - how many hours, days, would they need to allocate to the deployment

Max 15 mins.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[RezaDorrani]

Hi @Artizeng 

 do have a couple of questions around the mapping features. Do you know if it is possible to:

• Enable panning on the map when on manual zoom mode? 
  Currently all I am using is the static bing maps Image. So not much can be done here. 
  However, MSFT has annouced new GeoSpatial components which are in private preview.
  Here is my COVID 19 tracker App in action using the new GeoSpatial components - https://www.youtube.com/watch?v=ipot4cd0-zQ
  I will share this version of the App as soon as the Geo Spatial components go into Public Preview.
• Use node scaling so as the size of the points on the map are relative to their value i.e. number of cases? (I know this feature is available in Power BI mapping)
  Geo Spatial Components do not have scaling options for now but may be once it goes into GA it has those capabilities.
• Change the background mapping style
  Geo Spatial Components do have multiple Map styles.
  Even the Static Bing Map has multiple styles.

I appreciate the quality and accuracy of the data is not within your control but do you know if there is any way to communicate with those who do manage the data i.e. CSSE? The UK information is already a bit out of date and it would be far more useful if it provided at a country level e.g. England, Scotland, Wales and Northern Ireland, and even better again if it were available at a county level.

For more specific county level data you would have to look for any publicly available api's that you can plug with. 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[RezaDorrani]

Hi @AlfredBoeren 

The API structure changed a bit resulting in Maps to be empty.

I have uploaded the latest solution code base to

https://github.com/rdorrani/PowerApps/tree/master/Coronavirus%20Tracking

Give it a shot and let me know in case of any issues.

Note: Includes a lot of new features !!!

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter