Closing out this story, the Power Automate flow built to copy Outlook emails to [SharePoint Online] should have copied the email attachments as well. Though not every email has attachments. Tweak the flow and check for attachments, then copy when necessary... Reviewing a previous flow run, examine an export of the tempObj variable. Take note … Continue reading Power Automate: Copy Emails + Attachments to SPO
Office 365
Power Automate: Copy Emails to SPO
Once upon a time there was a very special user. This user was great at their job and worked with us for many years. Throughout the years, their job responsibilities required that they catalogue and archive legal records for the business. Unfortunately, soon enough, they were ready for new career opportunities. Now, they needed to … Continue reading Power Automate: Copy Emails to SPO
SharePoint: Modern Site Architecture (Hub v. Sub)
Microsoft is encouraging organizations to embrace Modern SharePoint. With this nudging, creating sub-sites is still supported, but largely frowned upon. Though Classic SharePoint welcomes sub-sites. Modern SharePoint, not so much. Instead, Microsoft now recommends creating all sites as their own site collection, then associating sites using hub linkage... To better conceptualize the hub idea, consider … Continue reading SharePoint: Modern Site Architecture (Hub v. Sub)
Power Automate: Working w/ Arrays
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
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
console.log('Charles'); 