Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Pages
    • Take a guided tour
  • 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
    • GCC, GCCH, DoD - Federal App Makers (FAM)
    • 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
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community Calls Conversations
    • 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
    10029 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    FabianAckeret
    FabianAckeret Solution Sage
    Solution Sage
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    15,126 Views
    20 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    • « Previous
      • 1
      • 2
      • 3
      • …
      • 7
    • Next »
    Marone
    Marone
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    10,029 Views
    3 Kudos
    Reply
    FabianAckeret
    FabianAckeret Solution Sage
    Solution Sage
    In response to Marone
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,970 Views
    0 Kudos
    Reply
    fabiofrota
    fabiofrota
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,886 Views
    0 Kudos
    Reply
    FabianAckeret
    FabianAckeret Solution Sage
    Solution Sage
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,880 Views
    1 Kudo
    Reply
    fabiofrota
    fabiofrota
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,853 Views
    2 Kudos
    Reply
    CookiePower
    CookiePower
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,690 Views
    3 Kudos
    Reply
    FabianAckeret
    FabianAckeret Solution Sage
    Solution Sage
    In response to CookiePower
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,684 Views
    0 Kudos
    Reply
    mate_toth
    mate_toth Resolver I
    Resolver I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,252 Views
    3 Kudos
    Reply
    FabianAckeret
    FabianAckeret Solution Sage
    Solution Sage
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • 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 62
    9,240 Views
    2 Kudos
    Reply
    • « Previous
      • 1
      • 2
      • 3
      • …
      • 7
    • Next »

    Power Platform

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

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

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

    • © 2023 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices