The Power Platform prides itself on being low-code. While accurate, each solution requires different levels of coding. Power Automate, the low-code workflow creator, empowers developers to use variables when coding their business automations... Among the available variable types, array is a common data structure in many programming languages. For the uninitiated, arrays are essentially collections … Continue reading Power Automate: Working w/ Arrays
Author: Charles
Power Apps: Name Randomizer
The gift giving season is here. Keeping with the festivities, many organizations are hosting virtual raffles. There are plenty of online name randomizers available, but building and personalizing a Power App is also an option... The raffle names can pull from almost any data source, or sources, but for testing, these names are manually entered … Continue reading Power Apps: Name Randomizer
Power BI: What If… Citizen Insights?
Microsoft is on a mission to empower everyone through technology. Whilst on this journey, they crafted the Power Platform and gave the world Power BI. At that moment, Microsoft empowered thousands of citizen developers to gather insights using their respective business datasets. Citizens could create richer data visualizations and analyze more data from varying sources... … Continue reading Power BI: What If… Citizen Insights?
Power Apps: What If… Fusion Teams?
Many have forecasted a developer deficit for some time now. Whether or not the numbers are exaggerated, companies are looking for more and more qualified developers. This has become even more evident as every company is gradually becoming a tech company. Essentially, the specialized skills of computer scientists, software engineers, programmers, etc. are being outpaced … Continue reading Power Apps: What If… Fusion Teams?
Power Automate: What If… Automation?
Automation is already a thing in our lives, in particular: Email - Inbox rules.Scheduled emails.Automatic replies. Banking -Balance alerts.Scheduled autopay.Monthly transfers Digital Assistants -Set a reminder.Schedule <event>.Call <person>. However, these are usually single action workflows. Something, the "trigger", prompts an activity, the "action". Depending on the activity, people may still need to carry out some … Continue reading Power Automate: What If… Automation?
Microsoft Teams: What If… Collaboration?
Microsoft Teams has gained a lot of traction these past few years. Replacing Skype for Business as the go-to business communication tool, it has cemented itself as a centralized hub for collaboration. And as Microsoft continually rolls out more enhancements, Teams becomes more accessible to more people. To encourage collaboration, Teams can tie-in dozens of … Continue reading Microsoft Teams: What If… Collaboration?
Power Automate: Valid Date/Time Inputs
Power Automate is the workflow engine of Microsoft's Power Platform, and flows come in many shapes and sizes. Often though, flows are created just to move data between systems. All data moves involve an ETL process, but to properly transform data, the extracted data must be properly structured. For example, extracting and formatting datetimes values. … Continue reading Power Automate: Valid Date/Time Inputs
SharePoint: What If… Metadata?
Metadata is baked into SharePoint. Even so, many people use SharePoint just for document storage and never explore metadata. But without metadata, SharePoint isn't living up to its full potential. What is metadata? Why is metadata important? For simplicity, think of metadata as "document tagging"/ "document categorization". With the documents tagged, search gets leveled up. … Continue reading SharePoint: What If… Metadata?
Graph API: Follow SharePoint Online Sites
[SharePoint Online] has several social media-esque features baked into the solution. One such feature, choosing to "follow" specific SPO sites. But this is a manual action performed by each individual. That is, unless the Microsoft Graph API is used to follow a site on a person's behalf... Figure 1 - SharePoint Online sites being followed. … Continue reading Graph API: Follow SharePoint Online Sites
Power Apps: Recreating… Twitter
At last, closing out the Power App recreation series. Kicking things off, the first app mocked up Instagram. Nothing fancy, but the app used two galleries populated from two Excel data sources. The second app roughly recreated Netflix and again, used two galleries and two Excel data sources. However, app #2 used the Filter() function … Continue reading Power Apps: Recreating… Twitter
Graph API: Building and Working w/ Batches
Several of the Microsoft 365 resources are accessible through the Microsoft Graph REST API. As adoption grows, Microsoft introduces more resources and more APIs. But with this increased adoption, customers are generating more and more API requests. And when too many requests are generated too quickly, Microsoft will throttle. This results in a series of … Continue reading Graph API: Building and Working w/ Batches
Power Apps: Recreating… OneDrive Photos
As the series continues, there is a common element among the apps. At their core, many popular apps have gallery experiences. Even the OneDrive app could be created using a vertical gallery for its photo grid... Setting the app foundation, count the total number of images in the data source. The app displays three images … Continue reading Power Apps: Recreating… OneDrive Photos
SharePoint Online: Sync vs OneDrive Shortcut
Microsoft 365 is ever changing. Released many, many months ago, Add shortcut to OneDrive remains a mystery to some people. This is different than Sync, right? Figure 1 - SharePoint Online Contextual Menu options. Somewhat different, but a lot of the same. Even so, the shortcut link delivers on its promise. Shortcuts link to specific … Continue reading SharePoint Online: Sync vs OneDrive Shortcut
Power Apps: Recreating… Office App
User-centered design should really be at the core of all app development. Functionality is essential, but a poorly designed interface can sink any app. With this in mind, more time should be invested in designing Power Apps... Next in the series, recreating the Office App with SharePoint Online as a data source: Figure 1 - … Continue reading Power Apps: Recreating… Office App
Azure AD: SharePoint Online User Cache
[SharePoint Online] sites can use [Azure AD] security groups to manage user access and permissions. Noteworthy, these security groups can be applied directly to sites, lists, and/ or items. And every security group used on the SPO site is saved to the site member list. This member list roughly functions as a site cache and … Continue reading Azure AD: SharePoint Online User Cache
console.log('Charles'); 