Power Automate is the workflow engine of the Power Platform. Essentially, "Flows" access data via connectors, then perform tasks using actions. Included is a connector for [SharePoint Online] and a few dozen actions. Some actions to highlight: Get itemsUpdate item SCENARIO Remote workers are submitting travel requests and corporate has delegated an approver per state. … Continue reading Power Automate: Populate SPO User Claims
SharePoint Online
Power Platform x SharePoint – Approval Requests: Part III (Power BI)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts: Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part III (Power BI)
Power Automate: SPOFile Share – Link Expiration
Someone asked me about anonymous sharing with expiring links. Although this could be configured at the tenant level, it isn't always set. As a workaround, how about a workflow to share a file, notify the recipient, then terminate the share? If you have a license for Power Automate, then you can create cloud Flows and … Continue reading Power Automate: SPOFile Share – Link Expiration
Microsoft 365 (The Cloud): Things You Can’t Break
Oversimplifying the cloud, it is subscribing to a company's infrastructure to store and access your files; Microsoft in this example. And with this subscription model, you may also have access to some of their software services. Keep in mind that these files and services are accessed via the internet. But you are NEVER granted too … Continue reading Microsoft 365 (The Cloud): Things You Can’t Break
Power Platform x SharePoint – Approval Requests: Part II (Power Apps)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts... Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part II (Power Apps)
SharePoint Online: Site Quota vs Tenant Storage
[SharePoint Online] is a collaboration platform. To foster collaboration across the organization, SPO facilitates the creation of intranet sites to house artifacts. Although an oversimplified breakdown, that's the gist of it. And within each site, the artifacts can be any file type supported by the tenant. But bit-by-bit, these artifacts accumulate and take up space. … Continue reading SharePoint Online: Site Quota vs Tenant Storage
OneDrive for Business: Default Open Behavior of Office Files
[OneDrive for Business] is typically synced locally to a user's computer. However, Microsoft is embracing a browser-first model for many of their roll-outs. Because of this, everyone should get more comfortable working within the browser. But heavy Office users often aren't impressed with the Online versions. Instead of choosing to open their Excel, Word, and … Continue reading OneDrive for Business: Default Open Behavior of Office Files
Power Platform x SharePoint – Approval Requests: Part I (Power Automate)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts... Power Automate - Create automated business processes.PowerApps - Create custom forms and portals.Power BI - Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using [SharePoint … Continue reading Power Platform x SharePoint – Approval Requests: Part I (Power Automate)
Power Apps: SPO People Picker Properties
Migrating to [Azure Active Directory] has companies correcting their local [Active Directory] structures. Considering AD was so forgiving, best practices weren't always adhered to. But an enterprise offering like AAD enforces better practices. Silver lining, this is great for custom solutions because user properties are now more consistent... How it Started... I created an overly … Continue reading Power Apps: SPO People Picker Properties
Training: SharePoint Online – Site Templates
[SharePoint Online] empowers teamwork with team sites. These "dynamic and productive" team sites are created using prebuilt templates to scaffold workspaces for: Projects,Departments,Divisions,etc. Classic vs. Modern For those coming from the [SharePoint Server] world, SPO has some noticeable differences. First at bat, the site template options are limited. SPS offered several different site templates for … Continue reading Training: SharePoint Online – Site Templates
Training: SharePoint – 5000 Item Limit Threshold
### What The 5,000 items list view threshold is a limit on the number of items displayed in a single SharePoint view. This is NOT a limit on how many total items a list or library can hold. ### Why This is a performance restriction. Larger database queries require more resources and more processing. This … Continue reading Training: SharePoint – 5000 Item Limit Threshold
Training Session: Graph API – OneDrive vs SharePoint
Microsoft has invested heavily into their Graph API which connects with the Office 365 services. The approach of old, CSOM, not so much as of late. But that makes sense considering the services are cloud-hosted. CSOM was perfect for solutions running on the application server, but [SharePoint Online] doesn't allow this. Going forward, the Graph … Continue reading Training Session: Graph API – OneDrive vs SharePoint
Power Apps: Cascading Columns (OOB)
Unlike [out-of-the-box] features, custom solutions incur a bit of technical debt. Though, OOB features often come with some nuances and quirks to be wary of... Scenario, use cascading columns to: Select a region,Select a state,Select a city, andView a dynamic list of artists. Again, SQL tables are great, but [SharePoint Online] lists are easy to … Continue reading Power Apps: Cascading Columns (OOB)
Power Apps: Cascading Columns (custom)
Cascading columns are important to many applications, but often require custom solutions. Although the functionality is available out-of-the-box in Power Apps, custom solutions are still fun to build... For the uninitiated, cascading columns are essentially dropdowns that control the available selections of the next dropdown: e.g., Dropdown #1 - US StatesDropdown #2 - US CitiesDropdown … Continue reading Power Apps: Cascading Columns (custom)
Power Apps: SPO Document Library Upload
Power Apps is a Microsoft offering to quickly build business apps using pre-built templates. The content of these business apps is housed in various data sources, but presented via data connectors. Data connectors are essential to these business apps... Noteworthy, the [SharePoint Online] connector is a common Power App connection. For many organizations, if they're … Continue reading Power Apps: SPO Document Library Upload
console.log('Charles'); 