Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Ideas
    • Power Apps Ideas
    • Community Engagement
    • Demo Extravaganza 2021
    • Demo Extravaganza - Components 2021
    • Power Apps Community Demo Extravaganza 2020
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Community App Samples
    • Mental Health Check in Canvas App

    Mental Health Check in Canvas App

    04-08-2021 04:29 AM

    Jondoesflow
    Advocate II
    659 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Jondoesflow
    Jondoesflow Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Mental Health Check in Canvas App

    ‎04-08-2021 04:29 AM

    INTRODUCTION

    I was asked by Microsoft to write a blog post on their Humans of IT series - https://techcommunity.microsoft.com/t5/humans-of-it-blog/guest-blog-6-ways-to-maintain-and-foster-yo...

    At the end of this post, I decided that I needed to go further than write about it, I needed to do something. This was my first foray into PowerApps and i had a vision of what it needed to do and I had the benefit of being on both sides of the coin. Suffering from anxiety for the last 4 years or so and also having the ability to get up and running with Power Automate and PowerApps left me in a great position to be able to build this and share it for others.

    Thanks for reading.

    More info here - https://github.com/jondoesflow/mentalhealthcheckinpowerapp

    mentalhealthcheckinpowerapp

    This is a mental health check in application built in Microsoft PowerApps and Power Automate

    Import the Power App ZIP file - MentalHealthCheckInApplication_20200126092403.zip

    Uploading and creating the Resources by Topic Area list:

    1. Open the "resources by topic title.iqy" file and save as an XLSX document
    2. Open IE as an administrator
    3. Go to your sharepoint site
    4. Go to Site Contents
    5. Go to Settings Cog
    6. Click Add an App
    7. Search for "spreadsheet"
    8. Click Import Spreadsheet
    9. Name: "Resources by Topic Area" or Name: "Mental Health"
    10. Choose file: resources by topic title.xlsx or mental health.xlsx
    11. In the selcted range drop down select the only option avaialble
    12. Click Import
    13. The list will have been uploaded.

    Do steps 1 - 13 above for "mental health.iqy" file

    Go to your Data Sources in the Power App

    1. Remove the current Resources by Topic Area sharepoint connection
    2. Click Connectors to expand
    3. Click Sharepoint
    4. Choose the Sharepoint connector for your tenant
    5. Chose your Sharepoint in your tenant
    6. Click the check box on "Resources by Topic Area"
    7. Click Connect

    Go to the FurtherInformation page

    1. Click on the 1st dropdown control "DropdownTopic" ensure Items object is set to "Sort(Distinct(ColResources,'Topic Name'),Result)"
    2. Click on the 2nd dropdown control "DropdownOrganisation" ensure Items object is set to "Filter(ColResources,'Topic Name'=DropdownTopic.Selected.Result)"

    App Start

    In the App Start config, remember to change the phone numbers for your Occupational Health and Third Party Support (if you have one. They are currently set to 111111.

     

    watch?v=VGPXcZSqmKY

    mentalhealthcheckinpowerapp-master.zip
    Labels:
    • Labels:
    • Mobile App Design and User Experience
    Message 1 of 2
    659 Views
    3 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    Emsa
    Emsa
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-11-2021 11:57 PM

    Hi Jon, great initiative!  Thanks for sharing.

    Cheers!

    Emmanuel

    Message 2 of 2
    526 Views
    1 Kudo
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2022 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks