Coffee Flex - Get matched for a coffee break with a random colleague
Like
Share
Report
Posted
by
FabianAckeret
969
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.
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
- Open MS Teams
- In the App Store, search and open Power Apps
- Create a new app or use an existing environment
- Once you're in the right environment, click on See all to see all assets in that environment
- From there, click on Import at the top
- Upload the attached zip (see below) and confirm.
- Wait for it to be imported
- 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.
Comments
-
Coffee Flex - Get matched for a coffee break with a random colleague
After a bit of code sifting, this is where I'm finding the error (in btnFindMatch):
/////////////////////////////////////////////////////////// // get random user from above selection // this is the logic that defines who IS a match UpdateContext( { lclRegisteredUsers: Filter( 'Registered Users', Registered && 'Azure AD Object ID' <> gblUser.id //&& // Not('Azure AD Object ID' in colNonMatches.User) THIS THROWS AND ERROR ) } );I can see the logic, but can't find a way around the check to see if they aren't in the colNonMatches.
Any ideas?
-
Coffee Flex - Get matched for a coffee break with a random colleague
Hi Fabian,
Awesome app, it looks great, I'm having problems in execution though. Here's what I get when I click on the "Find Match" button:
There are three people registered to test. Does this look like it's because three is too few to test or does it look like a code problem?
-
Coffee Flex - Get matched for a coffee break with a random colleague
Hi,
we had a issue at the moment with the solution and no idea how to solve - looks like is fresh problem as it was working without any problems in the past.
When people open the App the First Time in Teams Client they get the error: user_cancelled: User cancelled the Flow.
Actual Workaround: Open Teams in Browser, Open the App, Allow Access to Outlook etc, then it is working again in Teams Client.
Any Ideas what is the problem with the access? -
Coffee Flex - Get matched for a coffee break with a random colleague
Hi @InaM
Thank you 🙂.
I use a bunch of tools when creating apps. They are all free to use.- https://app.haikei.app/
- https://www.blobmaker.app/
- https://angrytools.com/gradient/
- https://getwaves.io/
- https://animatedbackgrounds.me/
- https://undraw.co/
I'm afraid I don't remember where I got the balloons image anymore.
I hope this helps.
Cheers
-
Coffee Flex - Get matched for a coffee break with a random colleague
The app looks great and I love the graphics! Do you have any tips on how you've done the SVGs, like the imgBgPattern and imgMain, and backgrounds using HTML like htmBgOverview? Could you share where did you get the balloons image too?
-
-
Coffee Flex - Get matched for a coffee break with a random colleague
Hello Everyone !
I am not able to import this app - can this be due to updates from MS Power Apps ?
I have tried this several times now and unfortunately, I always get the same error message.
Other apps I am able to import without any problems, so I don't understand what I'm doing wrong here....
Thank you in advance for your help ! -
Coffee Flex - Get matched for a coffee break with a random colleague
Thanks for this. I got an denied access error, though, apparently because of a language issue (we're using Outlook in German). I replaced the following line:
Set(gblMyCalendar,
LookUp(Office365Outlook.CalendarGetTables().value, DisplayName="Calendar").Name);With this:
Set(gblMyCalendar,
LookUp(Office365Outlook.CalendarGetTables().value, DisplayName="Calendar" || DisplayName="Kalender").Name);This works for now. But is there an option where I don't have to specify the exact name in every language?
*This post is locked for comments