Posts

Power Apps - Check Group Membership For Groups With > 1,000 Members

-
Image
What There are occasions when it is useful to check inside a Canvas App whether the logged-in user is a member of a specific Security Group. This allows you to implement hide/show functionality for areas of the application that you may only want users/administrators to see. Why The standard method I've used in the past to implement this 'group membership' check is to call the following Connector/Function: Office365Groups.ListGroupMembers() Using this connector, you would first get a list of All the members of a specific security group, then you would do a Filter on that collection to check if the logged in user is one of the Members. However!  That connector only works when group membership is less than 1,000 people, if your group has more than 1,000 members, then there's a chance the app will come a cropper for some users. So below we're going to show you how to do the same check by using MS Graph API calls that all users have access to. How  Using a Graph API cal...
Post a Comment
Read more

Power Automate - Duplicating Calendars across multiple accounts

-
Image
I am constantly working across multiple clients with multiple accounts and calendars.  One time consumer is that each of the clients can't see my calendar, so we double book and discuss back and forth when each person is free. To avoid this time loss, I've whipped up a simple workflow that copies all my calendar invites from my main account to my other accounts. Making sure to keep them 'Private' so I don't accidentally open up all my discussions across multiple companies!
Post a Comment
Read more

Microsoft Teams, Bose QC 35 ii Headphones & a separate microphone

-
Image
Issue: Headphones would not play sound when I had a different microphone selected in Teams:   How to fix:  Disable this property on your headphones. Thanks to this post: https://www.reddit.com/r/techsupport/comments/r4xehv/comment/j9k99wh/?utm_source=share&utm_medium=web2x&context=3
Post a Comment
Read more

How to Copy/Duplicate a Table and Columns in a Dataverse Environment

-
Image
What If you need to do either of these things, then this article is for you: Create a copy of a table in the same environment as the original table Create a copy of a table but want a different prefix against custom column names Why In most circumstances, if you need to duplicate a dataverse table, I would suggest to bundle it inside a solution, and migrate the solution to another environment.   However, in the scenario where you need the duplicate table to be inside the same environment, here's a quick method that requires no manual creation of columns! How Short answer : Install  XRMToolBox , inside XRMToolBox, install and utilise the Clone Field Definitions Plugin  from the Tool Library. Pre-Tasks In order to clone a table with a new PREFIX value for the columns you first need to do the following: Create a new PUBLISHER with the new prefix you would like Create a new TABLE where you will be cloning all the fields. Tasks Download & Install  XRMToolBox On t...
Post a Comment
Read more

Free Responsive Power App Template w/ Side Navigation

-
Image
I wanted a simple template for building out responsive canvas apps with a side navigation so here it is, free to use for everyone: Find here:   https://github.com/BR-E20/Power-Platform-Solutions Solution Name: ResponsiveAppTemplate_1_0_0_1.zip  Large/Extra Large screens Medium Screens Small Screens / Phones
Post a Comment
Read more

SVG Icons for Power Apps - Find any icon you'll ever need

-
Image
Reference Material How to put SVG code in an image object:  https://www.matthewdevaney.com/svg-images-in-power-apps/#How-Do-I-Add-SVG-Icons-To-Power-Apps Figma - Microsoft Office Icons: https://www.figma.com/community/file/1109502320071552607 Figma - 1600 free icons: https://www.figma.com/community/file/886554014393250663/Free-Icon-Pack-1600%2B-icons Figma - Adobe Icons: https://www.figma.com/community/file/834829738797323395/Adobe-Icons   Steps Step 1: Search figma for icons (some examples above) Step 2: Copy icon as SVG Step 3: Paste SVG code in notepad and Replace all " with ' Step 4: Paste into image object in Canvas app "data:image/svg+xml;utf8, "&EncodeUrl(" SVG CODE YOU ADJUSTED IN NOTEPAD ")
Post a Comment
Read more

Power Platform: Managing Environment Variables in 'Managed Solutions'

-
Image
What Environment Variables are a great way to manage your solutions as they pass through DEV/TEST/PROD environments.  They save having to manually update flows/apps during each change and test iteration. However there is a gotcha to understand when you're planning your next migration or app update. More on Environment Variables | Microsoft Learn Why The two issues I faced using Environment Variables were due to the ' Current Value '. Issue #1 : If you don't want the value you used in DEV to push through to TEST/PROD, you need to remove the 'Current Value' from your solution BEFORE exporting it. If this is not done, and you're migrating as a  managed  solution, the 'Current Value' will flow through to your TEST environment, and cannot be changed because the solution is locked down. When a single sentence in an MS Learn article can cause so much pain... Issue #2 : If you're like me and you realised this AFTER you'd already imported into another...
Post a Comment
Read more