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.
Hi @Art10
You're welcome🙂
If you click on the Find Match button and go to the OnSelect property, you can adjust the values according to your needs.
You would need to adjust the following part:
ClearCollect(
colNonMatches,
AddColumns(
Filter(
Matches,
With(
{
coffeeCondition:
'Coffee Date' = Today() ||
DateAdd('Coffee Date',1,Days) = Today() ||
DateAdd('Coffee Date',-1,Days) = Today()
},
//'User 1'.'Azure AD Object ID' = gblUser.id ||
coffeeCondition || (coffeeCondition && 'User 1'.'Azure AD Object ID' = gblUser.id)
)
),
"User",
'User 2'.'Azure AD Object ID'
)
);
to something like this:
ClearCollect(
colNonMatches,
AddColumns(
Filter(
Matches,
With(
{
coffeeCondition:
'Coffee Date' = Today() ||
DateAdd('Coffee Date',15,Days) = Today() ||
DateAdd('Coffee Date',-15,Days) = Today()
},
//'User 1'.'Azure AD Object ID' = gblUser.id ||
coffeeCondition || (coffeeCondition && 'User 1'.'Azure AD Object ID' = gblUser.id)
)
),
"User",
'User 2'.'Azure AD Object ID'
)
);
That should do the trick. I did not verify this, though.
Kind regards,
Fabian
Hi @FabianAckeret ,
thanks so much for this awesome tool. I've imported into my teams environment, but there's a small hickup - no calenar invitation is sent to matched partners.
As a power apps novice I hope you can help me out.
When running the app I get the failure message: MicrosoftTeams. CreateTeamsMeeting failed: The method 'CreateTeamsMeeting' has an invalid value for parameter 'calendarid'. I do not know what to change.
