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
    • 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
    • Re: Coffee Flex - Get matched for a coffee break w...

    Re: Coffee Flex - Get matched for a coffee break with a random colleague

    04-20-2021 05:07 AM

    Marone
    Frequent Visitor
    5909 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    FabianAckeret
    Super User FabianAckeret
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Coffee Flex - Get matched for a coffee break with a random colleague

    ‎04-06-2021 04:11 PM

    Hey guys

     

    Intro

    Think of tinder for virtual coffee breaks. That's more or less what it is.

    As a user, you need to register yourself to be in the pool of "registered users". Once you're registered, you're eligible to search for a possible coffee-match AND others can be matched with YOU.  It's as easy as clicking on a button. The app will then filter out registered users that are not eligible for a match. It will then present you with a matched user and will also suggest timeslots for a coffee. You can even see if the user is available on suggested timeslots. If not, just let it generate new timeslots for you.

     

    demo-coffee-flex2.gif

     

    Who is not eligible

    Not eligible users could be:

    • users who had already a coffee match today
    • users who had already a coffee match yesterday
    • users who have a coffee match planned for tomorrow

     

    I'm planning to improve the conditions even further so users can choose, perhaps, their department to be matched with, their preferred timings, etc. For now, it's just what I stated above.

    Connections

    Coffee Flex needs the following connections:

    • Office 365 Users (to find the profile of matched user)
    • Office 365 Outlook (to send invitations to the matched user)
    • Microsoft Teams (to generate a teams invitation)

    Tables

    Apart from that, it's also using two tables:

    • Registered Users (includes all users that have clicked on the Register button
    • Matches (includes all matches the app has made)

    How to install it

    1. Open MS Teams
    2. In the App Store, search and open Power Apps
    3. Create a new app or use an existing environment
    4. Once you're in the right environment, click on See all to see all assets in that environment
    5. From there, click on Import at the top
    6. Upload the attached zip (see below) and confirm.
    7. Wait for it to be imported
    8. Open the Coffee Flex app and ensure everything works

    How to configure colors & invitation message

    In the App.OnStart property, you can change the gblInvitationMessage variable to any HTML text you like. This is the one that is being used when an invitation will be sent (to the matched user).

     

    To change the colors, simply adjust the colors in the colStyles library. The most important ones are primaryAccent.Fill, light.BorderColor, background.Fill, background.BorderColor, gradient, darkGradient, and lightGradient

     

    I hope you like it.

    If you have feedback, bugs, just want to say thank you or anything in between, please let me know and drop a comment.


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
    Coffee Flex_export-22-Jan-22-v2.zip
    Labels:
    • Labels:
    • Formulas and Controls
    • Galleries and Forms
    • Mobile App Design and User Experience
    Message 1 of 53
    8,714 Views
    18 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    • « Previous
      • 1
      • 2
      • 3
      • …
      • 6
    • Next »
    Marone
    Marone
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-20-2021 05:07 AM

    Hi Fabian,

     

    I love the idea! I am a little bit stuck though. 

    Can you please explain more about the connection to the tables?

    I get the following errors, do I need to adjust something in the code? 

     

    Thanks for your help and this great app!

    Marone_0-1618920426994.png

     

    Message 2 of 53
    5,909 Views
    3 Kudos
    Reply
    FabianAckeret
    Super User FabianAckeret
    Super User
    In response to Marone
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-22-2021 04:25 AM

    Hi @Marone 

    Interesting.... and thanks for reporting. I tested the import on 2 of my test tenants and it worked seamlessly. 

     

    Did you import the solution into a Dataverse for Teams environment? 

    If so, in that environment, what tables exist? There should be two tables available:

    • Matches
    • Registered Users

    If they exist, try to remove and re-add them in the app itself.

     


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
    Message 3 of 53
    5,850 Views
    0 Kudos
    Reply
    fabiofrota
    fabiofrota
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-28-2021 01:58 AM

    Hi Fabian

    I'm unable to find the import option in Power Apps in Teams. Do you have a screenshot of that step?

    Message 4 of 53
    5,766 Views
    0 Kudos
    Reply
    FabianAckeret
    Super User FabianAckeret
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-28-2021 09:25 AM

    Hi @fabiofrota 


    right here:

    FabianAckeret_1-1619628084820.png

     

     

    Kind regards,

    Fabian

     


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
    Message 5 of 53
    5,760 Views
    1 Kudo
    Reply
    fabiofrota
    fabiofrota
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-30-2021 02:37 AM

    Thanks @FabianAckeret !
    I'll give it a try and let you know how it is

    Message 6 of 53
    5,733 Views
    2 Kudos
    Reply
    CookiePower
    CookiePower
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-14-2021 05:46 AM

    Thanks for the great app. Is there a way for it to use SharePoint Lists?

    Message 7 of 53
    5,570 Views
    2 Kudos
    Reply
    FabianAckeret
    Super User FabianAckeret
    Super User
    In response to CookiePower
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-14-2021 08:56 AM

    Hi @CookiePower 

     

    The app is built on Dataverse 4 teams, but if you like, you can change it to SharePoint lists. However, some of the code is making use of the relational database. Those parts you'd need to adjust as well.

    Is there a reason you'd like to use SharePoint Lists in particular?


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
    Message 8 of 53
    5,564 Views
    0 Kudos
    Reply
    mate_toth
    mate_toth Resolver I
    Resolver I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-15-2021 12:20 PM

    @FabianAckeret This looks great! Well done! 🙂

    I've built something similar last year, during our first lockdown in Hungary using SP Lists, Power Apps and Power Automate.

    It had a weekly random matching for the registered users, who then received an email, and could book a timeslot. I've implemented a timeslot finder into the app as well (showing only the available timeslot for you two), but it was extremely underused, so I removed it after few months. 😀

    Message 9 of 53
    5,132 Views
    3 Kudos
    Reply
    FabianAckeret
    Super User FabianAckeret
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-15-2021 11:49 PM

    Hi @mate_toth 

    Thanks! 

     

    I was thinking about a weekly random matching as well... or even offer the option to invite others as well. Maybe even have preferred times for coffee breaks and to only be matched during these times.

    The timeslot finder is also implemented into this one... given that you're using Exchange Online. The suggested timings are based on each users calendar.

     

    Cheers 🙂


    Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.
    Message 10 of 53
    5,120 Views
    2 Kudos
    Reply
    • « Previous
      • 1
      • 2
      • 3
      • …
      • 6
    • Next »

    Power Platform

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

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Studio
    • iOS
    • Android

    Learn

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

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